Follow these steps to view miscellaneous statistics.
Procedure
-
On the DB2 Query Monitor main menu, type 1 in the
Option field and press Enter.
- Select the appropriate summary level.
- Locate the SQL activity for which you want to view lock
information.
-
Type Q in the CMD field next to the SQL activity of interest and press
Enter.
The
Miscellaneous Statistics panel is displayed: