Subsystem Support Manager Statistics Summary by Report Interval
This panel provides an overview of the Db2 activity that was recorded during a series of report intervals.
________________ ZHSMS VTM O2 V550.#P DA41 11/06/13 11:39:08 2
> Help PF1 Back PF3 Up PF7 Down PF8 Zoom PF11
> H.A.A
> Enter a selection letter on the top line.
>
> *-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 L-DB2 COMMANDS
> O-OPTIONS
===============================================================================
> SUBSYSTEM SUPPORT MANAGER STATISTICS SUMMARY BY REPORT INTERVAL
HSMS
+ Collection Interval: 1 min Start: 11/06 09:39
+ Report Interval: 1 min Combine Level: NONE End: 11/06 11:39
+
+ Create Total Queued
+ Thread/ Commit/ Total Abort at Indoubt EOT+EOM
+ Interval Minute Minute Commits Reqs Cthread Threads Abends
+ ----------- --------- --------- ------- ------ ------- ------- -------
+ 11/06 11:39 .00 43.00 86 0 0 0 0
+ 11/06 11:37 .00 74.00 74 0 0 0 0
+ 11/06 11:36 .00 72.00 72 0 0 0 0
+ 11/06 11:35 .00 74.00 74 0 0 0 0
+ 11/06 11:34 .00 72.00 72 0 0 0 0
+ 11/06 11:33 .00 74.00 74 0 0 0 0
+ 11/06 11:32 .00 72.00 72 0 0 0 0
+ 11/06 11:31 .00 74.00 74 0 0 0 0
+ 11/06 11:30 .00 72.00 72 0 0 0 0
Navigation
For additional information about
- a report interval, move the cursor to the line you want 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 this 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.
- End
- The end time of the last interval in this display.
- Interval
- Provides the date and time that mark the end of the report interval.
- Create Thread/Minute
- The number of successful Create Thread requests per minute.
- Total Commit/Minute
- The number of commit requests per minute.
- Total Commits
- Includes read-only, single-phase, and phase 2 commit requests.
- Abort Reqs
- The number of events that resulted in successfully backing out a unit of recovery.
- Queued at Cthread
- The number of Create Thread requests that had to wait because no thread was available.
- Indoubt Threads
- The number of indoubt threads. A unit of recovery (thread) goes indoubt when a failure occurs between commit phase 1 and commit phase 2.
- EOT+EOM Abends
- The total number of end-of-task and end-of-memory abends.