Analyzing DDF connections and activity

To analyze DDF connections and activity

1. 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 ZPARMs

   EZDDF 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.

2. 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    1

   The 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.

3. 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 = 43ms

   BBMXV336I --- End of message(s) from targets on BMCE ---

   Otherwise, the PING command times out and a message is issued.

4. Press F3 until you return to EZDDF.

5. 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     0

   The 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.

6. Press F3 as needed to return to EZDDF.

7. 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 only

8. In 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  DSNESPCS

   On 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.

9. Press F3 until you return to EZDSSI.