IBM Mainframe Forum

Hi,

Pls let me know if there are any tools for checking the performance of SQL.

Hello,

Use EXPLAIN to see which choices the Optimizer has made.

Talk with your system support people and ask if there are any performance monitors in use on the system.

you can run strobe and see which sql in the application is taking most time.The strobe report will show which query took most time in terms of CPU usage

CS1496897:

First, you're replying to a topic that was started more than 3 years ago.

Second, are you aware that STROBE is a vendor product, not part of base z/OS, for which a significant amount of money (we looked at it about 10 years ago and the price was $100,000 US at that time for the base NOT including DB2) must be paid before it can be installed and used? Hence telling someone to use STROBE may be useless advice since their site may not have the product installed.