DSNL084I TCPPORT=tcp-port SECPORT=secure-port RESPORT=resync-port IPNAME=ip-name

Explanation

This message is a section of output from the DISPLAY DDF command, which is part of message DSNL080I.

DSNL084I: TCP/IP port information

The location information is followed by information about the TCP/IP port that is associated with DDF:

DSNL084I TCPPORT=tcp-port SECPORT=secure-port RESPORT=resync-port IPNAME=ip-name
tcp-port
The TCP/IP port number for the SQL listener, as recorded in the BSDS. This port number can be specified by one of the following methods:
  • The DRDA PORT field on the DSNTIP5 installation panel
  • The PORT option in the DDF statement of the DSNJU003 (change log inventory) utility

A value of 0 (zero) indicates that an SQL listener port was not specified, and DDF is not configured to use TCP/IP network protocols.

A value of -NONE indicates that Db2 does not accept connections on this port. One possible reason that Db2 does not accept connections is that the MAXDBAT subsystem parameter is set to 0 (zero). The current MAXDBAT value is listed in the DSNL090I message, which is included as part of the DISPLAY DDF output when the DETAIL option is specified.

secure-port
The TCP/IP port number for the secure SQL listener, as recorded in the BSDS. This port number can be specified by one of the following methods:
  • The SECURE PORT field on the DSNTIP5 installation panel
  • The SECPORT option in the DDF statement of the DSNJU003 (change log inventory) utility

A value of 0 (zero) indicates both of the following conditions:

  • A secure SQL listener port was not specified.
  • DDF is not configured to accept secure inbound connections by using the Secure Socket Layer (SSL) protocol through this port number.

If a secure port is not specified, remote connections can still use the TCP/IP port for the SQL listener (tcp-port) and use the SSL protocol on that port. However, DDF does not validate whether the connection uses SSL protocol.

A value of -NONE indicates that Db2 does not accept connections on this port. One possible reason that Db2 does not accept connections is that the MAXDBAT subsystem parameter is set to 0 (zero). The current MAXDBAT value is listed in the DSNL090I message, which is included as part of the DISPLAY DDF output when the DETAIL option is specified.

resync-port
The TCP/IP port number for the two-phase commit resynchronization (resync) listener, as recorded in the BSDS. This port number can be specified by one of the following methods:
  • The RESYNC PORT field on the DSNTIP5 installation panel
  • The RESPORT option in the DDF statement of the DSNJU003 (change log inventory) utility

A value of 0 (zero) indicates that a resynchronization listener port was not specified, and DDF is not configured to use TCP/IP network protocols.

ip-name
The IPNAME value, as recorded in the BSDS. For a description of the IPNAME value, see the DSNJU003 syntax information.

This value is unique to this DDF.

If this Db2 subsystem is a member of a data sharing group, the IPNAME value is unique to that data sharing group. If all the members of a data sharing group activate only their TCP/IP communications support, all members of that group must be defined with the same IPNAME value.

This TCP/IP port information for DDF is also included in message DSNL004I, which is displayed when DDF is started.

Related information