.
DB2 deadlocks—holder
This topic describes the holder section of the DB2 deadlocks report (BDEADLCK).
STATE : X DURATION: COMMIT
AUTHID : IOA PLAN: ARUDEV
CONNECT : DB2CALL CORRID: WURFFSE2
LUWID: USBMCN01. DEFFLU . CE4FAAF06031
THREAD TOKEN : 44186
OWNING WORK UNIT : 00D7002C1FDA2C00
DB2 MEMBER : DEFF
END USER ID : IOA
WORK STATION : DB2CALL
TRANSACTION : WURFFSE2
PROGRAM NAME : ARUSMAIN
COLLECTIONID : ARUDEV
LOCATION NAME:
CONSIS. TOKEN: 19C9E0D71FE12D51
Following table describes the fields in the holder section of the DB2 deadlocks report.
Field | Description |
|---|---|
STATE | Lock waiters state |
DURATION | Lock holders state |
AUTHID | Holders authorization ID |
PLAN | Lock holders plan name |
CONNECT | Lock holders connection ID |
CORRID | Lock holders correlation ID |
LUWID | Lock holders network ID |
THREAD TOKEN | Blocker thread token |
OWNING THREAD UNIT | Lock holders owning work unit |
DB2 MEMBER | Lock holders DBMS ID |
END USER ID | Holders end user userID |
WORK STATION | Holders workstation name |
TRANSACTION | Holders transaction name |
PROGRAM NAME | Holder program name |
COLLECTION ID | Holder collection ID |
LOCATION NAME | Holder location name |
CONSIS TOKEN | Holder consistency token |
RESOURCE | Lock type/resource ID |
DB/PS | Locked resource DBID |
PAGE | Locked resource ID 1 |
TYPE | Locked resource type |
HASH | Locked resource hash value |
Related topic