Distributed Data Facility Statistics Summary by Report Interval
This panel provides an overview of the DDF activity that was recorded during a series of report intervals.
________________ ZHDFS VTM O2 V550.#P SC11 07/11/16 13:31:41 2
> Help PF1 Back PF3 Up PF7 Down PF8 Zoom PF11
> H.A.E
> Enter a selection letter on the top line.
>
> A-SUBSYSTEM SUPPORT B-BIND C-BUFFER POOL D-GROUP BP
> *-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
===============================================================================
> DISTRIBUTED DATA FACILITY STATISTICS SUMMARY BY REPORT INTERVAL
HDFS
+ Collection Interval: 15 min Start: 07/08 18:45
+ Report Interval: 15 min Combine Level: NONE End: 07/11 13:31
+
+ # of Total Total Total Total Total Total Total Total
+ Interval Rmts SQL Rows Msgs Bytes Commit Abort Conv Convq
+ ----------- ---- ------ ------ ------ ------ ------ ----- ------ -----
+ 07/11 13:31 1 0 0 0 0 0 0 0 0
+ 07/11 13:15 1 0 0 0 0 0 0 0 0
+ 07/11 13:00 1 17145 2148 55726 6990K 2148 0 2140 0
+ 07/11 12:45 1 20866 2593 68134 8542K 2609 31 2643 0
+ 07/11 12:30 1 0 0 0 0 0 0 0 0
+ 07/11 12:15 1 0 0 0 0 0 0 0 0
+ 07/11 12:00 1 0 0 0 0 0 0 0 0
+ 07/11 11:45 1 0 0 0 0 0 0 0 0
+ 07/11 11:30 1 0 0 0 0 0 0 0 0
+ 07/11 11:15 1 0 0 0 0 0 0 0 0
+ 07/11 11:00 1 0 0 0 0 0 0 0 0
+ 07/11 10:45 1 8501 1064 27628 3459K 1066 1 1061 0
+ 07/11 10:30 1 7569 937 24930 3106K 943 39 979 0
+ 07/11 10:15 1 0 0 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 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.
- # of Rmts
- The number of remote Db2s with which the local Db2 communicated during a given interval.
- Total SQL
- The total SQL calls sent and received by the local Db2.
- Total Rows
- The total rows of data sent and received by the local Db2.
- Total Msgs
- The total VTAM® messages sent and received by the local Db2.
- Total Bytes
- The total bytes sent and received by the local Db2.
- Total Commit
- The total number of Commit operations performed. This is the sum of the single-phase and two-phase commits performed.
- Total Abort
- The total number of rollback operations performed. This is the sum of the single-phase rollback operations and two-phase backouts performed.
- Total Conv
- The total conversations sent and received by the local Db2.
- Total ConvQ
- The total number of conversations queued by DDF.