1. Installation Guide
  2. Guidelines for Setting IBM DB2 Database Configuration Parameters

Guidelines for Setting IBM DB2 Database Configuration Parameters

This topic is part of Configuring an IBM DB2 Database for Siebel CRM.

You can set the IBM DB2 database configuration parameters by using the update database manager configuration command of the DB2 command line processor or DB2 command prompt (Windows). For more information about modifying these configuration parameters, see IBM DB2 technical documentation.

IBM DB2 Database Configuration Parameters

The following table describes IBM DB2 database configuration parameters that differ from the default settings. Set these parameters for each DB2 instance. Use the configuration information in the following table for the listed parameters. For parameters not listed in this table, accept the default settings.

Parameter Explanation Setting or Comment

SHEAPTHRES

Sort heap threshold (4 KB)

200000

Deployments with 3,000 or more concurrent users and using over 5 GB of RAM can increase this to 300000.

If you are using automatic management, then set this parameter to 0.

DIR_CACHE

Directory cache support

YES

ASLHEAPSZ

Application support layer heap size

15

RQRIOBLK

Maximum requester I/O block size (bytes)

65535

MON_HEAP_SZ

Database monitor heap size (4 KB)

128 (minimum)

KEEPFENCED

Keep Fenced process

YES

NUM_INITAGENTS

Initial number agents in pool

10

NUM_POOLAGENTS

Number of agents in the agent pool kept active at all times

80

MAX_COORDAGENTS

Maximum number coordinating agents

automatic

INDEXREC

Index recreation time

RESTART

INTRA_PARALLEL

Enable intra-partition parallelism

NO

INSTANCE_MEMORY

Amount of memory to be reserved for instance management

automatic

DB2set Parameters

Use the db2set command to set the parameters (for example, db2set DB2_HASH_JOIN = NO) referenced in the following table. On Windows, you access this command through the DB2 command prompt (db2cmd).

Parameter Explanation Setting

DB2_PARALLEL_IO

Useful when using RAID devices. For more information, see IBM DB2 documentation.

* (asterisk)

DB2_REDUCED_OPTIMIZATION

Controls optimization techniques used at specific optimization levels.

YES