Command Reference

CATALOG APPCLU NODE

Writes information to the node directory about a remote workstation that uses APPC 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 only.

Authorization

One of the following:

sysadm

sysctrl

Required Connection

None

Command Syntax

>>-CATALOG APPCLU NODE--nodename---+------------------+-REMOTE--> +-LOCAL--local-lu--+ >-partner-lu---+-------------+--+-------------------------+---->< +-MODE--mode--+ +-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 cataloging a database residing on that workstation. The name must conform to DB2 naming conventions (see Appendix B. "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).

REMOTE partner-lu

Specifies the alias of the SNA remote 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).

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.

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.

Example

The following example shows how to catalog REMNODE, a remote workstation that contains a database:

   db2 catalog appclu node remnode local LU1 remote LU2
      mode SQLMOD01 with "Remote node comment"

Usage Notes

This command is identical to the Version 1 CATALOG APPC NODE command, but is different from the Version 2 CATALOG APPC NODE command.

Note:

Version 1 script files containing the CATALOG APPC NODE command must be modified. Change the keyword APPC to APPCLU to make this command perform as it did in Version 1.

ATTACH cannot be used with an APPCLU node to attach to a server that has TPNAME other than x'07F6C4C2'.

APPCLU nodes only support security PROGRAM (security SAME and NONE are not supported).

[ DB2 List of Books | Search the DB2 Books ]