Before you begin, you must install the products that are covered in the sections of the tutorial that you want to use:
If you install the DB2 server on a different workstation from the warehouse server or the Data Warehouse Center administrative interface, you must install the DB2 client on the same workstation as the Data Warehouse Center administrative interface.
For more information about installing DB2 Universal Database and the warehouse server, see DB2 Universal Database Quick Beginnings for your operating system.
Optionally, you can install the Information Catalog Manager if you have the DB2 Warehouse Manager. If you do not have the DB2 Warehouse Manager, skip Lesson 14, Cataloging data in the warehouse for end users and Lesson 15, Working with business metadata.
For more information about installing the DB2 Warehouse Manager, see DB2 Warehouse Manager Installation Guide.
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:
The First Steps window opens.
The Create SAMPLE Databases window opens.
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:
If you selected the OLAP sample, the following databases are created:
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:
db2jstrt 6790 db2cc 6790b
The Connect window opens.
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.