Lock summary—lockouts
LOCATION: DGR DATA FROM: 08/21/2013 13:44:57
D/S GRP: DSNDGR MBR: DGR1 LOCK SUMMARY REPORT - LOCKOUTS TO: 08/22/2013 11:27:17
SSID: DGR1 VER: 10.1
PRIME AUTHID RDHJMB
PLAN NAME DSNTEP2
----------------- LOCK RESOURCE ---------------- ----------------- AGENTS ----------------- BLOCKER/
TYPE NAME TIMEOUTS DEADLOCKS MEMBER PLAN CONNECT CORRID HOLDER WAITER
============ =================================== ======== ========= ======== ======== ======== ============ ====== ======
C/S DRAIN DEADDB01.DEADTS01.CSDR.0000000000 0 3
HEX= 0281000200000000000000000000
0000000000000000000000000000
DGR1 3 3
ROW LOCK DSNDB06 .0362 .RLCK.00000A0A00 0 3
HEX= 0006036200000A0A000000000000
0000000000000000000000000000
DGR1 3 3
D/S GRP: DSNDGR MBR: DGR1 LOCK SUMMARY REPORT - LOCKOUTS TO: 08/22/2013 11:27:17
SSID: DGR1 VER: 10.1
PRIME AUTHID RDHJMB
PLAN NAME DSNTEP2
----------------- LOCK RESOURCE ---------------- ----------------- AGENTS ----------------- BLOCKER/
TYPE NAME TIMEOUTS DEADLOCKS MEMBER PLAN CONNECT CORRID HOLDER WAITER
============ =================================== ======== ========= ======== ======== ======== ============ ====== ======
C/S DRAIN DEADDB01.DEADTS01.CSDR.0000000000 0 3
HEX= 0281000200000000000000000000
0000000000000000000000000000
DGR1 3 3
ROW LOCK DSNDB06 .0362 .RLCK.00000A0A00 0 3
HEX= 0006036200000A0A000000000000
0000000000000000000000000000
DGR1 3 3
Following table describes the fields in the Lock summary—lockout report.
Field | Description |
|---|---|
TYPE | Possible types are:
|
NAME | Locked resource name |
TIMEOUTS | Count of timeouts caused by locked resources |
DEADLOCKS | Count of deadlocks caused by locked resources |
AGENTS: | |
MEMBER | Data sharing member name |
PLAN | Other plan name |
CONNECT | Other connection ID |
CORRID | Other correlation ID |
BLOCKER/HOLDER | Total holders |
WAITER | Total waiters |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*