-DISPLAY DDF command (Db2)
The DISPLAY DDF command displays information regarding the status and configuration of DDF, as well as statistical information regarding connections or threads controlled by DDF.
Abbreviation: -DIS DDF
Environment for -DISPLAY DDF
This command can be issued from a z/OS® console, a DSN session under TSO, a DB2I panel (DB2 COMMANDS), an IMS or CICS® terminal, or a program using the instrumentation facility interface (IFI).
Data sharing scope: Member
Authorization for -DISPLAY DDF
To
execute this command, you must use a privilege set of the
process that includes one of the following privileges or
authorities:
- DISPLAY privilege
- System DBADM authority
- SYSOPR authority
- SYSCTRL authority
- SYSADM authority
Db2 commands that are issued from a logged-on z/OS console or TSO SDSF can be checked by Db2 authorization using primary and secondary authorization IDs. 
A logged-on z/OS user ID must be defined in RACF or a similar security server.
Syntax for -DISPLAY DDF
Option descriptions for -DISPLAY DDF
- ALIAS(alias-name)
- Displays information specific to the DDF location alias specified by alias-name.
- DETAIL
- Displays additional statistics and configuration information.
Output for -DISPLAY DDF
Message DSNL080I indicates the beginning of the output of the command.
Examples for -DISPLAY DDF
- Example: Displaying a detailed DDF report when DDF has not been started
- Suppose that DDF has not been started. The following command displays a DDF detail report:
-DISPLAY DDF DETAILThe output is similar to this output:
DSNL081I STATUS=STOPDQ DSNL082I LOCATION LUNAME GENERICLU WLB DSNL083I STLEC1 -NONE.SYEC1DB2 -NONE RQST DSNL084I TCPPORT=446 SECPORT=0 RESPORT=5001 IPNAME=-NONE DSNL085I IPADDR=NONE DSNL086I SQL DOMAIN=-NONE 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 DSNL105I DSNLTDDF CURRENT DDF OPTIONS ARE: DSNL106I PKGREL = COMMIT DSNL099I DSNLTDDF DISPLAY DDF REPORT COMPLETE - Example: Displaying a summary DDF report when DDF has been started
- Suppose that DDF has been started. The following command displays a DDF summary report:
-DISPLAY DDFThe output is similar to this output:
DSNL080I ) DSNLTDDF DISPLAY DDF REPORT FOLLOWS: DSNL081I STATUS=STARTD DSNL082I LOCATION LUNAME GENERICLU WLB DSNL083I STLEC1 -NONE -NONE RQST 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 STATIC RQST DSNL089I MEMBER IPADDR=::9.30.178.112 DSNL089I MEMBER IPADDR=ABCD::91E:B270 DSNL099I DSNLTDDF DISPLAY DDF REPORT COMPLETE - Example: Displaying a detailed DDF report when DDF has been started
- Suppose that DDF has been started. The following command displays a detailed DDF report:
-DISPLAY DDF DETAILThe output is similar to this output:
DSNL080I ) DSNLTDDF DISPLAY DDF REPORT FOLLOWS: 211 DSNL081I STATUS=STARTD DSNL082I LOCATION LUNAME GENERICLU WLB DSNL083I STLEC1 USIBMSY.SYEC1DB2 -NONE RQST 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 STATIC 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 - Example: Displaying a summary DDF report when location aliases are defined
- The following command displays a DDF summary report.
-DISPLAY DDFSuppose that the DSNJU003 utility has been used to define location aliases. The output includes information about location aliases, as shown in the following output:
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 RQST DSNL088I STL717A2 552 0 STATIC RQST DSNL088I STL717A3 553 0 STATIC RQST DSNL088I STL717A4 554 0 STATIC RQST DSNL088I STL717A5 555 0 STATIC RQST DSNL088I STL717A6 556 0 STATIC RQST DSNL088I STL717A7 557 0 STATIC RQST DSNL088I STL717A8 558 0 STATIC RQST DSNL099I DSNLTDDF DISPLAY DDF REPORT COMPLETE - Example: Displaying information about a specific location alias when DDF has not been started
- The following command displays information about location alias ALIAS01 when DDF has not been started.
-DISPLAY DDF ALIAS(ALIAS01)The output is similar to the following output:
-DISPLAY DDF ALIAS(ALIAS01) DSNL080I @ DSNLTDDF DISPLAY DDF REPORT FOLLOWS: DSNL087I ALIAS PORT SECPORT STATUS WLB DSNL088I ALIAS01 5004 5005 STOPD RQST DSNL089I MEMBER IPADDR=::9.30.114.22 DSNL089I MEMBER IPADDR=2002:91E:610::1 DSNL099I DSNLTDDF DISPLAY DDF REPORT COMPLETE - Example: Displaying detailed information about a specific location alias when DDF has been started
- The following command displays information about location alias alias01 when DDF has been started.
-DISPLAY DDF ALIAS(ALIAS01) DETAILThe output is similar to the following output:
DSNL080I @ DSNLTDDF DISPLAY DDF REPORT FOLLOWS: DSNL087I ALIAS PORT SECPORT STATUS WLB DSNL088I ALIAS01 5004 5005 STARTD RQST DSNL089I MEMBER IPADDR=::9.30.114.22 DSNL089I MEMBER IPADDR=2002:91E:610::1 DSNL096I ADBAT= 100 CONQUED= 1000 TCONS= 1000 DSNL100I LOCATION SERVER LIST: DSNL101I WT IPADDR IPADDR DSNL102I 32 ::9.30.114.22 2002:91E:610::1 DSNL102I 32 ::1.2.3.4 DSNL099I DSNLTDDF DISPLAY DDF REPORT COMPLETE