Configuring a DB2 database

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.
Note: Rational Focal Point uses the default schema, which has the same name as the database user specified. The schema name is not configurable, other than using another database user.

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.

  1. 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.
    • Make sure that you have space larger than 1 GB. For large installations, you must allocate more space.
    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 'C:\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 'C:\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;
    
    UPDATE DB CONFIG USING AUTO_STATS_PROF ON AUTO_PROF_UPD ON AUTO_REORG ON
  2. Log on to DB2 as the DB2 administrator.
  3. In the command editor, enter create_focalpoint_db2.sql.

Feedback