IFCID 003 - Longest Lock/Latch Waiter

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

This data block shows longest lock latch wait information. It is recorded from the longest delta time in one of the followings waits: SYNCHRONOUS I/O WAIT, BEGIN LOCK/LATCH WAIT, BEGIN ASYNCHRONOUS I/O WAIT, BEGIN DRAIN LOCK WAIT in addition, it will also record the longest service task wait and the page latch wait.

Record Trace - IFCID 003 - Longest Lock/Latch Waiter

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


                                        LONGEST LOCK/LATCH WAITER

LOCK/LATCH, SYNC/ASYNC I/O, DRAIN LOCK:                   SERVICE TASK:
------------------------------------------------------    -----------------------------------------------
DBID FOR SYNC/ASYNC I/O.: DSNDB06                         RMID.................:                        3
OBID FOR SYNC/ASYNC I/O.: DSNHBX01                        FUNCTION CODE........:                       73
LOCK HASH...............:                  X'0006029A'    ACE ADDRESS..........:                      N/P
LATCH CLASS.............:                      X'029A'    BEGIN TIME...........: 09/23/22 10:30:07.184961
LATCH TOKEN.............:                          N/P    END TIME.............: 09/23/22 10:30:07.213433
ACE ADDRESS.............:                          N/P    DELTA TIME...........:                 0.028472
WAIT TYPE...............:                    DB2 - I/O
BEGIN TIME..............:     09/23/22 10:30:07.177982
END TIME................:     09/23/22 10:30:07.181802
DELTA TIME..............:                     0.003820

PAGE LATCH WAIT INFORMATION:                              OTHER INFORMATION:
------------------------------------------------------    -----------------------------------------------
DATABASE ID.............: DSNDB07                         ROLLUP ID............:                      N/P
PAGESET ID..............: DSN32K00
ACE ADDRESS.............:          X'0000000026AEC520'
PAGE NUMBER.............:                            1
PARTITION NUMBER........:                          N/P
BEGIN TIME..............:     09/23/22 10:30:07.177982
END TIME................:     09/23/22 10:30:07.181802
DELTA TIME..............:                     0.003820

DBID FOR SYNC/ASYNC I/O

DBID for I/O.

Field Name: QLLLDB

OBID FOR SYNC/ASYNC I/O

OBID for I/O.

Field Name: QLLLOB

LOCK HASH

Lock hash.

Field Name: QLLLLH

LATCH CLASS

Latch class.

Field Name: QLLLLC

LATCH TOKEN

Latch token.

Field Name: QLLLLA

ACE ADDRESS

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

Field Name: QLLLRACE

WAIT TYPE

Type of operation that incurred the longest wait time.

Field Name: QLLLTYP

BEGIN TIME

Begin time for longest lock/latch waits.

Field Name: QLLLRBT

END TIME

End time for longest lock/latch waits.

Field Name: QLLLRET

DELTA TIME

Delta time for longest lock/latch waits.

Field Name: QLLLRDT

DATABASE ID

Database id.

Field Name: QLLLPIDB

PAGESET ID

Pageset id.

Field Name: QLLLPISB

ACE ADDRESS

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

Field Name: QLLLPIACE

PAGE NUMBER

Page number.

Field Name: QLLLPG

PARTITION NUMBER

Part number.

Field Name: QLLLPA

BEGIN TIME

Page latch wait begin time.

Field Name: QLLLPIBT

END TIME

Page latch wait end time.

Field Name: QLLLPIET

DELTA TIME

Page latch wait delta time.

Field Name: QLLLPIDT

RMID

Rmid.

Field Name: QLLLID

FUNCTION CODE

Function code.

Field Name: QLLLFC

ACE ADDRESS

Agent Control Element (ACE) address for longest service task waiter.

Field Name: QLLLSACE

BEGIN TIME

Begin time for service task wait.

Field Name: QLLLSBT

END TIME

End time for service task wait.

Field Name: QLLLSET

DELTA TIME

Delta time for service task wait.

Field Name: QLLLSDT

ROLLUP ID

The type of rollup record.

Field Name: QLLLRUID