Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need help with below queries

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
ashek15

New User


Joined: 20 Oct 2015
Posts: 31
Location: USA

PostPosted: Thu Mar 23, 2017 1:38 am    Post subject: Need help with below queries
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

Senior Member


Joined: 21 Sep 2010
Posts: 1676
Location: NY,USA

PostPosted: Thu Mar 23, 2017 9:09 pm    Post subject:
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: 31
Location: USA

PostPosted: Thu Mar 23, 2017 9:59 pm    Post subject: Reply to: Need help with below queries
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: 8028
Location: Bellevue, IA

PostPosted: Thu Mar 23, 2017 10:12 pm    Post subject: Reply to: Need help with below queries
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm
No new posts Selective execution of a queries Delip DB2 9 Fri Jan 16, 2015 3:51 pm
No new posts Re-write queries to minimize the effe... Anil Khanna DB2 6 Mon Aug 04, 2014 1:49 pm
No new posts Running multiple queries in a PS file... nikhil_bansal04 JCL & VSAM 12 Wed Dec 18, 2013 12:06 pm
No new posts Mainframe Laguagae Environment Relate... Subramanin,Govindarajan All Other Mainframe Topics 1 Thu Jan 31, 2013 11:15 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us