Displaying DDF information
You can display the status and configuration of the distributed data facility (DDF) for your Db2® subsystem.
Procedure
To display DDF:
- On the DB2 Administration Menu (ADB2) panel, specify option Z, and press Enter.
- On the System Administration (ADB2Z) panel, specify option DF, and press Enter.
-
On the Display DDF (ADBPZDF) panel, specify whether you want details displayed and optionally specify a DDF location alias:
Figure 1. Display DDF (ADBPZDF) panel ADBPZDF n DD1A Display DDF 13:05 COMMAND ===> -DISPLAY DDF ALIAS . . . . . . . . . (Name) DETAIL . . . . . . . . (Yes/No) Output to . . . . . . . (I - Interpretation, B - Browse)The information that you specify on this panel will be used to construct a Db2 DISPLAY DDF command. With the exception of the Output to field, the options on this panel correspond to the command options.
-
In the Output to field, specify where you want to view the result of the DISPLAY DDF command, and press Enter:
- B
- An ISPF BROWSE session
- I
- An interpretation panel
If you specified B, the results are displayed in an ISPF Browse session, as shown in the following figure:
Figure 2. Display DDF (ADB2DB2O) panel ************************************** Top of Data ***************** DSNL080I #DSNA- DSNLTDDF DISPLAY DDF REPORT FOLLOWS: DSNL081I STATUS=STARTD DSNL082I LOCATION LUNAME GENERICLU DSNL083I DSNA USIBMSTM.STM4DSNA -NONE DSNL084I TCPPORT=8107 SECPORT=8108 RESPORT=8109 IPNAME=-NONE DSNL085I IPADDR=::9.30.5.16 DSNL086I SQL DOMAIN=stplex4a.svl.ibm.com DSNL105I CURRENT DDF OPTIONS ARE: DSNL106I PKGREL = COMMIT DSNL099I DSNLTDDF DISPLAY DDF REPORT COMPLETE ******************************************* Bottom of Data ***************
If you specified I, the results are displayed on an interpretation panel. If you specified DETAIL=NO, that panel contains limited information, as shown in the following figure:
Figure 3. Interpretation of DDF (ADBPZDI1) panel without details ADBPZDI1 DD1A Interpretation of DDF 14:34 Command ===> Scroll ===> DATA DDF status . . . . . . . . . : DDF is started Location name of DDF . . . . : RS22DD1A DDF LU name . . . . . . . . : ROCKNET1.DD1ADB2 DDF generic LU name . . . . : -NONE TCP/IP port number for the SQL listener . . . . . . . . : 3640 TCP/IP port number for the secure SQL listener . . . . : 3642 TCP/IP port number for the two-phase commit resynchronization listener . : 3641 IPNAME value . . . . . . . . : -NONE IP address of DDF (IPv4) . . : ::192.168.55.22 IP address of DDF (IPv6) . . : 2620:117:10:4300::55:22 Type of domain name . . . . : SQL Domain name . . . . . . . . : rs22.rocketsoftware.com Value of the DDF option . . : COMMITIf you specified DETAIL=YES, the interpretation panel contains more details, as shown in the following figure:
Figure 4. Interpretation of DDF (ADBPZDI1) panel with details ADBPZDI1 DD1A Interpretation of DDF 13:51 Command ===> Scroll ===> DATA More: + DDF status . . . . . . . . . : DDF is started Location name of DDF . . . . : RS22DD1A DDF LU name . . . . . . . . : ROCKNET1.DD1ADB2 DDF generic LU name . . . . : -NONE TCP/IP port number for the SQL listener . . . . . . . . : 3640 TCP/IP port number for the secure SQL listener . . . . : 3642 TCP/IP port number for the two-phase commit resynchronization listener . : 3641 IPNAME value . . . . . . . . : -NONE IP address of DDF (IPv4) . . : ::192.168.55.22 IP address of DDF (IPv6) . . : 2620:117:10:4300::55:22 Type of domain name . . . . : SQL Domain name . . . . . . . . : rs22.rocketsoftware.com DDF threads value . . . . . . . . . . . . . . . . : INACTIVE Maximum number of inbound connections . . . . . . : 10000 Maximum number of database access threads (DBAT). : 200 Current number of DBATs . . . . . . . . . . . . . : 2 Cumulative number of work items that had to wait for a DBAT to become available . . . . . . . . . : 0 Current number of inactive DBATs . . . . . . . . : 0 Current number of requests that are queued . . . : 0 Current number of disconnected DBATs . . . . . . : 2 Current number of inactive connections . . . . . : 3 Current number of DBATs that are in use . . . . . : 0 Current number of DBATs queued because a system profile exception threshold was reached . . . . . : 0 Current number of active DBATs that are concurrently processing a new connection request . . . . . . . : 0 Number of new connection requests waiting for a DBAT to process the request . . . . . . . . . . : 0 Value of the DDF option . . : COMMIT