IFCID 044 - Lock Suspend

This topic shows detailed information about Record Trace - IFCID 044 - Lock Suspend.

LOCK RES TYPE: LPL RECOVERY              DBID: 256       OBID: 257         RESOURCE ID: X'00000313123456'
IRLM FUNC CODE: LOCK (NAME)        STATE: SHARED                           DURATION: COMMIT      REASON SUSP: LM
REQ TOKEN: X'00000000'   LOCK ATTRIBUTES: L-LOCK GLOBAL NOMODIFY NOFORCE   PROP TO XES: NO       ASYN TO XES: NO
PARENT TOKEN: X'7F6906D8'     LOCK HASH VALUE: X'0001840A'
QW0044CL: X'00'         QW0044FL: X'30'

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

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

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

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
ALTER BUFFER POOL

Deduced from the Db2 fields QW0044KD, QW0105DN or QW0107DN.

When present, the database name is shown, otherwise the decimal identifier from QW0044KD is shown, or N/A when this value is 0.

Field Name: RT0044DB

OBID

The object ID of the table space or page set. This field is not applicable if the value in LOCK RES TYPE is:

SKELETON CURSOR TABLE LOCKING
SKELETON PACKAGE TABLE LOCK
COLLECTION
ALTER BUFFER POOL

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

The table space or object name is shown, when present, otherwise the decimal identifier from QW0044OB is shown, or N/A when this value is 0.

Field Name: RT0044OB

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

Field Name: QW0044KR

COLL

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

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

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

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

Field Name: QW0044RN

IRLM FUNC CODE

The IRLM function code.

Field Name: QW0044FC

STATE

The lock state.

Field Name: QW0044ST

DURATION

The lock duration:

MANUAL

Varies depending on the ISOLATION parameter (QW0044DR=x '20')

MANUAL+1

Temporary change of consistency level from CS to RR during bind and DDL (QW0044DR=x '21')

COMMIT

Until commit (QW0044DR=x '40')

COMMIT+1

Past commit; applies to locks needed to maintain the position for a cursor opened WITH HOLD (QW0044DR=x '41')

ALLOCATION

Until deallocation (QW0044DR= '60')

PLAN

For the duration of the plan (QW0044DR=x '80')

UTIL

For the duration of the utility execution (QW0044DR=x '81')

INTEREST

Duration used for P-locks (QW0044DR=x 'FE')

FREE ALL

Until all locks are freed (QW0044DR=x 'FF')

N/A

Not applicable for NOTIFY SUSPEND

Field Name: QW0044DR

REASON SUSP

The reason for the suspend:

LC

IRLM latch contention

IQ

IRLM queued request

LR

Local resource contention

GR

Global resource contention

IS

Intersystem communication

N

Notify message sent

LS

No longer used

RL

Contention with a retained lock

Field Name: QW0044WS

REQ TOKEN

The IRLM lock request token.

Field Name: QW0044RT

LOCK ATTRIBUTES

The lock attributes.

Field Name: QW0044FO

PROP TO XES

Indicates whether the request was propagated to XES by IRLM.

Field Name: QW0044Y1

ASYN TO XES

Indicates whether the request was sent to XES asynchronously by IRLM.

Field Name: QW0044Y2

PARENT TOKEN

The parent token for explicit hierarchical locking. This field is valid if the Db2 subsystem is a member of a data sharing group.

Field Name: QW0044PT

LOCK HASH VALUE

The hash value of the locked resource.

Field Name: QW0044LH