Default language.

Lock trace lockout report (BLKTRCLO)


The following figure shows a sample of the lock trace lockout report (BLKTRCLO).


Important

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

                    BLKTRCLO: LOCK SUMMARY TRC - LOCKOUTS                            08/11/19 23:54:27    PAGE     1           

LOCATION: DMS                                                                                    DATA FROM: 02/24/2019 23:34:27
 D/S GRP: DSNDMS   MBR: DMS3                     LOCK SUMMARY TRACE - LOCKOUTS                          TO: 02/25/2019 22:18:34
    SSID: DMS3     VER: 12.1                                                                                                   
PRIMAUTH: AMID001  ORIGAUTH: AMID001                                                            PLAN    : AMITEP13             

EVENT TIME                  EVENT     DETAILS                                                                                  
=========================== ========  =========================================================================================
02/25/19  12:14:43.91681143 TIMEOUT   BLOCKERS :    1                                                                          

                                         --------------------------- VICTIM THREAD IDENTIFICATION -----------------------------
                                         LUWID   : USBMCN01.DMS3LU.D5BCD06D8D1E                                                
                                         PRIMAUTH: AMID001    CONNECT: TSO            ENDUSER: AMID001                         
                                         ORIGAUTH: AMID001    CONNTYP: TSO             WSNAME: TSO                             
                                         PLAN    : AMITEP13   CORRID : AMID001        TRXNAME: AMID001                         

LOCK TYPE    LOCK RESOURCE NAME                WAITER DETAILS                           HOLDER/BLOCKER DETAILS                 
------------ --------------------------------- ---------------------------------------  ---------------------------------------
DATA PAGE    0124    .0002    .DPAG.000003FF00 FUNC: LOCK       LOCK STATE: S                                                  
             HEX= 01240002000003FF000000000000 TYPE: UNCOND       DURATION: MANUAL                                             
                  0000000000000000000000000000 HASH: 003BE3FF   ZPARM INTV:     30                                             
                                               STMTTYP: DYNAMIC   INTV CNT:      1                                             
                                               STMT ID: 00000000000C1A9F                                                       

                                                                                        HOLDER   ------------------------------
                                                                                        LUW  : USBMCN01.DMS3LU  .D5BCD069A38A  
                                                                                        DSMEM: DMS3       CONNECT: TSO         
                                                                                        PLAN : AMITEP09   CORR   : AMID009     
                                                                                        AUTH : AMID009                         
                                                                                        EUID : AMID009                         
                                                                                        WSNAM: TSO                             
                                                                                        TXNAM: AMID009                         
                                                                                        STMT TYPE: DYNAMIC                     
                                                                                        STMT ID  : 00000000000C1A8B            
                                                                                        LOCK STATE: X      DURATION: COMMIT    

                    BLKTRCLO: LOCK SUMMARY TRC - LOCKOUTS                            08/11/19 23:54:27    PAGE     2           

LOCATION: DMS                                                                                    DATA FROM: 02/24/2019 23:34:27
 D/S GRP: DSNDMS   MBR: DMS3                     LOCK SUMMARY TRACE - LOCKOUTS                          TO: 02/25/2019 22:18:34
    SSID: DMS3     VER: 12.1                                                                                                   
PRIMAUTH: AMID003  ORIGAUTH: AMID003                                                            PLAN    : AMITEP06             

EVENT TIME                  EVENT     DETAILS                                                                                  
=========================== ========  =========================================================================================
02/25/19  12:14:43.92409175 TIMEOUT   BLOCKERS :    1                                                                          

                                         --------------------------- VICTIM THREAD IDENTIFICATION -----------------------------
                                         LUWID   : USBMCN01.DMS3LU.D5BCD072EFB8                                                
                                         PRIMAUTH: AMID003    CONNECT: TSO            ENDUSER: AMID003                         
                                         ORIGAUTH: AMID003    CONNTYP: TSO             WSNAME: TSO                             
                                         PLAN    : AMITEP06   CORRID : AMID003        TRXNAME: AMID003                         

LOCK TYPE    LOCK RESOURCE NAME                WAITER DETAILS                           HOLDER/BLOCKER DETAILS                 
------------ --------------------------------- ---------------------------------------  ---------------------------------------
DATA PAGE    0124    .0002    .DPAG.0000040800 FUNC: LOCK       LOCK STATE: S                                                  
             HEX= 0124000200000408000000000000 TYPE: UNCOND       DURATION: MANUAL                                              
                  0000000000000000000000000000 HASH: 00449408   ZPARM INTV:     30                                              
                                               STMTTYP: DYNAMIC   INTV CNT:      1                                              
                                               STMT ID: 00000000000C1A99                                                        

                                                                                        HOLDER   ------------------------------
                                                                                        LUW  : USBMCN01.DMS3LU  .D5BCD069A38A   
                                                                                        DSMEM: DMS3       CONNECT: TSO          
                                                                                        PLAN : AMITEP09   CORR   : AMID009      
                                                                                        AUTH : AMID009                          
                                                                                        EUID : AMID009                          
                                                                                        WSNAM: TSO                              
                                                                                        TXNAM: AMID009                          
                                                                                        STMT TYPE: DYNAMIC                      
                                                                                        STMT ID  : 00000000000C1A8B             
                                                                                        LOCK STATE: X      DURATION: COMMIT     

