Displaying information about DDF work

The DISPLAY DDF command displays information regarding the status of the distributed data facility (DDF). This command also displays information that is related to the start of DDF, such as the location name, the LU name, the IP address, and domain names.

Before you begin

Begin general-use programming interface information.

To issue the DISPLAY DDF command, you must have SYSOPR authority or higher.

About this task

Tip: You can use the optional DETAIL keyword to receive additional configuration and statistical information.

The DISPLAY DDF DETAIL command is especially useful, because the command displays new inbound connections that are not indicated by other commands. For example, sometimes new inbound connections are not yet reflected in the DISPLAY THREAD report. Cases of when a new inbound connection is not displayed include if DDF is in INACTIVE MODE, as denoted by a DT value of I in the message DSNL090I, and DDF is stopped with mode SUSPEND, or the maximum number of active database access threads has been reached. These new connections are displayed in the DISPLAY DDF DETAIL report. However, specific details regarding the origin of the connections, such as the client system IP address or LU name, are not available until the connections are associated with a database access thread.

Procedure

To display information about DDF work:

Enter one of the following commands:

To show only the basic information, enter the DISPLAY DDF command.

-DISPLAY DDF

Db2 returns output similar to the following sample.

DSNL080I - DSNLTDDF DISPLAY DDF REPORT FOLLOWS:                
DSNL081I STATUS=STARTD                                         
DSNL082I LOCATION         LUNAME       GENERICLU     WLB
DSNL083I STL717A          USIBMSY.SYEC717A   -NONE   RQST
DSNL084I TCPPORT=446   SECPORT=0     RESPORT=5001  IPNAME=-NONE
DSNL085I IPADDR=::9.30.115.135                                 
DSNL085I IPADDR=2002:91E:610:1::5                              
DSNL086I SQL    DOMAIN=v7ec135.svl.ibm.com                     
DSNL087I ALIAS              PORT  SECPORT STATUS  WLB
DSNL088I STL717A1           551   0       STATIC  DFLT             
DSNL088I STL717A2           552   0       STATIC  DFLT             
DSNL088I STL717A3           553   0       STATIC  DFLT             
DSNL088I STL717A4           554   0       STATIC  DFLT             
DSNL088I STL717A5           555   0       STATIC  DFLT             
DSNL088I STL717A6           556   0       STATIC  DFLT
DSNL088I STL717A7           557   0       STATIC  DFLT
DSNL088I STL717A8           558   0       STATIC  DFLT
DSNL099I DSNLTDDF DISPLAY DDF REPORT COMPLETE

To show additional information, enter the DISPLAY DDF command with the DETAIL option.

-DISPLAY DDF DETAIL

With the DETAIL option, the following additional information is included in the output:

DSNL080I  ) DSNLTDDF DISPLAY DDF REPORT FOLLOWS: 211                
DSNL081I STATUS=STARTD                                              
DSNL082I LOCATION           LUNAME            GENERICLU     WLB     
DSNL083I STLEC1             USIBMSY.SYEC1DB2  -NONE         DFLT   
DSNL084I TCPPORT=446   SECPORT=447   RESPORT=5001  IPNAME=XYZ_A     
DSNL085I IPADDR=::9.30.178.50                                       
DSNL085I IPADDR=ABCD::91E:B232                                      
DSNL086I SQL    DOMAIN=xyz_ahost.ibm.com                            
DSNL086I RESYNC DOMAIN=xyz_ahost.ibm.com                            
DSNL087I ALIAS           PORT     SECPORT STATUS  WLB
DSNL088I XYZ_S           448      449     STARTD  RQST
DSNL089I MEMBER IPADDR=::9.30.178.112                               
DSNL089I MEMBER IPADDR=ABCD::91E:B270                               
DSNL090I DT=A  CONDBAT=     64 MDBAT=   64                          
DSNL092I ADBAT=    0 QUEDBAT=      0 INADBAT=      0 CONQUED=      0
DSNL093I DSCDBAT=      0 INACONN=      0 IUDBAT=      0 PQDBAT=      0
DSNL100I LOCATION SERVER LIST:                                      
DSNL101I WT IPADDR            IPADDR  
DSNL102I 64 ::9.30.178.111    ABCD::91E:B26F 
DSNL102I    ::9.30.178.112    ABCD::91E:B270 
DSNL105I DSNLTDDF CURRENT DDF OPTIONS ARE:  
DSNL106I PKGREL = COMMIT                    
DSNL099I DSNLTDDF DISPLAY DDF REPORT COMPLETE

End general-use programming interface information.