Detail Line descriptions
- Plan Name
- This is the name of the DB2® plan for which the following Class 3 wait times are accumulated.
- Database I/O
- This is the accumulated I/O elapsed wait time for database I/O.
- Read I/O other
- This is the accumulated wait time for read I/O that was done under a thread other than the one being measured.
- Write I/O other
- This is the accumulated wait time for write I/O that was done under a thread other than the one being measured.
- IRLM Lock/Latch
- This is the accumulated wait time due to local contention for locks.
- DB2 Latch
- This is the accumulated wait time due to latch contention.
- Page Latch
- This is the accumulated wait time due to page latch contention.
- Log Write I/O
- This is the accumulated wait time for a log write I/O.
- Log Read
- This is the accumulated wait time for archive reads, active reads, and active log prefetch reads.
- ARC LOG QUIESCE
- This is the accumulated wait time due to processing of ARCHIVE LOG MODE(QUIESCE) commands.
- Phase 1 Write
- This is the accumulated wait time for commit phase 1 database write I/O completion.
- TCP/IP LOB/XML
- This is the accumulated wait time for TCP/IP LOB and XML materialization.
- Glbl Contention
- This is the accumulated wait time due to global contention for parent L-locks.
- Group Messages
- This is the accumulated wait time due to sending of messages to other DB2 members in the data sharing group.
- CF Requests
- This is the accumulated wait time for IXLCACHE and IXLFCOMP asynch requests.
- Drain Lock
- This is the accumulated wait time for a drain lock.
- Claim Release
- This is the accumulated wait time for a drain when waiting for claims to be released.
- Task Switch: COMMIT
- This is the accumulated wait time due to synchronous execution unit switching for DB2 commit, abort, or deallocation processing.
- Task Switch: OPEN/CLOSE
- This is the accumulated wait time due to synchronous execution unit switching to the DB2 Open/Close data set service or the HSM recall service.
- Task Switch: SYSLGRNG
- This is the accumulated wait time due to synchronous execution unit switching to the DB2 SYSLGRNG recording service. This service is also sometimes used for level-id checking for down level detection.
- Task Switch: Data Manager
- This is the Accumulated wait time due to synchronous execution unit switching to the DB2 Dataspace Manager Services, which include; Define data set, Extend data set, Delete data set, Reset data set, and VSAM catalog access.
- Task Switch: Other
- This is the accumulated wait time due to synchronous execution unit switching to other DB2 service tasks.