DB2 deadlocks—waiter
STATE : IX DURATION: COMMIT
FUNCTION: LOCK WORTH: 18
AUTHID : IOA PLAN: ARUDEV
CONNECT : DB2CALL CORRID: WURFF$U2
LUWID : USBMCN01. DEFFLU . CE4FA9F076D3
THREAD TOKEN : 43297
OWNING WORK UNIT : 00D700211FDA2140
REQUEST WORK UNIT: 00D700211FDA2200
DB2 MEMBER : DEFF
END USER ID : IOA
WORK STATION : DB2CALL
TRANSACTION : WURFF$U2
PROGRAM NAME : ARUSMAIN
COLLECTIONID : ARUDEV
LOCATION NAME:
CONSIS. TOKEN: 19C9E0D71FE12D51
Following table describes the fields in the waiter section of the DB2 deadlocks report.
Field | Description |
|---|---|
STATE | Lock waiters requested state |
DURATION | Lock waiters requested duration |
FUNCTION | Lock holders requested function |
WORTH | Lock holders worth value |
AUTHID | Waiters authorization ID |
PLAN | Lock waiters plan name |
CONNECT | Lock waiters connection ID |
CORRID | Lock waiters correlation ID |
LUWID | Lock waiters network ID |
THREAD TOKEN | Waiters thread token |
OWNING THREAD UNIT | Lock waiters owning work unit |
REQUEST WORK UNIT | Lock waiters requesting work unit |
DB2 MEMBER | Waiters Db2 member name |
END USER ID | Waiters end user userID |
WORK STATION | Waiters workstation name |
TRANSACTION | Waiters transaction name |
PROGRAM NAME | Waiter program name |
COLLECTION ID | Waiter collection ID |
LOCATION NAME | Holder location name |
CONSIS TOKEN | Holder consistency token |