BMC Aptune SQL statement DEtail analysis

David Barry

BMC Aptune SQL statement DEtail analysis
Check with BMC. My guess is it's their measure of what IBM refers to as "unaccounted time." We see it sometimes in PM reports, and usually it is a sign of CPU starvation. Other causes are discussed at: http://www-01.ibm.com/support/docview.wss?rs=64&uid=swg21045823

DB2 Class 2 Not Accounted Time =

DB2 Class 2 Elapsed time -
(DB2 Class 2 CPU time + DB2 Class 3 suspension time)

< http://www-01.ibm.com/support/docview.wss?rs=64&uid=swg21045823 >


Dave Barry
Sr. Performance & Capacity Planning Analyst
UPS
________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Catterall
Sent: Monday, December 14, 2009 2:03 PM
To: [login to unmask email]
Subject: Re: [DB2-L] BMC Aptune SQL statement DEtail analysis

Assuming that the "other wait time" figure is obtained from fields in DB2 for z/OS accounting trace class 3 records, it could include time spent waiting for DB2 to perform various services for the application process, such as preformatting space in a data set (for insert processing), extending a data set (also for insert processing), commit processing, and deallocation processing. If you're running DB2 in data sharing mode, it could also include wait time due to global lock contention.

Robert


2009/12/14 duam lee <[login to unmask email]<mailto:[login to unmask email]>>

Hi All,

Can any one tell me the Other wait time in BMC aptune's sql statement detail analysis? I mean what could be the causes for this. When I check the details of SQLs which are taking how much time in I get for most of the sqls the other wait time as more. The example below is an exception. But I am interested to know whether this is other db2 wait time or other wait time. What could be the causes for this? Thanks to all of you for valuable inputs.

Average Per
Event Total SQL Call
---------------------------------- ----------- -----------
IN-SQL CPU Time...................: 03:01.85163 00:00.00012
Sync I/O Time.....................: 11:55.03488 00:00.00046
Async I/O Time....................: 00:04.92680 00:00.00000
Lock Time.........................: 01:17.76880 00:00.00005
Other Wait Time...................: 00:42.45932 00:00.00003

With Thanks
Duam.




________________________________
Windows Live Hotmail: Your friends can get your Facebook updates, right from Hotmail¢ç. < http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_4:092009 >

________________________________

< http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >



--
Robert Catterall
Catterall Consulting
www.catterallconsulting.com < http://www.catterallconsulting.com >

________________________________

[ http://www.idug.org/images/M_images/idug%20na3.jpg ] < http://www.idug.org/db2-north-america-conference/index.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L