Viewing miscellaneous statistics for current activity
Follow these steps to view miscellaneous 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 miscellaneous statistics.
-
Type Q in the CMD field next to the SQL activity of interest and press
Enter.
The Miscellaneous Statistics panel is displayed:
Figure 1. Miscellaneous Statistics panel YYYY/MM/DD HH:MM:SS ------ Miscellaneous Statistics ------ Row 1 of 39 Option ===> ________________________________________________ Scroll ===> PAGE Filters Enabled: N NAVI: DB2(ST):DB01 ------------------------------------------------------------------------ Event Time/Count Trigger Elapsed Time 0.000000 Trigger DB2 CPU Time 0.000000 UDF Application Elapsed Time 0.000000 UDF Application CPU Time 0.000000 UDF DB2 Elapsed Time 0.000000 UDF DB2 CPU Time 0.000000 SP Application Elapsed Time 0.000000 SP Application CPU Time 0.000000 SP DB2 Elapsed Time 0.000000 SP DB2 CPU Time 0.000000 RIDLIST Used 21 RIDLIST Failed - No Storage 0 RIDLIST Failed - Limit Exceeded 0 Groups Executed 0 Sequential Cursor 0 Sequential No ESA Sort 0 Sequential No Buffer 0 Ran Reduced 0 Ran as planned 0 Procedure Abends 0 Call Timeout 0 Call Reject 0 Sequential Enclave Services 0 One DB2 Coordinator No 0 One DB2 Isolation Level 0 Reoptimization 0 Prep Statement Matched 0 Prep Statement No Match 0 Implicit Prepares 0 Prep From Cache 0 Cache Limit Exceeded 0 Prep Statement Purged 0 ROWID Direct Access 0 ROWID Index Used 0 ROWID TS Scan Used 0 Statement Trigger 0 Row Trigger 0 Trigger SQL Error 0 Log Records Written 0 Log Bytes Written 0 ***************************** Bottom of Data *********************************