Cataloging the DB2 Database

If your database server and applications are on different systems, use this procedure to catalog your DB2 database.

  1. Ensure that you know the name of the database you plan to catalog, and the node name and port number of the database server.
  2. Using the db2 utility or Command Line Processor, catalog the node by issuing the following command:

    db2 CATALOG TCPIP NODE NodeName REMOTE DatabaseServerName SERVER {Port# | /etc/services Name} REMOTE_INSTANCE Instance_Name

  3. Catalog the database by issuing the following command:

    db2 CATALOG DATABASE DatabaseName AS ALIAS AT NODE NodeName

  4. Update the /etc/services file.
  5. At the command prompt, type:

    db2 list database directory

    If cataloging is successful, an entry for your database appears in the contents of the database directory.