Viewing lock related statistics for current activity
Follow these steps to view lock related statistics for current activity.
Procedure
- On the DB2 Query Monitor main menu, type 3 in the Option field and press Enter.
- Locate the SQL activity for which you want to view lock related statistics.
-
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