Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Guidelines for Configuring the RDBMS > Configuring IBM DB2 UDB for Siebel Applications >
Guidelines for the DB2 UDB Database Manager Configuration Parameters
You can set the database configuration parameters using the update database manager configuration command of the DB2 Command Line Processor or using the DB2 Control Center. See the IBM DB2 technical documentation for more information on modifying the database configuration parameters. Table 6 describes DB2 database manager configuration parameters that differ from the default settings. Set these parameters for each DB2 instance. Use the configuration information in Table 6 for the listed parameters. For parameters not listed in this table, accept the default settings.
Table 6. 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 . |
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)
|
QUERY_HEAP_SZ
|
Query heap size (4 KB) |
16384
|
KEEPFENCED
|
Keep Fenced process (replaces KEEPDARI in DB2 v7) |
YES
|
KEEPDARI
|
Keep DARI process (only for DB2 v7) |
YES
|
MAXAGENTS
|
Maximum number existing agents |
20000 (minimum)
|
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 |
MAXAGENTS
|
INDEXREC
|
Index re-creation time |
RESTART
|
MAX_QUERYDEGREE
|
Maximum query degree of parallelism |
Between 1 and 6 |
INTRA_PARALLEL
|
Enable intra-partition parallelism |
NO
|
DB2set Parameters
Use the db2set command to set the parameters (for example, db2set DB2_HASH_JOIN = NO ) referenced in Table 7.
Table 7. db2set Parameters
|
|
|
DB2MEMDISCLAIM
|
For AIX only. When set to YES, DB2 agents explicitly request that the database server disassociate the reserved paging space from freed memory. Affects how DB2 frees shared memory. |
YES |
DB2MEMMAXFREE
|
For AIX only. Max. amount of unused memory in bytes retained by DB2 processes. It affects how DB2 frees shared memory and causes DB2 to release memory as soon as the size of the DB2 agent goes above the listed value. |
3000000 |
DB2_HASH_JOIN
|
Turns off hash joins in the optimizer. |
NO |
DB2_RR_TO_RS
|
Improves DB2 v7 performance with Siebel eBusiness Applications. This parameter does not apply to DB2 v8. NOTE: Set to YES only in production environment servers.
|
YES |
DB2_MMAP_WRITE
|
AIX Only. Recommended setting only; you should evaluate this setting for your particular configuration and environment. |
OFF |
DB2_MMAP_READ
|
AIX Only. Recommended setting only; you should evaluate this setting for your particular configuration and environment. |
OFF |
DB2_CORRELATED_PREDICATES
|
When set to YES, the optimizer is able to determine whether predicates in a query are related, which permits DB2 to calculate the filter factor more accurately. |
YES |
DB2_INDEX_2BYTEVARLEN
|
If you use DB2 v7, set this parameter to ON. Otherwise, you will not be able to create indexes with columns greater than 255 bytes. You do not need to set this parameter for DB2 v8 because DB2 v8 supports type-2 indexes. |
ON |
DB2_PIPELINED_PLANS
|
Tells the DB2 optimizer to favor pipeline execution plans—plans that are left deep and have no temporary result sets. |
ON |
DB2_INTERESTING_KEYS
|
Limits the number of execution plans generated by the DB2 optimizer. |
ON |
DB2_PARALLEL_IO
|
Useful when using RAID devices. For more information, see your DB2 vendor documentation. |
* |
DB2_STRIPED_CONTAINERS
|
Useful when using RAID devices. For more information, see your DB2 vendor documentation. |
ON |
EXTSHM
|
This parameter only applies to AIX. Use this parameter only when you have the DB Server and the Siebel Server on the same AIX machine. For more information, see When to Set the EXTSHM Parameter. |
ON |
DB2ENVLIST
|
When starting a DB2 UDB server and running EXTSHM , EXTSHM must be part of the DB2 environment. This parameter must be set when the database is created. |
EXTSHM |
DB2_NO_PKG_LOCK
|
To bind the Siebel package with siebbind , this package must be off. |
OFF |
When to Set the EXTSHM Parameter
The EXTSHM parameter must be set when the DB2 UDB 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 UDB server. Additionally, you should 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 UDB database.
|