Viewing lock related statistics for an exception
Follow these steps to view lock related statistics for an exception.
Procedure
- On the DB2 Query Monitor main menu, type 5 in the Option field and press Enter.
- Locate the exception 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 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 ** ** **************************