Default language.

Lock summary detail report (BLKSUMDT)


The following figure shows a sample of the lock summary detail report (BLKSUMDT).


Warning

Important

This report is based on Db2 performance lock trace IFCID 21.

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

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Ops Monitor for Db2 13.1