Running the Batch File on IBM DB2

The first task in setting up the Hybrid Analysis sample application on IBM DB2 consists of running the install_db2.bat file. This batch file creates tables in the sample database, loads metadata into the dimension tables, and loads sample data into the fact table.

Run the install_db2.bat file located in:

EPM_ORACLE_HOME\products\Essbase\eis\server\Samples\tbcdbase

This batch file sends SQL commands to the DB2CMD command line interface.

Pass the following three parameters to install_db2.bat:

The user ID that you use to connect with IBM DB2
Your password
The IBM DB2 database name

The install_db2.bat file runs the DB2CMD command line interface, which executes the ha_create_db2.sql load script file. This script file performs the following tasks:

Deletes any existing tables in the sample TBC database
Creates a new set of tables in the TBC database
Inserts records into the dimension tables
Creates the ha_results_createtables.txt file
Loads the sample data into the fact table

The ha_results_createtables.txt file contains the results of the table-creating and loading operations.

Note:

After the member and data load is finished, close the IBM DB2 command window.