IFCID 150 - Lock Resource Data

This topic shows detailed information about Record Trace - IFCID 150 - Lock Resource Data.

                                                          LOCK RESOURCE DATA
LOCK RES TYPE: X'3F'        DBID: 25290       OBID: 51968      RESOURCE ID: X'00000313123456' 
HASH TOKEN   : X'00000002'

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: QW0150KT

DBID

The database ID. This field is not applicable if the value in LOCK RES TYPE is SKELETON CURSOR TABLE LOCKING , SKELETON PACKAGE TABLE LOCK , COLLECTION , or ALTER BUFFER POOL .

Deduced from the Db2 fields QW0150DB, QW0105DN, or QW0107DN.

If present, the database name is shown, otherwise the decimal identifier from QW0150DB is shown, or N/A if this value is 0.

Field Name: RT0150DB

OBID

The object ID of the table space or pageset involved in the lock. This field is not applicable if the value in LOCK RES TYPE is SKELETON CURSOR TABLE LOCKING , SKELETON PACKAGE TABLE LOCK , or COLLECTION .

Deduced from the Db2 fields QW0149KP, QW0105TN, QW0107TN, QW0149KP, QW0105OB or QW0107OB.

If present, then name of the object is shown. Otherwise the decimal identifier from QW0150KP is shown, or N/A if this value is 0.

Field Name: RT0150OB

RESOURCE ID

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

DATA SET LOCKING (PARTITION)

Last byte is the partition number

DATA PAGE LOCKING

First 3 bytes are the page 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)

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.

This field is not applicable if the value in LOCK RES TYPE is SKELETON CURSOR TABLE LOCKING, SKELETON PACKAGE TABLE LOCK, TABLE LOCK , COLLECTION, ALTER BUFFER POOL, or PAGESET LOCK. If the value is UTILITY SERIALIZATION LOCK or BINDLOCK, N/A is printed.

Field Name: QW0150KR

HASH TOKEN

The hash token of the resource name.

Field Name: QW0150LH