| View previous topic :: View next topic |
| Author |
Message |
whizkid79
Beginner
Joined: 29 Sep 2004
Posts: 53
Topics: 14
|
 Posted: Wed Sep 29, 2004 6:28 pm Post subject: Check the performance of a running SQL query? |
 |
|
| How can I check the performance of a DB2 SQL that is running? I need to know whether the query is running fast or slow or moderate.[/code] |
|
| Back to top |
|
 |
R.Nickel
Beginner
Joined: 02 Dec 2002
Posts: 22
Topics: 0
Location: Sydney, Australia
|
| Posted: Wed Sep 29, 2004 6:49 pm Post subject: |
|
|
Does your shop have strobe ?
_________________
Rainer |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
|
| Posted: Wed Sep 29, 2004 7:02 pm Post subject: |
|
|
Whizkid79,
If you have Omegamon at your shop , you can look at the status of your SQL execuetion.It shows the db2 statement execueting.you can use EXPLAIN to check if the query is using the index or is it going for a tablespace scan.
check this link for running explain
http://www.mvsforums.com/helpboards/viewtopic.php?t=215&highlight=explain
For a Rough estimate of elapsed time for your query you can try the following sql
| Code: |
SELECT CURRENT TIMESTAMP
FROM SYSIBM.SYSDUMMY1;
<code your sql statement here>
SELECT CURRENT TIMESTAMP
FROM SYSIBM.SYSDUMMY1;
|
Now subtract the before timestamp from your after timestamp.
You can also use DB2 ESTIMATOR a standalone tool for estimating the performance of applications for DB2.
check this link for more information
http://www-306.ibm.com/software/data/db2/os390/v6facts/estimate.html
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
whizkid79
Beginner
Joined: 29 Sep 2004
Posts: 53
Topics: 14
|
| Posted: Wed Sep 29, 2004 10:55 pm Post subject: |
|
|
H Kolusu,
I dont have omegamon. I have DB2I. Can i use the Detector tool in that in any way? |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
