
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
- Ensure that you are the instance owner or a user that is part
of SYSADM_GROUP specified at the DB2® instance
level and the DB2 client is
installed for the account.
- Ensure that you have at least 3 GB of disk space in the / partition.
About this task
After you have installed the Data Warehouse feature, configure
it.
- If the option for automatic execution of scripts was not chosen
when the data warehouse component was installed, the installer only
creates batch files to set up the Rational Insight data warehouse,
but does not run them. Run the batch file manually.
- The data warehouse with sample data is a backed up database file
that the installer places on the system. Restore this sample database
to the data warehouse.
Note: These steps are needed only if you chose to manually run
scripts when you installed the data warehouse server.
- Create the data warehouse:
- Go to the /opt/ibm/RationalInsight/datawarehouse/dw directory.
- Switch to the root user by running the su command.
If prompted, type the root password.
- 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.
- Return to the database administrator console and run
the install.sh shell script through the following
command:
[db2inst1@VEGAVM dw]$ ./install.sh
- 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.
- Install the data warehouse with sample data:
Note: This
step is optional.
- Go to the /opt/ibm/RationalInsight/datawarehouse/sampledw directory.
- Switch to the root user by running the su command.
If prompted, type the root password.
- 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.
- Return to the database administrator console and run
the install.sh shell script through the following
command:
[db2inst1@VEGAVM sampledw]$ ./install.sh
- 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.