View previous topic :: View next topic
|
Author |
Message |
ashek15
New User
Joined: 20 Oct 2015 Posts: 48 Location: USA
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Something that your performance and capacity people should be able to help with. |
|
Back to top |
|
|
ashek15
New User
Joined: 20 Oct 2015 Posts: 48 Location: USA
|
|
|
|
Thanks for the reply..can this detail be gathered with the help of any 3rd party tool like omegamon, apptune? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
ashek15
New User
Joined: 20 Oct 2015 Posts: 48 Location: USA
|
|
|
|
Thanks for details. I would try to get the details from them. |
|
Back to top |
|
|
|