Db2 Command Statistics By Report Interval
This panel provides an overview of Db2 command activity recorded during a series of report intervals.
You can view detailed statistics by zooming in on that interval.
________________ ZHCMS VTM O2 V550.#P SE12 11/06/13 12:02:43 2
> Help PF1 Back PF3 Up PF7 Down PF8 Zoom PF11
> H.A.L
> Enter a selection letter on the top line.
>
> A-SUBSYSTEM SUPPORT B-BIND C-BUFFER POOL D-GROUP BP
> E-DISTRIBUTED DATABASE F-EDM POOL G-LOG MANAGER H-OPEN/CLOSE
> I-SQL/RID/PARALLEL/PROC J-LOCK/CLAIM/DRAIN K-GLOBAL LOCK *-DB2 COMMANDS
> O-OPTIONS
===============================================================================
> DB2 COMMAND STATISTICS SUMMARY BY REPORT INTERVAL
HCMS
+ Collection Interval: 1 min Start: 11/06 11:44
+ Report Interval: 1 min Combine Level: NONE End: 11/06 12:02
+
+ START/ START/STOP/ RECOVER/ CANCEL ALTER
+ STOP MODIFY ARCHIVE RESET DDF BUFFER
+ Interval DATABASE TRACE LOG INDOUBT THREAD POOL
+ ----------- ---------- ----------- -------- -------- -------- --------
+ 11/06 12:02 0 0 0 0 0 0
+ 11/06 12:01 0 0 0 0 0 0
+ 11/06 12:00 0 0 0 0 0 0
+ 11/06 11:59 0 0 0 0 0 0
+ 11/06 11:58 0 0 0 0 0 0
+ 11/06 11:57 0 0 0 0 0 0
+ 11/06 11:56 0 0 0 0 0 0
+ 11/06 11:55 0 0 0 0 0 0
+ 11/06 11:54 0 0 0 0 0 0
+ 11/06 11:53 0 0 0 0 0 0
+ 11/06 11:52 0 0 0 0 0 0
+ 11/06 11:51 0 0 0 0 0 0
+ 11/06 11:50 0 0 0 0 0 0
+ 11/06 11:49 0 0 0 0 0 0
+ 11/06 11:48 0 0 0 0 0 0
+ 11/06 11:47 0 0 0 0 0 0
+ 11/06 11:46 0 0 0 0 0 0
+ 11/06 11:45 0 0 0 0 0 0
===============================================================================
Navigation
For additional information about:
- A report interval, move the cursor to the required line and press F11 (Zoom). (Each date/time displayed reflects the end of an interval.)
- Related topics, select one of the options at the top of the panel.
- Other topics, use the PF keys.
Fields
- Collection Interval
- The time interval specified for the collection of near-term history data. This unit of time was specified when the Near-Term History Data Collector was started.
- Start
- The start time of the first interval in the display.
- Report Interval
- This field determines the report interval. It is set on the Near-Term History Report Option panel.
- Combine Level
- This field reflects the selected combine level.
If Combine Level is NONE, the report interval is the same as the collection
interval. Possible values:
- HOURLY
- Data will be reported in hourly intervals.
- NONE
- Data will be reported in the time unit specified by the collection interval.
For each field described below the following statistics
are provided:
- The amount of activities that occur during the interval.
- Rate per minute during the interval.
- Percentage of total commands during the interval.
- START/STOP DATABASE
- The number of Start and Stop Database commands executed this interval to change the availability of specified databases.
- START/STOP/MODIFY TRACE
- The number of Start, Stop, and Modify Trace commands executed this interval to trace activity in the Db2 subsystem.
- ARCHIVE LOG
- The number Archive Log commands executed to initiate a Db2 active log switch.
- RECOVER/RESET INDOUBT
- The number of Recover and Reset Indoubt commands executed this interval to recover or purge indoubt threads.
- CANCEL DDF THREAD
- The number of Cancel DDF Thread commands executed this interval to cancel a distributed thread.
- ALTER BUFFERPOOL
- The number of ALTER BUFFERPOOL commands executed this interval to alter attributes for active or inactive buffer pools.