Analyzing DDF connections and activity
From EZDSSI, hyperlink on DDF Menu to display the EZDDF easy menu.
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 Stats . Monitor Profile Stats
. Db2 Connect . Remote Locations
. Univ. JDBC Driver
. MVz/OS Enclaves (zIIP) ZPARMs - One Db2
. Inactive Threads . DDF ZPARMsEZDDF provides access to information about DDF connections, DBAT threads, statistics, exception monitors, ZPARM installation parameters, and (if BMC AMI Ops Monitor for z/OS is installed) IBM System z Integrated Information Processor (zIIP) usage for active DBAT threads.
Hyperlink on All Locations to display a summary of the DDF connections by Db2 subsystem and remote location.
>W1 =DDFLOCZ==========(ALL======*=======)10MAR2011==09:07:36====MVDB2====D====2
C Db2 Remote Link Network Req Srv Totl Ina Totl
- Target Location Name Idle Time Con Con Con Con Cnv
DEDM ::172.17.8.86 ::172.17.8.86 00:03:14.7 0 1 1 0 1
p DEDM ::172.23.59.211 ::172.23.59.211 00:02:10.2 0 1 1 0 1The PING and TRACERT commands are available on this view and several other DDF views to check the state of a TCP/IP connection and to trace the route to a destination. Network security might limit your ability to execute these commands.
In the C line command field, enter P next to a connection to issue an ICMP echo request to a remote IP host.If an echo reply is received within ten seconds, the host is considered accessible and the elapsed response time is shown:
BBMXV335I Message(s) received from targets on BMCE ---BBPF1015I Ping: 'mwitkows-BMC-04.bprod.bmc.com' is alive; time = 43msBBMXV336I --- End of message(s) from targets on BMCE ---Otherwise, the PING command times out and a message is issued.
- Press F3 until you return to EZDDF.
Hyperlink on Client Products - SSI to display DDF connections summarized by client product ID.In SSI mode, the DDFPRODZ view summarizes connections for all monitored Db2 subsystems.
W1 =DDFPRODZ=========(ALL======*=======)10MAR2011==09:48:49====MVDB2====D===
Client Network Last Activ Inact Total Activ Inact Tota
Product Idle Time Network I/O Time Conns Conns Conns Convs Convs Conv
DSN 00:44:27.90 2008.184 09:04:21.51 1 0 1 1 0
SQL 00:43:23.36 2008.184 09:05:26.05 1 0 1 1 0The network idle time and last network I/O time stamp are valuable indicators of potential problems with remote clients and connections.
If the Client Product field displays SQL, it hyperlinks to Db2 Connect activity. If it displays JCC, it hyperlinks to JDBC Universal Driver activity.
Both the DDFPRODZ and DDFLOCZ views hyperlink to views that display connections and conversations for the remote product or remote location.
- Press F3 as needed to return to EZDDF.
Hyperlink on Connections Menu to display the EZDDF2 easy menu.Use this menu to check the status of threads, connections, and conversations by server or requester.
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 onlyIn the All Threads section, hyperlink on Server to display the DDFTHDZ view.
>W1 =DDFTHDZ==========(ALL======*=======)10MAR2011==11:09:41====MVDB2====D====1
C Db2 Agnt Agt Cnv Network Thread Connect Correlation Plan
- Target Stat Typ Cnt Idle Tim Token Name ID AuthID Name
DEDM Acti Srv 1 02:05:20 115 TSO BOLDJW1 BOLDJW1 DSNESPCSOn this view and other DDF views, the Thread Token and AuthID fields hyperlink to the THDDETL view and DUSER display for additional information about active DBATs or distributed threads.
- Press F3 until you return to EZDSSI.