The Home of C&P Software on the Web

Catalog a remote DB so you can use it as if it was local

When cataloging a TCP/IP node to communicate with a DB2 database server, you must specify a node name after CATALOG TCPIP NODE. This node name will be used in the CATALOG DB command and must be unique in the client node directory.

   catalog tcpip node mynode remote test.server.com server 50001

To specify the remote machine, you can use the host name or IP address as the value for the REMOTE parameter.

The SERVER parameter specifies either the service name or the port number used by the database server. These values are located in the /etc/services file (e.g., on AIX) at the server. This identifies which instance to use at the DB2 server instance.

Once the node has been cataloged, the remote database can be cataloged.

   catalog db sample as mysamp at node mynode   

   connect to mysamp user db2admin using db2admin

Enjoy!