Configuring a DB2 database

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

  1. 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.
  2. Log in to DB2 as the DB2 administrator.
  3. In the command editor, enter create_focalpoint_db2.sql.

Feedback