Viewing lock related statistics for an exception

Follow these steps to view lock related statistics for an exception.

Procedure

  1. On the DB2 Query Monitor main menu, type 5 in the Option field and press Enter.
  2. Locate the exception for which you want to view lock related statistics.
  3. Type L in the CMD field next to the SQL activity of interest and press Enter.
    The Lock Related Statistics panel is displayed:
    Figure 1. Lock Related Statistics panel
    YYYY/MM/DD HH:MM:SS ------ Lock Related Statistics -----  Row 1 of 23         
    Option  ===> ________________________________________________ Scroll ===> PAGE 
                                                                                   
    DB2 SSID: QM01   Plan: DSNTEP2    DBRM: DSN@EP2L  Coll:        
                     Cursor:                     Section:       2  
    ------------------------------------------------------------------------      
    Lock Deadlocks                                0                                
    Lock Suspensions                              0                                
    Lock Timeouts                                 0                                
    Latch Suspensions                             0                                
    Other Suspensions                             0                                
    Lock Requests                               155                                
    Unlock Requests                               8                                
    Query Requests                                0                                
    Change Requests                               0                                
    Other Requests                                0                                
    Claim Requests                               47                                
    Claim Failures                                0                                
    Drain Requests                                0                                
    Drain Failures                                0                              
    XES Lock Requests                             0                              
    XES Change Requests                           0                              
    XES Unlock Requests                           0                              
    IRLM Global Resource Contention               0                              
    XES Global Resource Contention                0                              
    False Resource Contention                     0                              
    Incompatible Retain Lock                      0                              
    Shared Lock Escalations                       0                              
    Exclusive Lock Escalations                    0                              
    Lock Requests   - PLOCKS                      0
    Change Requests - PLOCKS                      0
    Unlock Requests - PLOCKS                      0
    ***************************** Bottom of Data ** ** **************************