Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 
.
.
Lock summary—lockouts
This topic describes the Lock summary lockout report (BLKSUMLO).
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 |
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*