Configuring the DB2 data warehouse

Linux If you chose to not automatically run scripts when you installed the data warehouse server, additional steps are needed to configure the data warehouse. Make sure that the shell scripts for setting up the data warehouse are run successfully. Optionally, restore the data warehouse with the sample data to the data warehouse and use it as your IBM® Rational® Insight data warehouse; the data warehouse with the sample data contains data with which you can test Rational Insight.
Before you begin
About this task
After you have installed the Data Warehouse feature, configure it.
Note: These steps are needed only if you chose to manually run scripts when you installed the data warehouse server.
  1. Create the data warehouse:
    1. Go to the /opt/ibm/RationalInsight/datawarehouse/dw directory.
    2. Switch to the root user by running the su command. If prompted, type the root password.
    3. Set the permissions for the files and folders by running the following command:
      chown db2inst1.db2iadm1 /opt/ibm/RationalInsight/datawarehouse/dw -R
      where db2inst1 is the DB2 instance owner and db2iadm1 is the DB2 group.
    4. Return to the database administrator console and run the install.sh shell script through the following command:
      [db2inst1@VEGAVM dw]$ ./install.sh
    5. When prompted, specify the parameters for the data warehouse. To see a list of parameters and their explanations, see the related links at the bottom of this page.
  2. Install the data warehouse with sample data:
    Note: This step is optional.
    1. Go to the /opt/ibm/RationalInsight/datawarehouse/sampledw directory.
    2. Switch to the root user by running the su command. If prompted, type the root password.
    3. Set the permissions for the files and folders by running the following command:
      chown db2inst1.db2iadm1 /opt/ibm/RationalInsight/datawarehouse/sampledw -R
      where db2inst1 is the DB2 instance owner and db2iadm1 is the DB2 group.
    4. Return to the database administrator console and run the install.sh shell script through the following command:
      [db2inst1@VEGAVM sampledw]$ ./install.sh
    5. When prompted, specify the parameters for the data warehouse. To see a list of parameters and their explanations, see the related links at the bottom of this page.

Feedback