performance of SQL



IBM's flagship relational database management system

performance of SQL

Postby rajeswarilt » Wed Nov 25, 2009 4:07 pm

Hi,

Pls let me know if there are any tools for checking the performance of SQL.
rajeswarilt
 
Posts: 6
Joined: Wed Sep 16, 2009 12:27 pm
Has thanked: 0 time
Been thanked: 0 time

Re: performance of SQL

Postby dick scherrer » Thu Nov 26, 2009 1:23 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: performance of SQL

Postby CS1496897 » Mon Dec 17, 2012 8:33 pm

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
 
Posts: 5
Joined: Tue Dec 11, 2012 4:52 pm
Has thanked: 0 time
Been thanked: 0 time

Re: performance of SQL

Postby Robert Sample » Mon Dec 17, 2012 8:40 pm

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.
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post