DSNL088I alias port secure-port status

If aliases were defined for the DDF location by using the MODIFY DDF command or by using the DSNJU003 (change log inventory) utility, the output includes alias information:

DSNL087I ALIAS           PORT     SECPORT     STATUS
DSNL088I alias           port     secure-port status

alias

An alias name.

You can manage static aliases by using the DSNJU003 (change log inventory) utility. You can manage dynamic aliases by using the MODIFY DDF command and specifying the ALIAS option.

port

The TCP/IP port that is associated with the alias. A 0 (zero) value indicates that a port was not specified for the alias. However, the alias can still be accessed by using other active DRDA SQL ports.

This value is ignored for statically defined location aliases in non-data-sharing environments.

secure-port

The TCP/IP secure port that is associated with the alias. A 0 (zero) value indicates that a secure port was not specified for the alias. However, the alias can still be accessed by using other active DRDA secure SQL ports.

This value is ignored for statically defined location aliases in non-data-sharing environments.

status

The operational status of the alias, which can be one the following values:

STARTG

The alias is starting. The MODIFY DDF command was issued with the ALIAS keyword to start the alias, and the start operation is in progress.

STARTD

The alias is started or ready to start with the alias port. Db2 might be processing existing connections to the alias and is accepting new connection requests to the alias by using the alias port. Otherwise, Db2 starts accepting new connection requests to the alias by using the alias port when the following conditions become true:

• DDF is started.
• The MAXDBAT subsystem parameter is set to a value greater than 0.

STOPG

The alias is stopping. The MODIFY DDF command with the ALIAS keyword was issued to stop an alias, and the stop operation is in progress.

STOPD

The alias is stopped. Db2 does not accept new connection requests to the alias by using the alias port. However, Db2 can still accept requests to the alias by using the group SQL port if DDF is active and listening on it. This value applies to only those aliases that are defined and managed dynamically by the MODIFY DDF command with the ALIAS keyword.

CANCLG

The alias is canceling. The MODIFY DDF command with the ALIAS keyword was issued to cancel an alias, and the cancel operation is in progress.

CANCLD

The alias is canceled. Db2 canceled all existing database access threads (DBATs) that were processing connections to the alias. Db2 does not accept new connection requests to the alias by using the alias port. However, Db2 can still accept requests to the alias by using the group SQL port if DDF is active and listening on it. This value applies to only those aliases that are defined and managed dynamically by the MODIFY DDF command with the ALIAS keyword.

STATIC

The alias is static. Db2 accepts new connection requests when Db2 is available to accept TCP/IP connection requests. This option applies to only those aliases that were created by the DSNJU003 utility. Such aliases cannot be defined or managed dynamically by the MODIFY DDF command.

Related information

• -MODIFY DDF command (Db2)
• DSNJU003 (change log inventory)
• MAX REMOTE ACTIVE field (MAXDBAT subsystem parameter)