Longest Lock/Latch Waiter

This topic shows detailed information about Accounting - Longest Lock/Latch Waiter.

This block shows information about the longest lock/latch, page latch and service task waits incurred during the execution of the thread.

Accounting - Longest Lock/Latch Waiter

The field labels shown in the following sample layout of Accounting - Longest Lock/Latch Waiter are described in the following section.


LONGEST LOCK/LATCH WAIT                      VALUE
----------------------- --------------------------
ELAPSED TIME                             32.848157
WAIT TYPE                               DB2 - LOCK
SOURCE ACE                                     N/P
DBID FOR SYNC/ASYNC I/O                        N/P
OBID FOR SYNC/ASYNC I/O                        N/P
LOCK HASH                              X'00010372'
LATCH CLASS                                    N/P
LATCH TOKEN                                    N/P
BEGIN TIME                         12:24:50.373928
END TIME                           12:25:23.222085

LONGEST PAGE LATCH WAIT            VALUE
----------------------- ----------------
ELAPSED TIME                         N/P
SOURCE ACE                           N/P
DATABASE ID                          N/P
PAGESET ID                           N/P
PAGE NUMBER                          N/P
PARTITION NUMBER                     N/P
BEGIN TIME                           N/P
END TIME                             N/P

LONGEST SERVICE TASK WAIT            VALUE
------------------------- ----------------
ELAPSED TIME                      0.002441
SOURCE ACE                             N/P
RESOURCE MANAGER ID                     24
FUNCTION CODE                           65
BEGIN TIME                 12:25:23.222229
END TIME                   12:25:23.224670

LONGEST LOCK/LATCH WAIT - ELAPSED TIME: Wait length for longest lock/latch waits.; Field Name: QLLLRDT
LONGEST LOCK/LATCH WAIT - WAIT TYPE: Type of operation that incurred the longest wait time.; Field Name: QLLLTYP
LONGEST LOCK/LATCH WAIT - SOURCE ACE: Agent Control Element (ACE) address for longest lock/latch waiter.; Field Name: QLLLRACE
LONGEST LOCK/LATCH WAIT - DBID FOR SYNC/ASYNC I/O: Database ID for synchronous/asynchronous I/O waits.; Field Name: QLLLDB
LONGEST LOCK/LATCH WAIT - OBID FOR SYNC/ASYNC I/O: Object ID for synchronous/asynchronous I/O waits.; Field Name: QLLLOB
LONGEST LOCK/LATCH WAIT - LOCK HASH: Lock hash for longest lock/latch waits.; Field Name: QLLLLH
LONGEST LOCK/LATCH WAIT - LATCH CLASS: Latch class for longest lock/latch waits.; Field Name: QLLLLC
LONGEST LOCK/LATCH WAIT - LATCH TOKEN: Latch token for longest lock/latch waits.; Field Name: QLLLLA
LONGEST LOCK/LATCH WAIT - BEGIN TIME: Begin time for longest lock/latch waits.; Field Name: QLLLRBT
LONGEST LOCK/LATCH WAIT - END TIME: End time for longest lock/latch waits.; Field Name: QLLLRET
LONGEST PAGE LATCH WAIT- ELAPSED TIME: Wait length for longest page latch waits.; Field Name: QLLLPIDT
LONGEST PAGE LATCH WAIT- SOURCE ACE: Agent Control Element (ACE) address for longest page latch waiter.; Field Name: QLLLPIACE
LONGEST PAGE LATCH WAIT- DATABASE ID: Database ID for longest page latch waits.; Field Name: QLLLPIDB
LONGEST PAGE LATCH WAIT- PAGESET ID: Pageset ID for longest page latch waits.; Field Name: QLLLPISB
LONGEST PAGE LATCH WAIT- PAGE NUMBER: Page number for longest page latch waits.; Field Name: QLLLPG
LONGEST PAGE LATCH WAIT- PARTITION NUMBER: Partition number for longest page latch waits.; Field Name: QLLLPA
LONGEST PAGE LATCH WAIT- BEGIN TIME: Page latch wait begin time.; Field Name: QLLLPIBT
LONGEST PAGE LATCH WAIT- END TIME: Page latch wait end time.; Field Name: QLLLPIET
LONGEST SERVICE TASK WAIT- ELAPSED TIME: Wait length for service task waits.; Field Name: QLLLSDT
LONGEST SERVICE TASK WAIT- SOURCE ACE: Agent Control Element (ACE) address for longest service task waiter.; Field Name: QLLLSACE
LONGEST SERVICE TASK WAIT- RESOURCE MANAGER ID: Resource manager ID (RMID) of the Resource Manager that performs the service.; Field Name: QLLLID
LONGEST SERVICE TASK WAIT- FUNCTION CODE: Function code for the function that the service task performs.; Field Name: QLLLFC
LONGEST SERVICE TASK WAIT- BEGIN TIME: Begin time for service task waits.; Field Name: QLLLSBT
LONGEST SERVICE TASK WAIT- END TIME: End time for service task waits.; Field Name: QLLLSET