Distributed Data Facility Statistics Detail
This panel provides detailed near-term history statistics about DDF activity for a selected report interval, formatted by remote DB2 location.
________________ ZHDFD VTM O2 V540.#P SC11 07/11/16 19:13:47 2
> Help PF1 Back PF3 Up PF7 Down PF8
>
> 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
> M-THREAD HISTORY
===============================================================================
> DISTRIBUTED DATA FACILITY STATISTICS DETAIL
HDFD
+ Collection Interval: 15 min Start: 07/11 12:45
+ Report Interval: 15 min Combine Level: NONE End: 07/11 13:00
+
+ DDF Send Rate = 232K/min DDF Receive Rate = 234K/min
+ Resync Attempts = 0 Resync Successes = 0
+ Cold Start Connections = 0 Warm Start Connections = 0
+ DBAT Queued = 0 Conversations Dealloc = 0
+ HWM Remote Connections = 28 HWM Active DBATs = 28
+ Max DB Access (MAXDBAT)= 200 HWM Inactive DBATs = 14
+
+ Remote Location Name = DRDA REMOTE LOCS
+
+ Conversations Queued = 0
+ Indoubts/Remote = 0
+
+ SQL Row Message Byte Commit Abort Conv Blocks
+ ------- ------- ------- -------- ------- ------- ------- -------
+ Sent 0 2148 27873 3565972 0 0 0 2148
+ Recv 17145 0 27853 3591798 2148 0 2140 0
===============================================================================
Navigation
For additional information about
- 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 interval currently displayed.
- 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 interval currently displayed.
- DDF Send Rate
- The rate at which data was sent by DDF, in bytes, KB, MB, GB per minute.
- DDF Receive Rate
- mighThe rate at which data was received by DDF, in bytes, KB, MB, GB per minute.
- Resync Attempts
- The number of resynchronization connects attempted with all remote locations. Used only for two-phase commit.
- Resync Successes
- The number of resynchronization connects that succeeded with all remote locations. Used only for two-phase commit.
- Cold Start Connections
- The number of Cold Start connections with all remote locations. Used only for two-phase commit.
- Warm Start Connections
- The number of Warm Start connections with all remote locations. Used only for two-phase commit.
- DBAT Queued
- Number of times a database access thread (DBAT) had to wait because the maximum number of concurrent DBATs (MAXDBAT) was reached.
- Conversation Dealloc
- The number of conversations deallocated because the ZPARM limit for the maximum connected remote threads (both active and inactive) was reached.
- HWM Remote Connections
- The high-water mark (HWM) of inactive and active remote threads.
- HWM Active DBATs
- The high-water mark (HWM) of active database access threads (DBATs). If the INACTIVE option is specified, it is possible for this value and the current number of active DBATs to exceed MAXDBAT. This occurs because Db2 allows CONNECTs to be processed even if MAXDBAT has been exceeded. After connect processing is complete, if MAXDBAT is still exceeded, then the DBAT is made inactive.
- HWM Inactive DBATs
- The high-water mark (HWM) of inactive database access threads.
- Max DB Access (MAXDBAT)
- The maximum number of database access threads allowed for the Db2 being monitored (determined by the setting of MAXDBAT in DSNZPARM).
Remote statistics: The following group of fields occurs for each remote Db2 location with which the local Db2 subsystem communicated, either as a requester or a responder, during the report interval. Each sent/received field generates two rows of output; the top row is the sent value, and the bottom row is the received value.
- Remote Location Name
- The name of a remote location with which the local DB2 communicated. The statistics immediately below this field pertain to this location.
- Conversations Queued
- The number of conversations queued by DDF.
- Indoubts/Remote
- The number of threads that became indoubt with the remote location as coordinator.
- SQL Sent/Recv
- The number of SQL calls sent to and from the remote location.
- Row Sent/Recv
- The number of rows sent to and from the remote location.
- Message Sent/Recv
- The number of VTAM® messages sent to and from the remote location.
- Byte Sent/Recv
- The number of bytes sent to and from the remote location.
- Commit Sent/Recv
- The number of Commits sent to and from the remote location.
- Abort Sent/Recv
- The number of aborts sent to and from the remote location.
- Conv Sent/Recv
- The number of conversations send to and from the remote location.
- Blocks Sent/Recv
- Number of blocks sent to and from the remote location, if using block fetch mode.