Skip to Content

Default language.

Lock summary lockout report (BLKSUMLO)

The following figure shows a sample of the lock summary lockout report (BLKSUMLO).

Related topic

Locking-activity-reports


Warning

Important

This report is based on Db2 performance lock trace IFCIDs 172, and 196.

 1

1                       BLKSUMLO: LOCK SUMMARY RPT - LOCKOUTS                            11/04/14 12:17:13    PAGE     1

    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
1                       BLKSUMLO: LOCK SUMMARY RPT - LOCKOUTS                            11/04/14 12:17:13    PAGE     2

    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 RDHJMB2
                                                   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         1
                  HEX= 0281000200000000000000000000
                       0000000000000000000000000000
                                                                          DGR1                                             1      1
    ROW LOCK      DSNDB06 .0362    .RLCK.00000A0A00          0         1
                  HEX= 0006036200000A0A000000000000
                       0000000000000000000000000000
                                                                          DGR1                                             1      1

 

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

BMC AMI Ops Monitor for Db2 13.1