IFCID 196 - Timeout Header

This topic shows detailed information about "Record Trace - IFCID 196 - Timeout Header".

TIMEOUT HEADER
NUMBER OF HOLDERS/WAITERS:          1     LOCK HASH VALUE: X'0102FB25'
LOCK RES TYPE: TABLE LOCK                            DBID: A100XAAC            OBID: 507     RESOURCE ID: X'00000313123456'
REQUESTED FUNCTION: CHANGE        REQUESTED STATE: EXCLUSIVE                    REQUESTED DURATION: COMMIT
REQUESTED FLAGS   : B'00110010'   REQUESTED OWNING WORK UNIT: X'14B2008E1D328E80'
ZPARM INTERVAL    :  600          INTERVAL COUNTER: 1
WTR STMT ID       : X'00001287'                                                 WTR STMT TYPE     : N/A

NUMBER OF HOLDERS/WAITERS

The number of agents causing the timeout.

Field Name: QW0196NU

LOCK HASH VALUE

The hash value of the locked resource.

Field Name: QW0196RH

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

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 QW0196KD, QW0105DN or QW0107DN.

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

Field Name: RT0196DB

OBID

The object 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 QW0196KP, QW0105TN or QW0107TN.

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

Field Name: RT0196OB

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

REQUESTED FUNCTION

The victim's type of request.

Field Name: QW0196WU

REQUESTED STATE

The victim's lock state.

Field Name: QW0196WS

REQUESTED DURATION

The victim's lock duration.

Field Name: QW0196WD

REQUESTED FLAGS

The victim's lock flag.

Field Name: QW0196WF

REQUESTED OWNING WORK UNIT

The victim's owning work unit.

Field Name: QW0196WO

ZPARM INTERVAL

The timeout interval of the ZPARM value.

Field Name: QW0196TI

INTERVAL COUNTER

The timeout counter for this thread.

Field Name: QW0196TC

WTR STMT ID

The cached statement ID for the statement waiting for the resource. A value of zero indicates that the client did not supply this information.

Field Name: QW0196W9

WTR STMT TYPE

The waiter statement information. Possible values are:

STATIC

The statement is of type static.

DYNAMIC

The statement is of type dynamic.

Field Name: QW0196WY