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.

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'
 

                                                            H O L D E R                                                             
                                                                                                                                    
PRIMAUTH.........: EDVA                            PLAN NAME........: DSNESPCS              CORR ID......: EDVA                     
CONN.............: TSO                             NETWORKID........: DEIBMIPS              LUNAME.......: IPUAQC61                 
INSTANCE.........:                   D08528C2300B  OWNING WORK UNIT.:  X'00DD005D1DC45D20'  LOCK STATE...: EXCLUSIVE                
LOCK DURATION....: COMMIT                          MEMBER...........: N/A                   END_USER.....: EDVA                     
TRANSACT.........: EDVA                            WS_NAME..........: TSO                   STMT ID......:                 X'2E9CB7'
STMT TYPE........:                        X'8000'  QW0196HA.........:                 X'1'  QW0196HF.....:                     X'A0'
                                                                                                                                    
--- Long name section                                                                                                               
WS_NAME..........: N/P                                                                                                              
END_USER.........: N/P                                                                                                              
TRANSACTION......: N/P                                                                                                              
--- End of long names                                                                                                               
 

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

X'4000' - the statement is of type static.

DYNAMIC

X'8000' - the statement is of type dynamic.

Field Name: QW0196HY