Distributed Data Facility Statistics
Use this panel to view statistics about DDF activity, formatted by remote Db2 location. Each remote Db2 that has acted as a requester or a server to the monitored (local) Db2 is displayed, together with such statistics as number of transactions sent and received. Miscellaneous information about the local Db2 subsystem, such as send rate and receive rate, is also provided.
________________ ZDFST VTM O2 V540.#P SC12 07/11/16 10:23:38 2
> Help PF1 Back PF3 Up PF7 Down PF8
> D.A
> DISTRIBUTED DATA FACILITY: Enter a selection letter on the top line.
> *-DDF STATISTICS B-DDF VTAM SUMMARY C-DDF VTAM DETAIL H-HISTORICAL
===============================================================================
> DISTRIBUTED DATA FACILITY STATISTICS
DFST
+ Collection Interval: REALTIME Start: 07/11 10:23:29
+ Report Interval: 9 sec End: 07/11 10:23:38
+
+ Location Name = OMPDBC1 DDF Status = ACTIVE
+ DDF CPU Rate = 00.0% Dist Allied Threads = 1
+ Active DBATs = 1 Inactive DBATs = 7
+ DDF Send Rate = 290/sec DDF Receive Rate = 1196/sec
+ Resync Attempts = 0 Resync Successes = 0
+ Cold Start Connections = 0 Warm Start Connections = 0
+ DBAT Queued = 0 Conversations Dealloc = 0
+ HWM Remote Connections = 9 HWM Active DBATs = 5
+ Max DB Access (MAXDBAT)= 200 HWM Inactive DBATs = 11
+
+ Remote Location Name = DRDA REMOTE LOCS
+
+ Conversations Queued = 0
+ Indoubts/Remote = 0
+
+ SQL Row Message Byte Commit Abort Conv Blocks
+ ------- ------- ------- -------- ------- ------- ------- -------
+ Sent 24 788458 238780 81238724 8 0 12 53662
+ Recv 137757 12 238781 99665357 54089 12052 5686 12
===============================================================================
Fields
- Collection Interval
- Shows the
REALTIMEto indicate that you are looking at the realtime version of this panel and not at the corresponding near-term history panel. The collection interval and the report interval are the same in this panel. - Start
- The start time of the first report interval in this display.
- Report Interval
- The time in the last cycle (for example, between two presses of the Enter key).
- End
- The end time of the last report interval in this display.
- Location Name
- The DDF location name of the Db2 subsystem being monitored.
- DDF Status
- The status of the Distributed Database Facility: ACTIVE or NOT ACTIVE.
- DDF CPU Rate
- The CPU rate of the DDF address space. Includes both MVS TCB and SRB time.
- Dist Allied Threads
- The number of distributed allied threads that are currently active.
- Active DBATs
- The number of currently active database access threads.
- Inactive DBATs
- The number of currently inactive database access threads.
- DDF Send Rate
- The rate at which data is being sent by DDF, in bytes, KB, MB, GB per second.
- DDF Receive Rate
- The rate at which data is being received by DDF, in bytes, KB, MB, GB per second.
- 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.
- DBATs 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 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.
- 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).
- HWM Inactive DBATs
- The high-water mark (HWM) of inactive database access threads (DBATs).
Remote statistics: The following group of fields occurs for each remote Db2 location with which the local Db2
subsystem has communicated, either as a requester or a responder, since the local Db2 was started.
- Remote Location Name
- The name of a remote location with which the local Db2 has communicated. The statistics immediately below this field pertain to this location.
- Conversations Queued
- The number of conversations queued by DDF since the local Db2 was started.
- Indoubts/Remote
- The number of threads that became indoubt with the remote location as coordinator.
Each of the following sent/received fields generates two rows of output; the top row is the sent
value, and the bottom row is the received value.
- SQL Sent/Recv
- The number of SQL calls sent to and from the remote location since the local Db2 was started.
- Row Sent/Recv
- The number of rows sent to and from the remote location since the local Db2 was started.
- Message Sent/Recv
- The number of VTAM® messages sent to and from the remote location since the local Db2 was started.
- Byte Sent/Recv
- The number of bytes sent to and from the remote location since the local Db2 was started.
- Commit Sent/Recv
- The number of Commits sent to and from the remote location since the local Db2 was started.
- Abort Sent/Recv
- The number of aborts sent to and from the remote location since the local Db2 was started.
- Conv Sent/Recv
- The number of conversations sent to and from the remote location since the local Db2 was started.
- Blocks Sent/Recv
- The number of blocks sent to and from the remote location, if using block mode.