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.