IFCID 172 - Unit of Work - Resource

This topic shows detailed information about "Record Trace - IFCID 172 - Unit of Work - Resource".

The content of the LOCK RES TYPE field determines which other fields are printed in this record.

Blocker and waiter information is shown for each resource involved in the deadlock.

                                     UNIT OF WORK
R E S O U R C E
LOCK RES TYPE: LPL RECOVERY         DBID: 1         OBID: 2      RESOURCE ID: X'00000313123456' 
LOCK HASH VALUE: X'005859E8'

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

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, or COLLECTION. Deduced from the DB2 fields QW0172DB, QW0105DN, or QW0107DN.

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

Field Name: RT0172DB

OBID

The object ID of the resource 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 QW0172KP, QW0105TN, QW0107TN, QW0172KP, QW0105OB, or QW0107OB.

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

Field Name: RT0172OB

RESOURCE ID

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

DATA PAGE LOCKING

First 3 bytes are the page number

DATA SET LOCKING (PARTITION)

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)

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, or ALTER BUFFER POOL. If the value is UTILITY SERIALIZATION LOCK or BINDLOCK, N/A is printed.

Field Name: QW0172KR

LOCK HASH VALUE

The hash value of the locked resource.

Field Name: QW0172LH