02/25/19  12:42:14.57977513 TIMEOUT   BLOCKERS :    1                                                                           

                                         --------------------------- VICTIM THREAD IDENTIFICATION -----------------------------
                                         LUWID   : USBMCN01.DMS3LU.D5BCD69D4A79                                                 
                                         PRIMAUTH: AMID003    CONNECT: TSO            ENDUSER: AMID003                          
                                         ORIGAUTH: AMID003    CONNTYP: TSO             WSNAME: TSO                              
                                         PLAN    : AMITEP06   CORRID : AMID003        TRXNAME: AMID003                          

LOCK TYPE    LOCK RESOURCE NAME                WAITER DETAILS                           HOLDER/BLOCKER DETAILS                  
------------ --------------------------------- ---------------------------------------  ---------------------------------------
DATA PAGE    0124    .0002    .DPAG.000002E500 FUNC: LOCK       LOCK STATE: S                                                   
             HEX= 01240002000002E5000000000000 TYPE: UNCOND       DURATION: MANUAL                                              
                  0000000000000000000000000000 HASH: 002A42E5   ZPARM INTV:     30                                              
                                               STMTTYP: DYNAMIC   INTV CNT:      1                                              
                                               STMT ID: 00000000000CA0F1                                                        

                    BLKTRCLO: LOCK SUMMARY TRC - LOCKOUTS                            08/11/19 23:54:27    PAGE     3            

LOCATION: DMS                                                                                    DATA FROM: 02/24/2019 23:34:27
 D/S GRP: DSNDMS   MBR: DMS3                     LOCK SUMMARY TRACE - LOCKOUTS                          TO: 02/25/2019 22:18:34
    SSID: DMS3     VER: 12.1                                                                                                    
PRIMAUTH: AMID003  ORIGAUTH: AMID003                                                            PLAN    : AMITEP06              

EVENT TIME                  EVENT     DETAILS                                                                                   
=========================== ========  =========================================================================================
                                                                                        HOLDER   ------------------------------
                                                                                        LUW  : USBMCN01.DMS3LU  .D5BCD69D3D5E   
                                                                                        DSMEM: DMS3       CONNECT: TSO          
                                                                                        PLAN : AMITEP05   CORR   : AMID009      
                                                                                        AUTH : AMID009                          
                                                                                        EUID : AMID009                          
                                                                                        WSNAM: TSO                              
                                                                                        TXNAM: AMID009                          
                                                                                        STMT TYPE: DYNAMIC                      
                                                                                        STMT ID  : 00000000000CA0E2             
                                                                                        LOCK STATE: X      DURATION: COMMIT     

                    BLKTRCLO: LOCK SUMMARY TRC - LOCKOUTS                            08/11/19 23:54:27    PAGE     4            

LOCATION: DMS                                                                                    DATA FROM: 02/24/2019 23:34:27
 D/S GRP: DSNDMS   MBR: DMS3                     LOCK SUMMARY TRACE - LOCKOUTS                          TO: 02/25/2019 22:18:34
    SSID: DMS3     VER: 12.1                                                                                                   
PRIMAUTH: AMID008  ORIGAUTH: AMID008                                                            PLAN    : AMITEP12             

EVENT TIME                  EVENT     DETAILS                                                                                  
=========================== ========  =========================================================================================
02/25/19  12:14:43.93061456 TIMEOUT   BLOCKERS :    1                                                                          

                                         --------------------------- VICTIM THREAD IDENTIFICATION -----------------------------
                                         LUWID   : USBMCN01.DMS3LU.D5BCD07366AE                                                
                                         PRIMAUTH: AMID008    CONNECT: TSO            ENDUSER: AMID008                         
                                         ORIGAUTH: AMID008    CONNTYP: TSO             WSNAME: TSO                             
                                         PLAN    : AMITEP12   CORRID : AMID008        TRXNAME: AMID008                         

LOCK TYPE    LOCK RESOURCE NAME                WAITER DETAILS                           HOLDER/BLOCKER DETAILS                 
------------ --------------------------------- ---------------------------------------  ---------------------------------------
DATA PAGE    0124    .0002    .DPAG.0000040800 FUNC: LOCK       LOCK STATE: S                                                  
             HEX= 0124000200000408000000000000 TYPE: UNCOND       DURATION: MANUAL                                             
                  0000000000000000000000000000 HASH: 00449408   ZPARM INTV:     30                                             
                                               STMTTYP: DYNAMIC   INTV CNT:      1                                             
                                               STMT ID: 00000000000C1A9A                                                       

                                                                                        HOLDER   ------------------------------
                                                                                        LUW  : USBMCN01.DMS3LU  .D5BCD069A38A  
                                                                                        DSMEM: DMS3       CONNECT: TSO         
                                                                                        PLAN : AMITEP09   CORR   : AMID009     
                                                                                        AUTH : AMID009                         
                                                                                        EUID : AMID009                         
                                                                                        WSNAM: TSO                             
                                                                                        TXNAM: AMID009                         
                                                                                        STMT TYPE: DYNAMIC                     
                                                                                        STMT ID  : 00000000000C1A8B            
                                                                                        LOCK STATE: X      DURATION: COMMIT    

 

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