DB2 Version 9.7 for Linux, UNIX, and Windows

Updating the directories with information about remote database server computers

You can use the Add Database Wizard of the Configuration Assistant (CA) interpreter to create catalog entries. If you have the DB2® client, you can also create an application program to catalog entries.

Before you begin

To catalog a database, you must have SYSADM or SYSCTRL authority; or, you must have the catalog_noauth configuration parameter set to YES.

About this task

  1. Use the following command to update the node directory:
    • For a DB2 Universal Database™ for z/OS® and OS/390® Version 7.1 (or later), or a DB2 for z/OS Version 8 (or later), or a DB2 Universal Database for AS/400® Version 5.2 (or later) database having a TCP/IP connection:
         db2 CATALOG TCPIP NODE <nodename> 
            REMOTE <hostname> or <IP address>
            SERVER <service_name> or <port_number>
            SECURITY <security_type>
      For example:
         db2 CATALOG TCPIP NODE MVSIPNOD REMOTE MVSHOST SERVER DB2INSTC

      The default port used for TCP/IP connections on DB2 for OS/390 and z/OS is 446.

  2. If you work with DB2 Connect™, you will have to consider updating the DCS directory using the CATALOG DCS DATABASE command.

If you have remote clients, you must also update directories on each remote client.