DDF activity and connections
DDF information is found in many areas of MainView for DB2, 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 MainView for z/OS to see extended DDF enclave information that includes zIIP usage for all DBATs with an active enclave.
You can access all of the information that pertains to DDF from the DB2 DDF easy menu (EZDDF).
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 Stats . Monitor Profile Stats
. DB2 Connect . Remote Locations
. Univ. JDBC Driver
. MVz/OS Enclaves (zIIP) ZPARMs - One DB2
. Inactive Threads . DDF ZPARMs
To drill down further into the DDF connection views, the DB2 DDF Connection easy menu (EZDDF2) provides additional options.
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 Summary Summarize monitor profile activity by target Use this view to determine when and what type of monitor profile activity has occurred. |
PRFLIST | Tabular | Monitor Profile Statistics List Lists monitor profiles that have had activity at some point during the life of the target instance |
PRFDETL | Detail | Monitor Profile Statistics Detail Provides detailed information about the activity of a given monitor profile |
Related topic