Business Intelligence Tutorial

Reinitializing the warehouse control database

When you install the Data Warehouse Center as part of the default DB2 installation, the installation process registers the default warehouse control database as the active warehouse control database. However, you must use the TBC_MD database in the sample as the warehouse control database so that you can use the sample metadata. To make TBC_MD the active database, you must reinitialize it.

To reinitialize TBC_MD:

  1. Click Start --> Programs --> IBM DB2 --> Warehouse Control Database Management.

    The Data Warehouse Center - Control Database Management window opens.

  2. In the New control database field, type the name of the new control database that you want to use.
    TBC_MD
    
  3. In the Schema field, use the default schema of IWH.
  4. In the User ID field, type the name of the user ID that is required to access the database.
  5. In the Password field, type the name of the password for the user ID.
  6. In the Verify Password field, type the password again.
  7. Click OK.

    The window remains open. The Messages field displays messages that indicate the status of the creation and migration process.

  8. After the process is complete, close the window. TBC_MD is now the active warehouse control database.


[ Top of Page | Previous Page | Next Page | Table of Contents ]