BMC Aptune SQL statement DEtail analysis

duam lee

BMC Aptune SQL statement DEtail analysis


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

_____________________________________________________________________

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

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

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

Robert Catterall

Re: BMC Aptune SQL statement DEtail analysis
(in response to duam lee)
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]>

>
> 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 >
>
> ------------------------------
>
> [image: IDUG - The Worldwide DB2 User Community! ] < 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

_____________________________________________________________________

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

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

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