IFCID 021 - Lock Detail

This topic shows detailed information about "Record Trace - IFCID 021 - Lock Detail".

Record trace - IFCID 021 - Lock Detail

The field labels shown in the following sample layout of "Record Trace - IFCID 021 - Lock Detail" are described in the following section.

LOCK RES TYPE: ROW LOCK                              DBID: DSNDB06   OBID: SYSUSER   RESOURCE ID: X'00000313123456'   
IRLM FUNC CODE : LOCK (NAME)             RETURN TOKEN: X'7F690A80'              REQUEST TOKEN      : X'00000000'          
LOCK STATE     : SHARED                  DB2 TOKEN   : X'00C150001DFFD428'      IRLM RETURN CODE   :          0           
LOCK ATTRIBUTES: NMODIFY NOFORCE         PROP TO XES : NO                       ASYN TO XES        : NO                   
LOCK DURATION  : MANUAL                  REQUEST TYPE: L-LOCK                   IRLM RETURN SUBCODE: B'0000000000000000'  
PARENT TOKEN   : X'7F68F3F0'             GLOBAL/LOCAL: GLOBAL                   OWNER              : 'BLANK'              
CACHED STATE   : N/A                                                            LOCK HASH VALUE    : X'0C4C3603'

LOCK RES TYPE

The locked resource type.

Note: For data sharing, SKELETON CURSOR TABLE LOCKING and SKELETON PACKAGE TABLE LOCK are LP-locks (an LP-lock has an L-lock component and a P-lock component).

Field Name: QW0021KT

DBID

The database ID. This field is not applicable if the value in LOCK RES TYPE is:

SKELETON CURSOR TABLE LOCKING
UTILITY SERIALIZATION LOCK
SKELETON PACKAGE TABLE LOCK
COLLECTION
BINDLOCK
ALTER BUFFER POOL
GROUP BUFFERPOOL START/STOP LOCK
GROUP BUFFER POOL LEV CASTOUT P-LOCK
CATMAINT MIGRATION LOCK
CATMAINT CONVERT CATALOG LOCK
CATMAINT CONVERT DIRECTORY LOCK

Field Name: QW0021KD

OBID

The object ID. This field is not applicable if the value in LOCK RES TYPE is:

SKELETON CURSOR TABLE LOCKING
UTILITY SERIALIZATION LOCK
SKELETON PACKAGE TABLE LOCK
COLLECTION
BINDLOCK
ALTER BUFFER POOL
GROUP BUFFERPOOL START/STOP LOCK
DDF CDB P-LOCK
GROUP BUFFER POOL LEV CASTOUT P-LOCK
DBD P-LOCK
CATMAINT MIGRATION LOCK
CATMAINT CONVERT CATALOG LOCK
CATMAINT CONVERT DIRECTORY LOCK

Field Name: QW0021KP

RESOURCE ID

The hexadecimal identifier of the small resource. If LOCK RES TYPE is:

DATA PAGE LOCKING: First 3 bytes are the page number
PARTITION LOCKING: Last byte is the partition number
INDEX PAGE LOCKING: First 3 bytes are the page number
HASH ANCHOR LOCK: First 3 bytes are the page number and the last byte is the anchor point ID
CS-READ DRAIN: Last byte is the partition number (optional)
RR-READ DRAIN: Last byte is the partition number (optional)
WRITE DRAIN: Last byte is the partition number (optional)
ROW LOCK: First 3 bytes are the page number and the last byte is the row ID of the record
INDEX END OF FILE LOCK: Last byte is the partition number (optional)
PAGESET/PARTITION P-LOCK: First byte is the 1-based partition number (optional)
PAGE P-LOCK: First byte is the 1-based partition number (optional) and the last 3 bytes are the relative page number
PAGESET/PARTITION LEV CASTOUT P-LOCK: First byte is the 1-based partition number (optional)

Note:

In large partitioned table spaces, the page number covers 4 bytes instead of 3.
If table spaces use relative page numbers, the resource ID covers 7 bytes. It contains the partition number in the first 2 bytes, the page number in the next 4 bytes, and the record ID in the seventh byte.

For all other lock resource types, the resource ID is not applicable.

Field Name: QW0021KR

NAME

The plan name or collection name. This field is only printed if the value in LOCK RES TYPE is SKELETON CURSOR TABLE LOCKING or COLLECTION.

Deduced from the DB2 field QW0021KD, QW0021KP, and QW0021KR. when the locked resource type is skeleton cursor table locking.

Field Name: RT21NAME

COLL

The collection identifier. This field is only printed if the value in LOCK RES TYPE is SKELETON PACKAGE TABLE LOCK.

The package identifier. This field is only printed if the value in LOCK RES TYPE is SKELETON PACKAGE TABLE LOCK.

