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.

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.

Procedure

Create the data warehouse:
  1. Go to the /opt/IBM/RCPR/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/RCPR/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.
    Note: Rational Common Reporting users must enter the default parameters when manually running the scripts.

Feedback