Steps to Install IBM DB2
Note: Install the database according to the vendor's instructions. Be sure to note the database installation user name and password for use later in the installation process.
Configure DB2
Several database settings must be configured prior to creating the OIPA databases. To configure the database settings, use the db2 and db2set commands for DB2:
Global Settings
db2set DB2_USE_ALTERNATE_PAGE_CLEANING=YES
db2set DB2_REDUCED_OPTIMIZATION=TRUE
db2set DB2_EVALUNCOMMITTED=TRUE
db2set DB2_CORRELATED_PREDICATES=YES
db2set DB2_SKIPINSERTED=YES
db2set DB2_SKIPDELETED=YES
DBM Changes
db2 update dbm cfg using sheapthres 120000
db2 update dbm cfg using mon_heap_sz 256
db2 update dbm cfg using query_heap_sz 2048
Create the Database
A database with two schemas will need to be created; one schema for OIPA data and one for IVS data. Use the db2 create command to create the database.
db2 create database OIPA.
Create Users
Three database users must be created:
- OIPA_PAS - OIPA user with full privileges
- OIPA_RO - OIPA user with read-only privileges
- OIPA_IVS - IVS user with full privileges
Since DB2 uses the operating system for authentication, these users must first be created at the operating system level. Please consult the operating system documentation for creating users.
Configure the Databases
The database settings for the database must be configured.
db2 connect to OIPA
db2 update db cfg using dbheap 2400
db2 update db cfg using logbufsz 512
db2 update db cfg using locklist 10000
db2 update db cfg using app_ctl_heap_sz 256
db2 update db cfg using sortheap 1024
db2 update db cfg using applheapsz 4096
db2 update db cfg using locktimeout 360
db2 update db cfg using maxlocks 76
db2 update db cfg using chngpgs_thresh 30
db2 update db cfg using num_iocleaners 7
db2 update db cfg using num_ioservers 7
db2 update db cfg using logfilsiz 20000
db2 update db cfg using logprimary 30
db2 update db cfg using logsecond 0
db2 update db cfg using pckcachesz 1024
db2 update db cfg using catalogcache_sz 512
db2 update db cfg using maxfilop 256
db2 update db cfg using maxappls 60
db2 update db cfg using avg_appls 1
db2 update db cfg using PCKCACHESZ 2048
db2 update db cfg using SORTHEAP 512
db2 update db cfg using dft_queryopt 3
Prepare the DDL Script
The db2look_oipa_pas.ddl and the db2look_oipa_ivs.ddl files must be edited to include the fully-qualified path names for each table space creation command.
Create the Schema Using the DDL Script
The db2look_oipa_pas.dll file and the db2look_oipa_ivs.ddl file, which were modified in the previous step, will now be used to create the database schemas.
db2 -tvf <ddl_file> > <create_schema_log>
##Example: db2 –tvf db2look_oipa_pas.ddl >db2look_oipa_pas.log
db2 –tvf db2look_oipa_ivs.ddl >db2look_oipa_ivs.log
After execution has completed, reference the created log files, db2look_oipa_pas.log and db2look_oipa_ivs.log, to ensure the schemas were successfully created.
Load the Database Data
The db2move command will be used to load the data into the database.
To load the OIPA database, first ensure that you are currently in the directory that contains the OIPA database data from the Oracle Insurance Policy Administration Media Pack.
db2move <dbname> load -lo replace <lobpath file>
##Example: db2move OIPA load -lo replace > OIPA.log
To load the IVS database, first ensure that you are currently in the directory that contains the IVS database data from the Oracle Insurance Policy Administration Media Pack.
db2move <dbname> load -lo replace <lobpath file>
##Example: db2move IVS load -lo replace > IVS.log
Import Client Data
After the database load is complete, run the following command to insert the required AsClient records.
db2 load from tab<number>.ixf of ixf
Where ixf modified by generatedignore is replaced into "<schema>". ASCLIENTwhere tab<number>.ixf is corresponding ixf file for ASCLIENT, which is listed right alongside ASCLIENT in db2move.lst file
Performance Recommendations
Cycle Recommendations:
For optimum Client level cycle(07) activity processing following indexes needs to be applied:
Sno | Column Name | Table Name |
---|---|---|
1 | ACTIVITYGUID | ASACTIVITYSEQUENCEDETAIL |
2 | CLIENTRELATIONSHIPPARENTGUID | ASCLIENTRELATIONSHIP |
3 | CLIENTGUID | ASCYCLE |