The consistency token. This field is only printed if the value in LOCK RES TYPE is SKELETON PACKAGE TABLE LOCK.

Field Name: QW0021RN

BPID

The buffer pool ID. This field is only printed if the value in LOCK RES TYPE is:

ALTER BUFFER POOL
GROUP BUFFERPOOL START/STOP LOCK
PAGESET/PARTITION P-LOCK
PAGE P-LOCK
GROUP BUFFERPOOL LEV CASTOUT P-LOCK
PAGESET/PARTITION LEV CASTOUT P-LOCK

For ALTER BUFFER POOL, deduced from QW0021KD || QW0021KP.

For GROUP BUFFERPOOL START/STOP LOCK, deduced from QW0021KD || QW0021KP.

For PAGESET/PARTITION P-LOCK, deduced from QW0021P1.

For PAGE P-LOCK, deduced from QW0021P1.

For GROUP BUFFERPOOL LEV CASTOUT P-LOCK deduced from QW0021P1.

For PAGESET/PARTITION LEV CASTOUT P-LOCK, deduced from QW0021P1.

Field Name: RT21BPID

IRLM FUNC CODE

The IRLM function code.

Field Name: QW0021FC

RETURN TOKEN

The IRLM returned token.

Field Name: QW0021FT

REQUEST TOKEN

The lock request token. If the value in IRLM FUNC CODE is LOCK, this field shows "BLANK". If the value in IRLM FUNC CODE is UNLOCK or CHANGE, this field contains a 0 or a non-zero value. A 0 indicates that the lock name is used to identify the object that is to be unlocked or changed. A non-zero value is the same as the value in RETURN TOKEN. It associates the unlock or change request with the locked object.

Field Name: QW0021RT

LOCK STATE

The lock state.

Field Name: QW0021ST

DB2 TOKEN

The DB2 token which identifies the subsystem.

Field Name: QW0021TK

IRLM RETURN CODE

The return code from IRLM:

0: The request completed successfully.
4: The request completed successfully, but the lock state remained unchanged.
8: The request completed unsuccessfully because of a system error or condition.
12: The request completed unsuccessfully because of a logic error in the request.
16: The request completed unsuccessfully because of an invalid request specification.
20: The request completed unsuccessfully because IRLM resources are not available.

Field Name: QW0021RC

LOCK ATTRIBUTES

This field shows various lock attributes.

Field Name: QW0021FL

PROP TO XES

Indicates whether the request was propagated to XES by IRLM.

Field Name: QW0021Y1

ASYN TO XES

Indicates whether IRLM sent the request to XES asynchronously.

Field Name: QW0021Y2

LOCK DURATION

The lock duration:

MANUAL: Varies depending on the ISOLATION parameter (QW0021DR= x'20')
MANUAL+1: Temporary change of consistency level from CS to RR during bind and DDL (QW0021DR= x'21')
COMMIT: Until commit (QW0021DR=x '40')
COMMIT+1: Past commit; applies to locks needed to maintain the position for a cursor opened WITH HOLD (QW0021DR=x '41')
ALLOCATION: Until deallocation (QW0021DR=x '60')
PLAN: For the duration of the plan (QW0021DR=x '80')
UTIL: For the duration of the utility execution (QW0021DR=x '81')
INTEREST: Duration used for P-locks (QW0021DR=x 'FE')
FREE ALL: Until all locks are freed (QW0021DR=x 'FF')
N/A: Not applicable for NOTIFY SUSPEND

Field Name: QW0021DR

REQUEST TYPE

Indicates whether it was a P-lock or L-lock request.

Field Name: QW0021Z1

IRLM RETURN SUBCODE

The IRLM return subcode.

Field Name: QW0021SC

PARENT TOKEN

The parent lock token for explicit hierarchical locking. This token is only significant when DB2 is a member of a data sharing group. If the value in this field is not 0, then this request is for a child of a parent that has already been locked. This value must match the RETURN TOKEN field of the previously locked parent. This field is only applicable if the value in IRLM FUNC CODE is LOCK.

Field Name: QW0021PT

GLOBAL/LOCAL

Indicates whether this is a global or local lock.

Field Name: QW0021GF

OWNER

The DB2 member name of either of the following:

The owner of an incompatible retained lock on this resource that caused this request to be denied
The owner of an incompatible held lock on this resource that caused this request to timeout

Field Name: QW0021SN

CACHED STATE

The cached state of the P-lock. This field is only applicable if the value in REQUEST TYPE is P-LOCK, and the value in LOCK RES TYPE is PAGESET/PARTITION P-LOCK.

Field Name: QW0021CS

LOCK HASH VALUE

The hash value of the locked resource.

Field Name: QW0021LH

Feedback