Cataloging the Remote TCP/IP Node from the DB2 Client

Catalog the remote DB2 client node.

1. Log in as the DB2 instance owner.

   Logging in sets up your DB2 environment variables by executing the environment scripts. You can also execute these scripts manually as follows.

   In Korn shell, source the db2profile file:

   . $HOME/sqllib/db2profile

   In C shell, source the db2cshrc file:

   source $HOME/sqllib/db2cshrc

   where $HOME is the home directory of the DB2 instance owner.

2. Start the DB2 command-line processor by typing the db2 command.
3. Catalog the remote TCP/IP node using this command at the DB2 prompt:

   catalog tcpip node MYNODE remote MYHOST server XXXX

   where MYNODE is the node name, MYHOST is the host name or IP address of the data server, and XXXX is the data server port number.

4. Verify the catalog entry:

   list node directory

   DB2 should return something similar to:

   Node 1 entry:
         Node name            = MYNODE
         Comment              = 
         Directory entry type = LOCAL
         Protocol             = TCPIP
         Hostname             = MYHOST
         Service name         = XXXX