Command Reference

CATALOG APPN NODE

Writes information to the node directory about a remote workstation that uses APPN as its communication protocol. DB2 uses this information to establish the connection between an application and a remote database cataloged on this node.

This command is available on OS/2, Windows NT, Windows 98, Windows 95, AIX, and Solaris only.

Authorization

sysadm

Required Connection

None

Command Syntax

>>-CATALOG APPN NODE--nodename----+-----------------+----------->
                                  '-NETWORK--netid--'
 
>----REMOTE--partner-lu----+------------------+----------------->
                           '-LOCAL--local-lu--'
 
>-----+------------------+---+-------------+-------------------->
      '-TPNAME--tp-name--'   '-MODE--mode--'
 
>-----+-------------------------+------------------------------->
      |           .-PROGRAM--.  |
      '-SECURITY--+-NONE-----+--'
                  '-SAME-----'
 
>-----+----------------------------------+---------------------->
      '-LANADDRESS--lan-adapter-address--'
 
>-----+-------------------------------+------------------------->
      '-CHGPWDLU--change_password_lu--'
 
>-----+-------------------------+------------------------------><
      '-WITH--"comment-string"--'
 

Command Parameters

NODE nodename

Specifies the name of the remote workstation to catalog. This is the same name that is entered for the node name parameter when a database residing on that workstation is cataloged (using CATALOG DATABASE). The name must conform to DB2 naming conventions (see Appendix B, Naming Conventions).

NETWORK netid

Specifies the ID of the SNA network where the remote LU resides. This network ID is a string of one to eight characters that follows naming conventions for SNA.

REMOTE partner-lu

Specifies the SNA partner logical unit used for the connection. Enter the LU name of the remote node. The name must be entered exactly as it appears (using mixed case characters) in the corresponding SNA definition (from the Communication Manager configuration). The name must follow SNA naming conventions.

LOCAL local-lu

Specifies the alias of the SNA local logical unit used for the connection. It must be a string containing 1 to 8 non-blank characters. The alias must be entered exactly as it appears (using mixed case characters) in the corresponding SNA definition (from the Communication Manager configuration).

TPNAME tp-name

Specifies the APPC transaction program name of the database server. The default is DB2DRDA.

MODE mode

Specifies the SNA transmission mode used for the connection. The name must conform to SNA naming conventions.

If a value is not entered, DB2 stores a character string of eight blanks as the mode type.

SECURITY

Specifies the extent to which security information is to be used in the allocation request sent to the partner LU. Valid values are:

PROGRAM

Specifies that both a user name and a password are to be included in the allocation request sent to the partner LU. This is the default.

NONE

Specifies that no security information is to be included in the allocation request sent to the partner LU.

SAME

Specifies that a user name is to be included in the allocation request sent to the partner LU, together with an indicator that the user name has been "already verified". The partner must be configured to accept "already verified" security.

Note:

For connections using APPN to a DB2 for Windows NT Version 7.1 (or later) server, a user ID longer than 8 bytes is only supported when SECURITY is specified as NONE.

LANADDRESS lan-adapter-address

LAN Adapter Address of the DB2 server.

CHGPWDLU change_password_lu

Specifies the name of the partner LU that is to be used when changing the password for a host database server.

WITH "comment-string"

Describes the node entry in the node directory. Any comment that helps to describe the node can be entered. Maximum length is 30 characters. A carriage return or a line feed character is not permitted. The comment text must be enclosed by single or double quotation marks.

Examples

The following example catalogs an APPN node:

   db2 catalog appn node remnode remote rlu with "Catalog APPN NODE"