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
DSNL083I SVL650A               USIBMSY.SYEC650A     -NONE
DSNL084I TCPPORT=446   SECPORT=0	RESPORT=5001 IPNAME=-NONE
DSNL085I IPADDR=::9.110.115.106
DSNL085I IPADDR=2002:91E:610:1::5
DSNL086I SQL    DOMAIN=v8ec103.svl.ibm.com
DSNL086I RESYNC DOMAIN=v8ec103.svl.ibm.com
DSNL087I ALIAS              PORT  SECPORT  STATUS
DSNL088I ALIASLOC1          551   0        STATIC
DSNL088I ALIASLOC2          552   0        STATIC
DSNL088I ALIASLOC3          553   0        STATIC
DSNL088I ALIASLOC4          554   0        STATIC
DSNL088I ALIASLOC5          555   0        STATIC
DSNL088I ALIASLOC6          556   0        STATIC
DSNL088I ALIASLOC7          557   0        STATIC
DSNL088I ALIASLOC8          558   0        STATIC
DSNL089I MEMBER IPADDR=::9.110.115.112 
DSNL089I MEMBER IPADDR=2002:91E:610:1::112
DSNL105I CURRENT DDF OPTIONS ARE: 
DSNL106I PKGREL = COMMIT          
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:

DSNL090I DT=      A CONDBAT=  64 MDBAT=   64
DSNL092I ADBAT=   1 QUEDBAT=   0 INADBAT=  0 CONQUED=      0
DSNL093I DSCDBAT= 0 INACONN=   0  IUDBAT = 1
DSNL100I     LOCATION SERVER LIST:                                    
DSNL101I     WT IPADDR            IPADDR                              
DSNL102I     64 ::9.110.115.111   2002:91E:610:1::111                 
DSNL102I        ::9.110.115.112   2002:91E:610:1::112                 
DSNL099I DSNLTDDF DISPLAY DDF REPORT COMPLETE

End general-use programming interface information.