You can set up an IBM® DB2® database to work with Rational® Focal Point™.
Before you begin
A DB2 database version
that is supported by
Rational Focal Point must
be installed. For instructions, see your DB2 documentation.
Procedure
Before you install Rational Focal Point,
make sure that the following database configurations are done. For
instructions to configure the database, see the DB2 database documentation.
Note: The default
schema is picked up from the user name in the datasource connection.
You cannot create another schema without changing the login credentials.
- Create a file named create_focalpoint_db2.sql that
contains the following SQL code. Modify the sample code parameters
to match your environment.
Attention: Do not
modify the table space names.
- For each table space, change the path to an appropriate local
directory. Make sure that the local directory has read and write permissions.
- Based on the server configuration, specify the size for each table
space.
- Modify the territory name, if required.
CREATE DATABASE FOCALDB AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY US;
CONNECT TO FOCALDB;
CREATE BUFFERPOOL FPDATABUFF SIZE 2000 AUTOMATIC PAGESIZE 32K;
CREATE BUFFERPOOL FPINDEXBUFF SIZE 1000 AUTOMATIC PAGESIZE 32K;
CREATE BUFFERPOOL FPBIGOBJBUFF SIZE 500 AUTOMATIC PAGESIZE 32K;
CREATE LARGE TABLESPACE FP_DATA
PAGESIZE 32K
MANAGED BY DATABASE
--Use one Container per disk per tablespace
USING (FILE 'C:\DB2\fp_data_cont11' 150M, FILE 'D:\DB2\fp_data_cont12' 150M)
PREFETCHSIZE AUTOMATIC
BUFFERPOOL FPDATABUFF
AUTORESIZE YES ;
CREATE LARGE TABLESPACE FP_INDEX
PAGESIZE 32K
MANAGED BY DATABASE
--Use one Container per disk per tablespace
USING (FILE 'C:\DB2\fp_index_cont11' 100M, FILE 'D:\DB2\fp_index_cont12' 100M)
PREFETCHSIZE AUTOMATIC
BUFFERPOOL FPINDEXBUFF
AUTORESIZE YES ;
CREATE TEMPORARY TABLESPACE FP_BIGOBJ
PAGESIZE 32K
MANAGED BY DATABASE
--Use one Container per disk per tablespace
USING (FILE 'C:\DB2\fp_temp_cont11' 100M)
PREFETCHSIZE AUTOMATIC
BUFFERPOOL FPBIGOBJBUFF
AUTORESIZE YES ;
UPDATE db cfg for FOCALDB using logprimary 25;
UPDATE db cfg for FOCALDB using logsecond 25;
UPDATE db cfg for FOCALDB using logfilsiz 2500;
- Log on to DB2 as
the DB2 administrator.
- In the command editor, enter create_focalpoint_db2.sql.