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: