Business Intelligence Tutorial

Starting the Data Warehouse Center

In this exercise, you will start the Data Warehouse Center from the DB2 Control Center and log on as the default warehouse user. When you log on, you will use the TBC_MD warehouse control database. The default warehouse user for TBC_MD is the user ID that you specified when you created the Data Warehousing sample databases.

TBC_MD must be a local or a cataloged remote database on the workstation that contains the warehouse server. It must also be a local or cataloged remote database on the workstation that contains the Data Warehouse Center administrative client.

To start the Data Warehouse Center:

  1. From the DB2 Control Center window, click Tools --> Data Warehouse Center in the DB2 Control Center window. The Data Warehouse Center Logon window opens.
  2. Click Advanced.

    The Advanced window opens.

  3. In the Control database field, type TBC_MD, the name of the warehouse control database that is included in the sample.
  4. In the Server host name field, type the TCP/IP host name for the workstation where the warehouse manager is installed.


    Figure db2tu035 not displayed.

  5. Click OK.

    The Advanced Logon window closes.

    The next time that you log on, the Data Warehouse Center will use the settings that you specified in the Advanced Logon window.

  6. In the User ID field of the Logon window, type the default warehouse user ID.
  7. In the Password field, type the password for the user ID.


    The Logon window

  8. Click OK.

    The Data Warehouse Center Logon window closes.

  9. Close the Data Warehouse Center Launchpad window.


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