Longest Lock, Latch I/O Wait

This topic shows detailed information about Accounting - Longest Lock, Latch I/O Wait.

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 I/O Wait

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


LONGEST LOCK, LATCH, I/O WAIT                        VALUE
----------------------------- ----------------------------
ELAPSED TIME                                      0.007445
WAIT TYPE                                              N/P
SOURCE ACE                                             N/P
DBID FOR SYNC/ASYNC I/O                                333
OBID FOR SYNC/ASYNC I/O                                 40
LOCK HASH                                      X'014D0028'
LOCK NAME                      X'0000005D7929CC3800000000'
LOCK RES TYPE                                        X'5D'
LATCH CLASS                                             40
LATCH TOKEN                            X'0000005D7929CC38'
BEGIN TIME                                 12:26:45.022128
END TIME                                   12:26:45.029574                                                          

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                      1.221780
SOURCE ACE                             N/P
RESOURCE MANAGER ID                     18
FUNCTION CODE                          101
BEGIN TIME                 12:26:27.176745
END TIME                   12:26:28.398525
LONGEST LOCK, LATCH, I/O WAIT - ELAPSED TIME

Wait length for longest lock/latch waits.

Field Name: QLLLRDT

LONGEST LOCK, LATCH, I/O WAIT - WAIT TYPE

Type of operation that incurred the longest wait time.

Field Name: QLLLTYP

LONGEST LOCK, LATCH, I/O WAIT - SOURCE ACE

Agent Control Element (ACE) address for longest lock/latch waiter.

Field Name: QLLLRACE

LONGEST LOCK, LATCH, I/O WAIT - DBID FOR SYNC/ASYNC I/O

Database ID for synchronous/asynchronous I/O waits.

Field Name: QLLLDB

LONGEST LOCK, LATCH, I/O WAIT - OBID FOR SYNC/ASYNC I/O

Object ID for synchronous/asynchronous I/O waits.

Field Name: QLLLOB

LONGEST LOCK, LATCH, I/O WAIT - LOCK HASH

Lock hash for longest lock/latch waits.

Field Name: QLLLLH

LONGEST LOCK, LATCH, I/O WAIT - LOCK NAME

Lock name for IRLM lock.

Field Name: QLLLLK

LONGEST LOCK, LATCH, I/O WAIT - LOCK RES TYPE

Type of lock resource

Field Name: QLLLLKRE

LONGEST LOCK, LATCH, I/O WAIT - LATCH CLASS

Latch class for longest lock/latch waits.

Field Name: QLLLLC

LONGEST LOCK, LATCH, I/O WAIT - LATCH TOKEN

Latch token for longest lock/latch waits.

Field Name: QLLLLA

LONGEST LOCK, LATCH, I/O WAIT - BEGIN TIME

Begin time for longest lock/latch waits.

Field Name: QLLLRBT

LONGEST LOCK, LATCH, I/O 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