IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need help with below queries


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ashek15

New User


Joined: 20 Oct 2015
Posts: 48
Location: USA

PostPosted: Thu Mar 23, 2017 1:38 am
Reply with quote

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
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Thu Mar 23, 2017 9:09 pm
Reply with quote

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
View user's profile Send private message
ashek15

New User


Joined: 20 Oct 2015
Posts: 48
Location: USA

PostPosted: Thu Mar 23, 2017 9:59 pm
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Thu Mar 23, 2017 10:12 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Index related queries DB2 5
No new posts Running queries against OLTP Database DB2 3
No new posts Selective execution of a queries DB2 9
No new posts Re-write queries to minimize the effe... DB2 6
No new posts Running multiple queries in a PS file... JCL & VSAM 12
Search our Forums:

Back to Top