- DB2 server. The DB2 server is included in the typical installation for DB2 Universal Database.
- DB2 Control Center and the Data Warehouse Center administrative interface. You can install the Data Warehouse Center administrative interface on the following operating systems: Windows NT, Windows 2000, Windows XP, Windows ME, and Windows 98, and AIX®.
- Warehouse server. The warehouse server is installed when you select Data warehousing when you install DB2 Enterprise Server Edition.
For more information about installing DB2 Universal Database and the warehouse server, see DB2 Universal Database Quick Beginnings.
- You need sample data to use with the tutorial. The tutorial uses the DB2 Data Warehousing sample data.
The Data Warehousing sample data is installed on Windows NT, Windows 2000, Windows XP, and AIX, when you install the Data Warehouse Center administrative interface. It must either be installed on the same workstation as the warehouse server, or the remote node for the sample databases must be cataloged on the warehouse server workstation. This tutorial focuses on completing warehousing tasks using the Data Warehouse Center administrative client on a Windows system.
Creating the sample databases
This tutorial contains several references to sample data in the default directory structure x:\Program Files\ibm\sqllib, where x is the drive under which you installed DB2. You could have installed DB2 in a different directory structure. For example, x:\ sqllib directory.
You must create the sample databases after you install the files for the sample.
To create the databases:
- Click Start —> Programs —> IBM DB2 —> Set-up Tools —> First Steps. The IBM DB2 First Steps window opens.
- Click Create Sample Databases. If this option is not available, the sample databases have already been created.
The First Steps – Create Sample Databases window opens.
- Select Data warehousing sample. If this option is not available, the sample databases have already been created. The Data Warehouse Center User Name and Password window opens.
- In the User name field, type the DB2 user ID that you will use to access the sample.
- In the Password field, type the password that corresponds to the user ID. Make note of the user ID and password that you use to create the samples. You will need them in a later lesson.
- Click OK. The Data Warehouse Center User Name and Password window closes.
DB2 starts to create the sample database. A progress window opens. It can take a while for the databases to be created.
- When the databases have been created, click OK.
- Click Exit First Steps to close the IBM DB2 First Steps window.
The following databases are created when you create the data warehousing sample:
Contains the operational source tables that are required for the tutorial.
Contains metadata for the Data Warehouse Center objects in the sample.
Connecting to the sample databases
Before you begin the tutorial, verify that you can connect to the sample databases:
- Click Start —> Programs —> IBM DB2 —> General Administration Tools —> Control Center to start the DB2 Control Center.
- Expand the tree until you see one of the sample databases: DWCTBC or TBC_MD.
- Right-click the name of the database and click Connect. The Connect window opens.
- In the User ID field, type the user ID that you used to create the sample.
- In the Password field, type the password that you used to create the sample.
- 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. If you receive an error message, see the DB2 Universal Database Message Reference.