Business Intelligence Tutorial

Before you begin

Before you begin, you must install the products that are covered in the sections of the tutorial that you want to use:

You must also install the tutorial. In DB2 for Windows, you can install the tutorial as part of a typical install. In DB2 for AIX or the Solaris Operating Environment, you can install the tutorial with the documentation.

You need sample data to use with the tutorial. The tutorial uses the DB2 Data Warehousing sample data and the OLAP sample data.

The Data Warehousing sample data is installed on Windows NT only, when you install the tutorial. It must either be installed on the same workstation as the warehouse manager, or the remote node for the sample databases must be cataloged on the manager workstation.

You can install the OLAP sample data on Windows NT, AIX, and the Solaris Operating Environment. It must either be installed on the same workstation as the OLAP Integration Server server, or the remote node for the sample databases must be cataloged on the server workstation.

This tutorial contains several references to sample data under the X:\ sqllib directory, where X is the drive under which you installed DB2. If you used the default directory structure, the data is installed under X:\Program Files\sqllib instead of X:\sqllib.

You must create the sample databases after you install the files for the sample. To create the databases:

  1. Click Start --> Programs -->IBM DB2--> First Steps.

    The First Steps window opens.

  2. Click Create Sample Databases. If Create Sample Databases is greyed out, the sample databases have already been created.

    The Create SAMPLE Databases window opens.

  3. Select the Data Warehousing sample check box, OLAP sample check box, or both, depending on which parts of the tutorial you want to do.
  4. Click OK.
  5. If you are installing the Data Warehousing sample, a window opens for the DB2 user ID and password to use to access the sample.
    1. Type the user ID and password that you want to use. Note down the user ID and password, because you will need them in a later lesson, when you define security.
    2. Click OK.

    DB2 starts to create the sample databases. A progress window opens. It may take a while for the databases to be created. When the database has been created, click OK.

If you are installing the sample on Windows NT, the databases are automatically registered with ODBC. If you are installing the sample on AIX or the Solaris Operating System, you must manually register the databases with ODBC. For more information about registering the databases on AIX or the Solaris Operating System, see DB2 Universal Database Quick Beginnings for your operating system.

If you selected Data Warehousing Sample, the following databases are created:

DWCTBC
Contains the operational source tables that are required for the Data Warehousing section of the tutorial.

TBC_MD
Contains metadata for the Data Warehouse Center objects in the sample.

If you selected the OLAP sample, the following databases are created:

TBC
Contains the cleansed and transformed tables that are required for the Multidimensional data analysis section of the tutorial.

TBC_MD
Contains metadata for the OLAP objects in the sample.

If you select both the Data Warehousing and OLAP samples, the TBC_MD database contains metadata for both the Data Warehouse Center and OLAP objects in the sample.

Before you begin the tutorial, verify that you can connect to the sample databases:

  1. Start the DB2 Control Center:
  2. Expand the tree until you see one of the sample databases: DWCTBC, TBC, or TBC_MD.
  3. Right-click the name of the database and click Connect.

    The Connect window opens.

  4. In the User ID field, type the user ID that you used to create the sample.
  5. In the Password field, type the password that you used to create the sample.
  6. Click OK.

    The DB2 Control Center connects to the database. If the DB2 Control Center is not able to establish a connection, you will see an error message.


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