Warehouse Manager Installation Guide

Cataloging the DB2 nodes and databases

After you install the AIX or Solaris Operating Environment warehouse agent and configure the warehouse agent environment, you must configure the DB2 nodes and databases:

1. Log on to the DB2 instance ID.
2. Catalog the DB2 nodes and databases that you plan to access. See the Installation and Configuration Supplement for more information.

   If you have multiple DB2 instances on the same workstation, note the value of the DB2INSTANCE variable in the IWH.environment file. Any databases that are not created on this instance must be cataloged as remote.

3. For ODBC users: When you define the DB2 data source in the appropriate .odbc.ini file, ensure that the DSN is the true name of the DB2 database name or database alias name. The .odbc.ini file must reside in the home directory of the user ID that is used on the agent site.

Tip: If you are using Data Warehouse Center ODBC drivers, see the sample .odbc.ini file. On AIX, this file is located in the /usr/lpp/db2_07_01/odbc directory. On the Solaris Operating Environment, this file is located in the /opt/IBMdb2/V7.1/odbc directory. The name of the file is .ODBC.INI.