Viewing call level statistics for current activity
Follow these steps to view call level 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 call level statistics.
-
Type C in the CMD field next to the SQL activity of interest and press
Enter.
The Call Level Statistics panel is displayed:
Figure 1. Call Level Statistics panel YYYY/MM/DD HH:MM:SS ------- Call Level Statistics ------ Row 1 of 3 Option ===> ________________________________________________ Scroll ===> PAGE DB2 SSID: DB01 Plan: PLAN0001 DBRM: DBRM1 Coll: DSNTEP2 Cursor: C1 Section: 1 Filters Enabled: N CMD - Enter "/" to select action ------------------------------------------------------------------------ > CMD STMT# DB2 CPU Time DB2 Elapsed GETPAGES SQLCODE SQL Calls - ------ -------------- -------------- -------------- ------- ----------- _ 1,683 0.006072 0.059150 0 0 1 _ 1,631 0.000030 0.000030 0 0 1 _ 1,619 0.000210 0.000310 0 0 1 ***************************** Bottom of Data **********************************