View previous topic :: View next topic
|
Author |
Message |
ashek15
New User
Joined: 20 Oct 2015 Posts: 48 Location: USA
|
|
|
|
Hi All
Can anybody plesase suggest how to find out below details on DB2 z/OS
1) top 10 long running queries
2) top 10 long running stored procedures
Thanks. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
Firm wide ? You can't easily by yourself. Get your management invest something on third party products like OMEGAMON or anything to have it accurately monitored. |
|
Back to top |
|
|
ashek15
New User
Joined: 20 Oct 2015 Posts: 48 Location: USA
|
|
|
|
Thanks for the reply..however data is needed for last 2-3 months..we have omegamon but query gets disappears as soon as it finishes running..is there any other way to get past data? |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
You'll most likely have to use the SMF records, assuming that your site records them for DB2, to do what you want. If your site has MICS or MXG for processing SMF records, check with your site support group as to what DB2 data is available and how long it is kept. If your site doesn't have a product to process SMF records, you could be in for a long development time to pull the data from SMF and report on it. |
|
Back to top |
|
|
|