DB2 Connect User's Guide

Updating the Directories

You can use the CATALOG command on any DB2 Connect system or the Add Database Wizard of the CCA on OS/2 and Windows 32-bit operating systems. If you have the DB2 Application Development Client, you can also create an application program to catalog entries. For information about APIs, refer to the Administrative API Reference and the Command Reference.

Note:

To catalog a database, you must have sysadm or sysctrl authority.

To update the directories using the command line processor, do the following:

1. Use one of the following commands to update the node directory:
   • For a node having an APPC connection:

        db2 CATALOG APPC NODE nodename 
          REMOTE symbolic_destination_name SECURITY security_type
     

     For example:

        db2 CATALOG APPC NODE DB2NODE REMOTE DB2CPIC SECURITY PROGRAM
     

   • For a DB2 Universal Database for OS/390 Version 5.1 or a DB2 Universal Database for AS/400 Version 4.2 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 DRDA port number for TCP/IP connections is 446.

2. Use the following command to update the DCS directory:

      db2 CATALOG DCS DATABASE database_name AS target_database_name
      [AR application_requester]
      [PARMS "parameter string"]
   

   For example:

      db2 CATALOG DCS DATABASE DB2DB AS NEW_YORK3
   

   Or, for OS/2, Windows NT, or Windows 2000:

      db2 CATALOG DCS DATABASE DB2DB AS NEW_YORK3 PARMS "NOMAP,D"
   

   Or, for AIX:

      db2 CATALOG DCS DATABASE DB2DB AS NEW_YORK3 PARMS '"NOMAP,D"'
   

   Note:

   See Specifying the Parameter String for information about using the operating system escape character when specifying the LOCALDATE mask in the parameter string.

3. Use the following command to update the system database directory:

      db2 CATALOG DATABASE database_name
         AS alias AT NODE nodename 
         AUTHENTICATION authentication_type
   

   For example:

      db2 CATALOG DATABASE DB2DB AS NYC3 AT NODE DB2NODE AUTHENTICATION DCS
   

If you have remote clients, you must also update directories on each remote client. For more information, refer to the appropriate DB2 Connect Quick Beginnings book.