Release Notes

30.8 Manually Creating and Configuring the Sample Databases for OLAP Starter Kit

The sample databases are created automatically when you install OLAP Starter Kit. The following instructions explain how to setup the Catalog and Sample databases manually, if necessary.

1. In Windows, open the Command Center window by clicking Start -->Programs-->DB2 for Windows NT--> Command Window.
2. Create the production catalog database:
   1. Type db2 create db OLAP_CAT
   2. Type db2 connect to OLAP_CAT
3. Create tables in the database:
   1. Navigate to \SQLLIB\IS\ocscript\ocdb2.sql
   2. Type db2 -tf ocdb2.sql
4. Create the sample source database:
   1. Type db2 connect reset
   2. Type db2 create db TBC
   3. Type db2 connect to TBC
5. Create tables in the database:
   1. Navigate to \SQLLIB\IS\samples\
   2. Copy tbcdb2.sql to \SQLLIB\samples\db2sampl\tbc
   3. Copy lddb2.sql to \SQLLIB\samples\db2sampl\tbc
   4. Navigate to \SQLLIB\samples\db2sampl\tbc
   5. Type db2 -tf tbcdb2.sql
   6. Type db2 - vf lddb2.sql to load sample source data into the tables.
6. Create the sample catalog database:
   1. Type db2 connect reset
   2. Type db2 create db TBC_MD
   3. Type db2 connect to TBC_MD
7. Create tables in the database:
   1. Navigate to \SQLLIB\IS\samples\tbc_md
   2. Copy ocdb2.sql to \SQLLIB\samples\db2sampl\tbcmd
   3. Copy lcdb2.sql to \SQLLIB\samples\db2sampl\tbcmd
   4. Navigate to \SQLLIB\samples\db2sampl\tbcmd
   5. Type db2 -tf ocdb2.sql
   6. Type db2 -vf lcdb2.sql to load sample metadata into the tables.
8. Configure ODBC for TBC_MD, TBC, AND OLAP_CAT:
   1. Open the NT control panel by clicking Start-->Settings-->Control Panel
   2. Select ODBC (or ODBC data sources) from the list.
   3. Select the System DSM tab.
   4. Click Add. The Create New Data Source window opens.
   5. Select IBM DB2 ODBC DRIVER from the list.
   6. Click Finish. The ODBC IBM D2 Driver - Add window opens.
   7. Type the name of the data source (OLAP_CAT) in the Data source name field.
   8. Type the alias name in the Database alias field, or click the down arrow and select OLAP_CAT from the list.
   9. Click OK.
   10. Repeat these steps for the TBC_MD and the TBC databases.