db2 wait events?

From: kyle Hailey <kylelf_at_gmail.com>
Date: Sat, 12 Jul 2008 06:30:43 -0700
Message-ID: <6f373fd20807120630g79540ac4ib0e25a0a854753a@mail.gmail.com>


Anyone work with DB2 and know if they have wait events? I'm looking into doing monitoring across databases and have found wait states similar to Oracle on SQL Server and Sybase, but on DB2, which I though would be the most instramented, I only find process state such as (sort of like time model in 10g or more closely the new state fields in ASH in 11g)

   Fetch
   Cursor
   Execution
   Operation
   Transaction
   Connectivity
 and not wait such as
   I/O
   Lock
   CPU
which are available across Oracle, SQL Server and Sybase.

Best WIshes
Kyle Hailey

http://perfvision.com
http://ashmasters.com

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jul 12 2008 - 08:30:43 CDT

Original text of this message