Installation Guide

Back Next

IBM DB2 database requirements

You can create a domain configuration repository on an IBM DB2 database. Configure the database settings based on requirements specific to the domain configuration repository.

Use the following guidelines when you set up the repository on IBM DB2:

On the IBM DB2 instance where you create the database, set the following parameters to ON:

DB2_SKIPINSERTED

DB2_EVALUNCOMMITTED

DB2_SKIPDELETED

AUTO_RUNSTATS

On the database, set the following configuration parameters:

Parameter	Value
applheapsz	8192
appl_ctl_heap_sz	8192
logfilsiz	8000
DynamicSections	3000
maxlocks	98
locklist	50000
auto_stmt_stats	ON

Use a single-node DB2 database tablespace.

Set the tablespace pageSize parameter to 32768 bytes.

In a single-partition database, specify a tablespace that meets the pageSize requirements. If you do not specify a tablespace, the default tablespace must meet the pageSize requirements.

In a multi-partition database, you must specify a tablespace that meets the pageSize requirements. Define the tablespace on a single node.

Verify the database user has CREATETAB, CONNECT, and BINDADD privileges.

The default value for DynamicSections in DB2 is too low for the Informatica repositories. Informatica requires a larger DB2 package than the default. When you set up the DB2 database for the domain configuration repository or a Model repository, you must set the DynamicSections parameter to at least 3000. If the DynamicSections parameter is set to a lower number, you can encounter problems when you install or run Informatica. The following error message can appear:

[informatica][DB2 JDBC Driver]No more available statements. Please recreate your package with a larger dynamicSections value.

Rename Saved Search

Table of Contents

Installation Guide

Installation Guide

IBM DB2 database requirements

IBM DB2 database requirements