Information
Limited support BMC 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 detail report (BLKSUMDT)
The following figure shows a sample of the lock summary detail report (BLKSUMDT).
1
DGR1 1 1
1 BLKSUMDT: LOCK SUMMARY RPT - DETAIL 11/04/14 12:17:13 PAGE 1
LOCATION: DGR DATA FROM: 08/19/2013 12:05:00
D/S GRP: DSNDGR MBR: DGR1 LOCK SUMMARY REPORT - DETAIL TO: 08/21/2013 13:49:24
SSID: DGR1 VER: 10.1
PRIME AUTHID RDHJMB
PLAN NAME DSNTEP2
--REQ TYPE-- ------LOCK STATE------- --LOCK DURATION--
--------------- LOCK RESOURCE ---------------- TOTAL LOCAL LOCK UNLOCK IS IX SIX NSU MAN CMT ALLOC COND
TYPE NAME REQUESTS XES CHNGE OTHER S X U MAN+1 CMT+1 OTHER AUTREL
============ ================================= ======== ===== ===== ====== ===== ===== ===== ===== ===== ===== ===== ======
DATA PAGE . . . 326 263 0 137 0 0 0 0 5 129 0 0
HEX= 0000000000000000000000000000 63 63 126 5 63 0 0 0 192 0
0000000000000000000000000000
PAGESET DEADDB01.DEADTS01.PSET.0000000000 62 0 62 0 0 62 0 0 0 62 0 0
HEX= 0281000200000000000000000000 62 0 0 0 0 0 0 0 0 0
0000000000000000000000000000
MASS DELETE DEADDB01.0003 .MASD.0000000000 63 0 63 0 0 0 0 0 0 63 0 0
HEX= 0281000300000000000000000000 63 0 0 0 63 0 0 0 0 0
0000000000000000000000000000
TABLE DEADDB01.0003 .TABL.0000000000 126 0 63 0 0 63 0 0 0 126 0 0
HEX= 0281000300000000000000000000 126 63 0 0 63 0 0 0 0 0
0000000000000000000000000000
PAGESET DSNDB06 .SYSRTSTS.PSET.0000000000 63 0 63 0 0 63 0 0 0 63 0 0
HEX= 0006036100000000000000000000 63 0 0 0 0 0 0 0 0 0
0000000000000000000000000000
DATA BASE DSNDB06 .0000 .DBAS.0000000000 63 0 63 0 0 0 0 0 0 63 0 0
HEX= 0006000000000000000000000000 63 0 0 63 0 0 0 0 0 0
0000000000000000000000000000
ROW LOCK DSNDB06 .0362 .RLCK.00000A0A00 63 0 63 0 0 0 0 0 63 0 0 63
HEX= 0006036200000A0A000000000000 63 0 0 0 0 63 0 0 0 0
0000000000000000000000000000
TABLE DSNDB06 .0362 .TABL.0000000000 63 0 63 0 0 63 0 0 0 63 0 0
HEX= 0006036200000000000000000000 63 0 0 0 0 0 0 0 0 0
0000000000000000000000000000
TABLE DSNDB06 .0366 .TABL.0000000000 63 0 63 0 0 63 0 0 0 63 0 0
HEX= 0006036600000000000000000000 63 0 0 0 0 0 0 0 0 0
0000000000000000000000000000
SKEL C/T DSNTEP2 . .SKCT.0000000000 2 0 2 0 0 0 0 0 0 0 0 0
HEX= C4E2D5E3C5D7F240000000000000 2 0 0 2 0 0 0 0 2 0
0000000000000000000000000000
(S) X34 E2E8 .E26D .PITR.D7C9E3D900 5 0 5 0 0 0 0 0 5 0 0 5
HEX= E2E8E26DD7C9E3D9000000000000 5 0 0 5 0 0 0 0 0 0
0000000000000000000000000000
PAGE P-LOCK 0000 .0006 .PGPL.0361000100 121 0 121 0 0 0 0 0 0 0 0 0
HEX= 000000060361000100000A000000 121 0 0 0 121 0 0 0 121 0
0000000000000000000000000000
DGR1 1 1
1 BLKSUMDT: LOCK SUMMARY RPT - DETAIL 11/04/14 12:17:13 PAGE 1
LOCATION: DGR DATA FROM: 08/19/2013 12:05:00
D/S GRP: DSNDGR MBR: DGR1 LOCK SUMMARY REPORT - DETAIL TO: 08/21/2013 13:49:24
SSID: DGR1 VER: 10.1
PRIME AUTHID RDHJMB
PLAN NAME DSNTEP2
--REQ TYPE-- ------LOCK STATE------- --LOCK DURATION--
--------------- LOCK RESOURCE ---------------- TOTAL LOCAL LOCK UNLOCK IS IX SIX NSU MAN CMT ALLOC COND
TYPE NAME REQUESTS XES CHNGE OTHER S X U MAN+1 CMT+1 OTHER AUTREL
============ ================================= ======== ===== ===== ====== ===== ===== ===== ===== ===== ===== ===== ======
DATA PAGE . . . 326 263 0 137 0 0 0 0 5 129 0 0
HEX= 0000000000000000000000000000 63 63 126 5 63 0 0 0 192 0
0000000000000000000000000000
PAGESET DEADDB01.DEADTS01.PSET.0000000000 62 0 62 0 0 62 0 0 0 62 0 0
HEX= 0281000200000000000000000000 62 0 0 0 0 0 0 0 0 0
0000000000000000000000000000
MASS DELETE DEADDB01.0003 .MASD.0000000000 63 0 63 0 0 0 0 0 0 63 0 0
HEX= 0281000300000000000000000000 63 0 0 0 63 0 0 0 0 0
0000000000000000000000000000
TABLE DEADDB01.0003 .TABL.0000000000 126 0 63 0 0 63 0 0 0 126 0 0
HEX= 0281000300000000000000000000 126 63 0 0 63 0 0 0 0 0
0000000000000000000000000000
PAGESET DSNDB06 .SYSRTSTS.PSET.0000000000 63 0 63 0 0 63 0 0 0 63 0 0
HEX= 0006036100000000000000000000 63 0 0 0 0 0 0 0 0 0
0000000000000000000000000000
DATA BASE DSNDB06 .0000 .DBAS.0000000000 63 0 63 0 0 0 0 0 0 63 0 0
HEX= 0006000000000000000000000000 63 0 0 63 0 0 0 0 0 0
0000000000000000000000000000
ROW LOCK DSNDB06 .0362 .RLCK.00000A0A00 63 0 63 0 0 0 0 0 63 0 0 63
HEX= 0006036200000A0A000000000000 63 0 0 0 0 63 0 0 0 0
0000000000000000000000000000
TABLE DSNDB06 .0362 .TABL.0000000000 63 0 63 0 0 63 0 0 0 63 0 0
HEX= 0006036200000000000000000000 63 0 0 0 0 0 0 0 0 0
0000000000000000000000000000
TABLE DSNDB06 .0366 .TABL.0000000000 63 0 63 0 0 63 0 0 0 63 0 0
HEX= 0006036600000000000000000000 63 0 0 0 0 0 0 0 0 0
0000000000000000000000000000
SKEL C/T DSNTEP2 . .SKCT.0000000000 2 0 2 0 0 0 0 0 0 0 0 0
HEX= C4E2D5E3C5D7F240000000000000 2 0 0 2 0 0 0 0 2 0
0000000000000000000000000000
(S) X34 E2E8 .E26D .PITR.D7C9E3D900 5 0 5 0 0 0 0 0 5 0 0 5
HEX= E2E8E26DD7C9E3D9000000000000 5 0 0 5 0 0 0 0 0 0
0000000000000000000000000000
PAGE P-LOCK 0000 .0006 .PGPL.0361000100 121 0 121 0 0 0 0 0 0 0 0 0
HEX= 000000060361000100000A000000 121 0 0 0 121 0 0 0 121 0
0000000000000000000000000000
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*