Siebel Installation Guide for Microsoft Windows > Configuring the RDBMS > Configuring an IBM DB2 Database for Siebel Business Applications >
Guidelines for Setting IBM DB2 Database Manager Configuration Parameters
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, or by using the DB2 Control Center. For more information about modifying these configuration parameters, see IBM DB2 technical documentation. Table 23 describes IBM DB2 database manager configuration parameters that differ from the default settings. Set these parameters for each DB2 instance. Use the configuration information in Table 23 for the listed parameters. For parameters not listed in this table, accept the default settings. This topic is part of Configuring an IBM DB2 Database for Siebel Business Applications.
Table 23. IBM DB2 Database Manager Configuration Parameters
|
|
|
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 re-creation 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 Table 24. On Windows, you access this command through the DB2 command prompt (db2cmd).
Table 24. db2set Parameters
|
|
|
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. |
IXOROFNR
|
|