Please advise if any of you know about a tool that comes with the WF product and matches the following description .....

"You key-in SQL in its editor and set it up to execute the query mutiple-times in succession, to do Stress/Load testing against the Database".

My manager vaguely remembers seeing such a write-up in one of our WF-Contract documents from IBI a few weeks back. But cannot find it again now. I scanned these Forums and IBI documentation with no avail.

Please chime in if you are aware of such an animal.

TIA,
Sandeep Mamidenna.

I don't know of a particular tool, but you can use WebFOCUS code to do this. Simply use Dialogue Manager looping code (-REPEAT) to execute SQL pass-through a certain number of times.

Here's an example:

SET SQLENGINE=SQLORA
SQL SET SERVER sris_prd.world
-RUN

-REPEAT ENDLOOP1 5000 TIMES

SQL 
SELECT 
...
TABLE ON TABLE HOLD AS HOLD01 FORMAT ALPHA
END
-RUN

-ENDLOOP1

You can run stress tests from the WebFOCUS Web Console (The URL usually is http://server-name:8121/cgiatt.exe)

See this documentation (you will need to log in to IBI Tech Support): http://documentation.informationbuilders.com/masterinde...adm76/07editing5.htm

Help is also available from the Web Console.

Thanks so much for your prompt input Francis. I did manage to get to the web console using a different port. Then, the first instruction in your referenced document said -
>> "Select Procedures from the Web Console menu bar."

However, I did not see any such option in our web console. The only ones I had were - (Workspace , Listeners, Diagnostics & Version).
Am I missing something else here?

Sandeep Mamidenna

I may add that I also got to the console directly via...
WF-server>Programs> WF 52 Client> Console
and it made no difference.

And I do have Admin rights with the user-id that I am logged in with, in case that makes any difference.

Sandeep Mamidenna

your signature shows that you are running in a DB2 environment, I would suggest using the SQL Performance monitor functionality of your DB2 client software.

By default, the user is IBI, just set up your monitor for only user of IBI and you'll see all SQL run against your DB2 database whiel the monitor is running, you can then use the visual explain tool.

This is a valid solution if you are trying to find the chokepoint in the database, if you have something wrong in your connectivity to the database, it will not help you.

If your stress-test has nothing to do with WebFOCUS, then i would follow Jason K.'s advice, though I'm not sure about the default User ID being IBI.

This is the WebFOCUS 5.3.4 web console:


You're on 5.2.6. I haven't worked with that in a while, so I'm not sure which options are available.

Our current 5.2x console is very different from your pic Francis. Maybe those options are for 5.3x. Thanks anyway for all your time and input on this Francis.

And to you too Jason K. We already have processes in place using various DB2 utilities. But just wanted to delve into this WF-tool too, if one such thing existed with our current WF version.

Sandeep Mamidenna.