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

Need to identify top 10 costly or time consuming SQL


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: Wed Feb 14, 2018 3:20 am
Reply with quote

Hi All

Is there a way we can identify top 10 costly or time consuming SQLs in DB2 z/OS.

Thanks much.

Regards
ashek15
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8794
Location: Welsh Wales

PostPosted: Wed Feb 14, 2018 12:32 pm
Reply with quote

Something that your performance and capacity people should be able to help with.
Back to top
View user's profile Send private message
ashek15

New User


Joined: 20 Oct 2015
Posts: 48
Location: USA

PostPosted: Thu Feb 15, 2018 6:25 am
Reply with quote

Thanks for the reply..can this detail be gathered with the help of any 3rd party tool like omegamon, apptune?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8794
Location: Welsh Wales

PostPosted: Thu Feb 15, 2018 12:21 pm
Reply with quote

Hi, the Perf & Cap people would probably use SAS with either MXG or MICS to capture and analyse the SMF data for CPU and other resource usage for any given task and any subtasks spawned.

They should have this info to hand immediately if they're doing their jobs correctly.
Back to top
View user's profile Send private message
ashek15

New User


Joined: 20 Oct 2015
Posts: 48
Location: USA

PostPosted: Fri Feb 16, 2018 10:38 am
Reply with quote

Thanks for details. I would try to get the details from them.
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 Modify Several JCLs at the Same Time JCL & VSAM 6
No new posts How to process dependent file based o... JCL & VSAM 8
No new posts Identify the count from two diffrent ... DFSORT/ICETOOL 19
No new posts reffering the filename with date and ... JCL & VSAM 9
No new posts Identify the value if the SUM of the ... SYNCSORT 4
Search our Forums:

Back to Top