IFCID 213 - Drain Lock Wait Start

This topic shows detailed information about Record Trace - IFCID 213 - Drain Lock Wait Start.

This record contains information about the beginning of a wait for a drain lock. For drain locks, this record is written instead of IFCID 44.

Record trace - IFCID 213 - Drain Lock Wait Start

The field labels shown in the following sample layout of Record Trace - IFCID 213 - Drain Lock Wait Start are described in the following section.


LOCK HASH VALUE: X'00000000'                       LOCK NAME LENGTH:    8          LOCK QUALIFIER: X'0020'
LOCK RES TYPE: CS-READ DRAIN LOCK                    DBID: 1                   OBID: 2           PARTITION:     3
IRLM FUNCTION:  LOCK                          STATE: X'00'                    DURATION: X'00'
REASON SUSP: LATCH CONTENTION
QW0213FL  X'00'

LOCK HASH VALUE

The hash value of the locked resource.

Field Name: QW0213LH

LOCK NAME LENGTH

The length of the lock name.

Field Name: QW0213LK

LOCK QUALIFIER

The lock qualifier.

Field Name: QW0213KQ

LOCK RES TYPE

The locked resource type or the type of locking operation.

Field Name: QW0213KT

DBID

The database ID of the object of the claim request.

Field Name: QW0213DB

PSID

The page set identifier of the object of the claim request.

Field Name: QW0213PS

PARTITION NO.

The partition number of the object of the lock request. This field contains 0 if the table space or index space is not partitioned (and the lock request is at the page set level rather than the logical partition level).

Field Name: QW0213PT

IRLM FUNCTION

The IRLM function.

Field Name: QW0213FC

STATE

The lock state.

Field Name: QW0213ST

REASON SUSP

The reason for the suspension.

Field Name: QW0213WS