Page 1 of 1

performance of SQL

PostPosted: Wed Nov 25, 2009 4:07 pm
by rajeswarilt
Hi,

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

Re: performance of SQL

PostPosted: Thu Nov 26, 2009 1:23 am
by dick scherrer
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.

Re: performance of SQL

PostPosted: Mon Dec 17, 2012 8:33 pm
by CS1496897
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

Re: performance of SQL

PostPosted: Mon Dec 17, 2012 8:40 pm
by Robert Sample
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.