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