To set up the standard sample application manually, you begin by creating two databases in a supported RDBMS: TBC (the sample database) and TBC_MD (an OLAP Metadata Catalog). You then create tables in each of these databases and load data into them, using scripts provided with DB2 OLAP Integration Server. The names and directory locations of these scripts are detailed in the topics that follow.
After you create the TBC and TBC_MD databases in a supported RDBMS, you use several scripts and files to create the standard sample application:
This script is located in the samples\tbcdbase directory.
This script is located in the samples\tbcdbase directory.
This script is located in the ocscript directory.
These XML files are located in the samples\tbcmodel directory.
The scripts for creating the standard sample application and OLAP Metadata Catalog are installed with the server software. Different versions of the scripts are provided for each of the supported RDBMSs.