Cataloging for DB2 UDB

You must catalog the DB2 UDB databases on any machines that need to connect to the DB2 UDB database server. For example, client machines, Deployment Server, or Enterprise Server (if different than database server. This procedure makes the databases known to the connecting machines.

From the machine where you want to catalog:

  1. Map a drive to the location where the DB2 database scripts reside; typically they are located in:

    \\deployment_server_name\920\database

  2. Edit the catalog_db.bat file so that the variable values, such as instance name, as applicable to your installation. The catalog_db.bat file contains comments describing how to set the variables contained therein.
  3. Start the DB2 UDB Command Window.
  4. Change directory to location where the DB2 UDB database scripts reside.
  5. Run the catalog_db.bat batch file.