Cataloging the Primary Database from the DB2 Client

Catalog the primary database.

  1. Catalog the primary database using this command at the DB2 prompt:
    catalog database MYDB as MYDB_ALIAS at node MYNODE

    where MYDB is the database name, MYDB_ALIAS is an alias for the database, and MYNODE is the node name used in the catalog tcpip node command.

  2. Verify the catalog entry:
    list database directory

    DB2 should return something similar to:

    System Database Directory
    
    Number of entries in the directory = 1
    
    Database 1 entry:
    
    Database alias         = MYDB_ALIAS
    Database name          = MYDB
    Node name              = MYNODE
    Database release level = b.00
    Comment                = 
    Directory entry type   = Remote