Viewing lock related statistics for current activity

Follow these steps to view lock related statistics for current activity.

Procedure

  1. On the DB2 Query Monitor main menu, type 3 in the Option field and press Enter.
  2. Locate the SQL activity 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 
                                                                                   
    Filters Enabled: N  
    NAVI:   DB2(ST):DB01                                         
    ------------------------------------------------------------------------      
    Lock Event                          Event Count
    Lock Deadlocks                                0
    Lock Suspensions                              0
    Lock Timeouts                                 0
    Latch Suspensions                             0
    Other Suspensions                             0
    Lock Requests                               175
    Unlock Requests                              36
    Query Requests                                0
    Change Requests                               0
    Other Requests                                0
    Claim Requests                               46
    Claim Failures                                0
    Drain Requests                                0
    Drain Failures                                0
    XES Lock Requests                            40
    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                      2
    Change Requests - PLOCKS                      0
    Unlock Requests - PLOCKS                      0