You can set up an IBM® DB2® database to work with Rational Focal Point.
Before you begin
Install a DB2 database.
For instructions, see the IBM DB2 documentation.
Procedure
- Create a file named create_focalpoint_db2.sql that
contains the following SQL code. Modify the sample code parameters
to match your environment.
CREATE DATABASE FOCALDB AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY US;
CONNECT TO FOCALDB;
CREATE BUFFERPOOL FPDATABUFF SIZE 2000 PAGESIZE 32K;
CREATE BUFFERPOOL FPINDEXBUFF SIZE 1000 PAGESIZE 32K;
CREATE BUFFERPOOL FPBIGOBJBUFF SIZE 500 PAGESIZE 32K;
CREATE TABLESPACE FP_DATA
PAGESIZE 32K
MANAGED BY DATABASE
USING (FILE 'D:\DB2\fp_data_cont11' 150M, FILE 'D:\DB2\fp_data_cont12' 150M)
PREFETCHSIZE 500
BUFFERPOOL FPDATABUFF
OVERHEAD 24.1
TRANSFERRATE 0.9
AUTORESIZE YES ;
CREATE TABLESPACE FP_INDEX
PAGESIZE 32K
MANAGED BY DATABASE
USING (FILE 'D:\DB2\fp_index_cont11' 100M, FILE 'D:\DB2\fp_index_cont12' 100M)
PREFETCHSIZE 300
BUFFERPOOL FPINDEXBUFF
OVERHEAD 24.1
TRANSFERRATE 0.9
AUTORESIZE YES ;
CREATE TEMPORARY TABLESPACE FP_BIGOBJ
PAGESIZE 32K
MANAGED BY DATABASE
USING (FILE 'D:\DB2\fp_temp_cont11' 100M)
PREFETCHSIZE 50
BUFFERPOOL FPBIGOBJBUFF
OVERHEAD 24.1
TRANSFERRATE 0.9
AUTORESIZE YES ;
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.
- Log in to DB2 as
the DB2 administrator.
- In the command editor, enter create_focalpoint_db2.sql.