Default language.

Lock trace—holder/blocker details


This topic describes the holder/blocker details section of the Lock trace lockout report (BLKTRCLO).

HOLDER/BLOCKER DETAILS
---------------------------------------
BLOCKER IS: HOLDER
LOCK STATE: X    DURATION: ALLOCATION
LUWID: USBMCN01. DGR1LU  . CBD8AB02A656
PLAN : DSNUTIL       AUTH: RDHJMB
CONN : UTILITY     MEMBER: DGR1
THDTK: 42930000    CORRID: BARTDEAD
WKUNT: 02CF000131BA0160
EUID : RDHJMB
WSNAM: UTILITY
TXNAM: BARTDEAD
PROGM: ...D
COLL :
LOC  :
CONTK: 0000000000000000
STMID: 000000000000007A  TYPE: DYNAMIC

Following table describes the fields in the holder/blocker details section of the Lock trace lockout report.

Field

Description

BLOCKER IS

Blocker holder/waiter flag

LOCK STATE

Lock holders state

LUWID

Lock holders network ID

PLAN

Lock holders plan name

CONN

Lock holders connection ID

THDTK

Blocker thread token

WKUNT

Lock holders owning work unit

EUID

Holders end user userid

WSNAME

Holders workstation name

TXNAM

Holders transaction name

PROGM

Holder program name

COLL

Holder collection ID

LOC

Holder location name

CONTK

Holder consistency token

STMID

Holder statement ID

TYPE

Holder statement type

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Ops Monitor for Db2 13.1