Table 32. IBM DB2 Configuration Parameters
|
|
|
DFT_DEGREE |
Degree of parallelism (the value 1 turns query parallelism off). |
1
|
DFT_QUERYOPT |
Default query optimization class. This parameter only takes effect on the database server and affects the Siebel Server components, such as Siebel EIM or Siebel Remote. Queries run through the UI are not affected by this setting. They take the value of the Siebel system preference DB2: Default Opt Level, or you can override them at the business component level by using Siebel Tools. |
3
|
DBHEAP |
Database heap (4 KB). |
Automatic. |
CATALOGCACHE_SZ |
Catalog cache size (4 KB). |
10000
|
LOGBUFSZ |
Log buffer size (4 KB). |
512
|
LOCKLIST |
Maximum storage for lock list (4 KB). |
Automatic. |
SORTHEAP |
Sort list heap (4 KB). Use lower values for development environments; use higher values for production. However, increasing this value can lead to insufficient memory on the database server. Also, this parameter might have to be set below the recommended range if you have a high number of Siebel users. Always monitor database server memory and performance to find the best setting for your environment. |
Automatic. |
STMTHEAP |
Minimum setting. If necessary, increment this parameter in 1048 blocks of 4 KB. |
Automatic or a fixed value. For example, you might update the parameter setting using a command like this: DB2 UPDATE DB CFG FOR SAMPLE USING STMTHEAP 8192 AUTOMATIC
This value specifies 8192 times 4 KB (or 32 MB) for dynamic join enumeration and unlimited for greedy join enumeration. |
STAT_HEAP_SZ |
Statistics heap size (4 KB). |
Automatic. |
MAXLOCKS |
Percentage of lock lists for each application. |
Automatic. |
LOCKTIMEOUT |
Lock time out (seconds). |
300
|
CHNGPGS_THRESH |
Changed pages threshold. |
60
|
NUM_IOCLEANERS |
Number of asynchronous page cleaners. |
Automatic. |
SEQDETECT |
Sequential detect flag. |
YES
|
DFT_PREFETCH_SZ |
Default prefetch size (4 KB). |
32
|
MAXAPPLS |
Maximum number of active applications. |
Automatic. |
AVG_APPLS |
Average number of active applications. |
Automatic. |
MAXFILOP |
Maximum DB files open for each application. |
500
|
LOGFILSIZ |
Log file size (in 4 KB increments). |
65535
|
LOGPRIMARY |
Number of primary log files. |
25 to 50
The value of LOGPRIMARY and LOGSECOND together must not exceed 256. |
LOGSECOND |
Number of secondary log files. |
Up to 103 The value of LOGPRIMARY and LOGSECOND together must not exceed 256. |
SOFTMAX |
Percent log file reclaimed before soft checkpoint. |
80
|
APPLHEAPSZ |
Default application heap (4 KB). |
Automatic. |
PCKCACHESZ |
Package cache size (4 KB). |
Automatic. |
NUM_IOSERVERS |
Number of disks on which the database resides. |
Automatic. |