IFCID 257 - IRLM Notify Req Detail

This topic shows detailed information about Record Trace - IFCID 257 - IRLM Notify Req Detail.

This record shows the inter-Db2 notify message sending detail. IRLM notify requests are used to communicate among members of a Db2 data sharing group.

LOCK RES TYPE: N/P                                    DBID: 3328                OBID: 255       RESOURCE ID: X'03C7D9D6'
STATE: X'00'                    NUMBER OF HOLDERS:      0  OPERATION: RECEIVE  REQUEST: SYNCH
QW0257TK  X'80CF0000'   QW0257RM   10   QW0257FC  195      QW0257RC X'00000000'   QW0257RS  X'0000'
...................................................................
QW0257LL          70
QW0257MS
0000  2400002C  C294A287  C4C2F2E5  F0F4F0F1   ADE01D31  D0655204
0020  00000000  00000000  80000000  00000000   00000000  00000000
0040  00000000  0000

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

STATE

The lock state. This field is only applicable if the value in OPERATION is SEND . Otherwise, N/A is printed in this field.

Field Name: QW0257ST

NUMBER OF HOLDERS

The number of lock holders notified. This field is only applicable if the value in OPERATION is SEND . Otherwise, N/A is printed in this field.

Field Name: QW0257NU

OPERATION

The notify operation.

Field Name: QW0257OP

REQUEST

Indicates whether the request was synchronous or asynchronous. This field is only applicable if the value in OPERATION is SEND . Otherwise, N/A is printed in this field.

Field Name: QW0257FL