Siebel Installation Guide for UNIX > 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. For more information about modifying these configuration parameters, see IBM DB2 technical documentation. Table 30 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 30 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 30. 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 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 Table 31.
Table 31. db2set Parameters
|
|
|
EXTSHM |
(AIX only) Use this parameter only when you have the Siebel database and the Siebel Server on the same AIX computer. EXTSHM must be set when the IBM DB2 database is created and must be included in the script that starts it. The parameter also must appear in the sqllib/db2profile file for the DB2 server. Include this parameter in the script that starts the DB2 client. After changing any of these settings, you must perform a db2stop , then db2start , to implement the changes in your DB2 database. |
ON
|
DB2ENVLIST |
(AIX only) When starting an IBM DB2 server and running EXTSHM, EXTSHM must be part of the DB2 environment. This parameter must be set when the database is created. |
EXTSHM
|
DB2MEMDISCLAIM |
(AIX only) When set to YES, IBM DB2 disclaims some or all of the freed memory, depending on the value of DB2MEMMAXFREE. |
YES
|
DB2_MMAP_READ |
(AIX only) Recommended setting only; evaluate this setting for your particular configuration and environment. |
OFF
|
DB2_MMAP_WRITE |
(AIX only) Recommended setting only; evaluate this setting for your particular configuration and environment. |
OFF
|
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
|
|