DDF activity and connections

DDF information is found in many areas of such as thread activity, system statistics, and ZPARMs.

Information about DDF connections to and from Db2 for z/OS is available in the DDF* views. DBAT thread and connection data can be selected by the client product-ID, providing filtered access to DBAT activity from Db2 Connect or the Db2 Universal JDBC Driver. You can also hyperlink to to see extended DDF enclave information that includes zIIP usage for all DBATs with an active enclave.

Related topic

Application-analysis-views

You can access all of the information that pertains to DDF from the Db2 DDF easy menu (EZDDF).

   Db2 DDF Menu
    Connections                                         Monitors
  . Client Products         +----------------------+ . DBAT DRDA Workload
  . Server Products         |   Place cursor on    | . DBAT PVT Workload
  . Analytics Accelerator   |    menu item and     | . DDF DIST Paging
  . All Locations           |     press ENTER      | . DDF Active Monitors
  .   TCP/IP Locations      +----------------------+
  .   SNA Locations
  > Connection Menu           Statistics - One Db2      Statistics - SSI
                            . Global DDF Statistics   . Global DDF Statistics
    Threads                 . DDF Activity Counts     . DDF Activity Counts
  . Active DBATs            . Monitor Profile Xcepts . Monitor Profile Stats
  . Db2 Connect            . Monitor Profile All     . Monitor Profile All
  . Univ. JDBC Driver      . Remote Locations
  . MVz/OS Enclaves (zIIP)
  . Inactive Threads           ZPARMs - One Db2
                            . DDF ZPARMs

To drill down further into the DDF connection views, the Db2 DDF Connection easy menu (EZDDF2) provides additional options.

                              DDF Connection Menu
    Threads                                             Conversations
  . All Threads             +----------------------+ . All Conversations
  .   Server                |   Place cursor on    | .   Server
  .   Requester             |    menu item and     | .   Requester
                            |     press ENTER      |
  . Active Threads          +----------------------+ . Active Conversations
  .   Server                                          .   Server
  .   Requester               Products                .   Requester
                            . Client
  . Inactive Connections    . Server                  . Inactive Conversations
  .   Server                                          .   Server
  .   Requester               Locations               .   Requester
                            . All Locations
  . Analytics Accelerator   .   TCP/IP only           . Analytics Accelerator
                            .   SNA only

The DDF views provide detailed information about active and inactive connections, conversations, and threads. The network status, the last activity time stamp, and network idle time are valuable indicators of potential problems with remote clients or connections.

The following commands are available on several of the DDF views:

The PING command checks the state of the TCP/IP connection and identifies the Domain Name Server (DNS).
The TRACERT command traces the route to a destination by sending Internet Control Message Protocol (ICMP) echo requests to the destination.

See the online Help for more information about these commands.

Many of the DDF connection views hyperlink to the THDDETL view and the DUSER display for additional information about active DBATs or Db2 for z/OS requester threads.

The following table lists the views that are available for DDF activity and connections:

View name	Type	Description
DDFDETL	Detail	DDF Conversation Detail Provides detailed information about a DDF conversation
DDFINACT	Tabular	DDF Inactive Connections Lists inactive DDF connections
DDFLIST	Tabular	DDF Conversation List Lists all of the DDF conversations for each Db2 and hyperlinks to DDFDETL
DDFLOCZ	Summary	DDF Location Summary Summarizes DDF conversations by Db2 subsystem and remote location
DDFPRODZ	Summary	DDF Client Product Summary Summarizes DDF connections by client product name Hyperlink on the Client Product column to see Db2 Connect activity (SQL) or JDBC Universal Driver activity (JCC). In SSI mode, the view can summarize connections for all members of a data sharing group.
DDFSERVZ	Summary	DDF Server Summary Summarizes DDF connections by server ID
DDFTHDZ	Summary	DDF Thread Summary Summarizes DDF conversations by thread
STLOCS	Tabular	Remote connection statistics since Db2 started
STLOCSD	Detail	Detail statistics for a remote location

The following table lists the views that are available to display monitor profile statistics:

View name	Type	Description
PRFZ	Summary	Monitor Profile Statistics Exception Summary Summarizes the monitor profile exception activity by Db2 target Use this view to determine when and what type of monitor profile exception activity has occurred.
PRFALLZ	Summary	Monitor Profile Statistics All Summary Summarizes all started monitor profiles by Db2 target Use this view to summarize all started monitor profiles, including their current connection and thread counts.
PRFLIST	Tabular	Monitor Profile Statistics List Lists monitor profiles that have had exception activity at some point during the life of the target Db2 instance, or all started monitor profiles when invoked as stand-alone profiles.
PRFDETL	Detail	Monitor Profile Statistics Detail Provides detailed information for a given started monitor profile

DDF activity and connections

On this page