IFCID 196 - Holder

This topic shows detailed information about Record Trace - IFCID 196 - Holder.

The header label is "H O L D E R" when the task holds the lock. The header label is "W A I T E R" when the task is a higher priority waiter of the lock.

Record trace - IFCID 196 - Holder

The field labels shown in the following sample layout of Record Trace - IFCID 196 - Holder are described in the following section.


H O L D E R
PRIMAUTH  : D022280     PLAN NAME: DISTSERV          CORR ID: D8HDIA000                      CONN: SERVER
NETWORKID : GA11DE90       LUNAME: P984             INSTANCE: 06DC47093936       OWNING WORK UNIT: X'14B200'
LOCK STATE: INTENT EXCLUSIVE                   LOCK DURATION: COMMIT                       MEMBER: D8H0
TRANSACT  : D8HDIA000                                WS_NAME: ihls04                     END_USER: d022280
STMT ID   : X'000002AB'                            STMT TYPE: N/A
QW0196HA  : X'01'        QW0196HF: X'A0'

PRIMAUTH

The authorization ID of the thread holding the resource.

Field Name: QW0196HB

PLAN NAME

The holder's plan name or, if there is contention with a retained lock, the word SYSTEM.

Field Name: QW0196HP

CORR ID

The holder's correlation ID or, if there is contention with a retained lock, the word SYSTEM.

Field Name: QW0196HR

CONN

The holder's connection ID or, if there is contention with a retained lock, the word SYSTEM.

Field Name: QW0196HN

LUWID - NETWORKID, LUNAME, INSTANCE

This field contains an asterisk (*) if the lock holder is not a database access thread (DBAT). It provides the input for the:

Holder's network ID or, if there is contention with a retained lock, the word SYSTEM.
Holder's LU name or, if there is contention with a retained lock, the word SYSTEM.
Holder's LUW instance or, if there is contention with a retained lock, the word SYSTEM.

Note: This field is only valid for distributed threads.

Field Name: QW0196HL

OWNING WORK UNIT

The holder's owning work unit. This value is printed in hexadecimal.

If there is contention with a retained lock, this field is set to X'00 '.

Field Name: QW0196HO

LOCK STATE

The holder's lock state.

Field Name: QW0196HS

LOCK DURATION

The lock duration of the holder:

MANUAL: Varies depending on the ISOLATION parameter (QW0196HD=x'20')
MANUAL+1: Temporary change of consistency level from CS to RR during bind and DDL (QW0196HD=x'21')
COMMIT: Until commit (QW0196HD=x'40')
COMMIT+1: Past commit; applies to locks needed to maintain the position for a cursor opened WITH HOLD (QW0196HD=x'41')
ALLOCATION: Until deallocation (QW0196HD=x'60')
PLAN: For the duration of the plan (QW0196HD=x'80')
UTIL: For the duration of the utility execution (QW0196HD=x'81')
INTEREST: Duration used for P-locks (QW0196HD=x'FE')
FREE ALL: Until all locks are freed (QW0196HD=x'FF')
x'00': Contention with a retained lock (QW0196HD=x'00x')

Field Name: QW0196HD

MEMBER

The holder's Db2 member name. For non-data sharing environments, N/P is shown in this field.

Field Name: QW0196HI

TRANSACT

The transaction or application name that is run.

Field Name: QWHCEUTX

WS_NAME

The end user's workstation name.

Field Name: QWHCEUWN

END_USER

The user ID of the workstation end user. This user ID can be different from the authorization ID used to connect to Db2. This field contains blanks if the client does not supply this information.

Field Name: QWHCEUID

STMT ID

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

Field Name: QW0196H9

STMT TYPE

STATIC: The statement is of type static.
DYNAMIC: The statement is of type dynamic.

Field Name: QW0196HY