Table 8. DB2 UDB Configuration Parameters
|
|
|
DFT_DEGREE
|
Degree of parallelism (1=turn query parallelism off). |
1
|
DFT_QUERYOPT
|
Default query optimization class. This parameter only takes effect on the DB server and affects the Siebel server components, such as 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 using Siebel Tools. |
3
|
DBHEAP
|
Database heap (4 KB). |
7429 (32-bit)
10000 (64-bit)
|
CATALOGCACHE_SZ
|
Catalog cache size (4 KB). |
5558 (32-bit)
8000 (64-bit)
|
LOGBUFSZ
|
Log buffer size (4 KB). |
On AIX, 128 (32-bit) 512 (64-bit)
|
UTIL_HEAP_SZ
|
Utilities heap size (4 KB). |
5000 (32-bit)
10000 (64-bit)
|
LOCKLIST
|
Maximum storage for lock list (4 KB). |
25000 (The setting should never be smaller than this, but may be increased.)
|
APP_CTL_HEAP_SZ
|
Maximum applications control heap size (4 KB). Controls the number of users that can be included within one connection to the database. |
900
For customers using Siebel connection pooling feature, for best scalability, increment the parameter by 1200 for each 10 users per connection. |
SORTHEAP
|
Sort list heap (4 KB). Lower values should be used for development environments; higher values for production. However, increasing this value can lead to insufficient memory on the DB server. Also this parameter may need to be set below the recommended range if you have a high number of Siebel users. Therefore, you need to always monitor DB server memory and performance to find the best setting for your environment. |
1000-5000
|
STMTHEAP
|
Minimum setting. If needed this parameter should be incremented in 1048 blocks. |
40960
|
STAT_HEAP_SZ
|
Statistics heap size (4 KB). |
14000 (32-bit)
16000 (64-bit)
|
MAXLOCKS
|
Percentage of lock lists per application. |
20 (32-bit)
30 (64-bit)
|
LOCKTIMEOUT
|
Lock time out (seconds). |
300
|
CHNGPGS_THRESH
|
Changed pages threshold. |
30
|
NUM_IOCLEANERS
|
Number of asynchronous page cleaners. |
Number of CPUs. |
INDEXSORT
|
Index sort flag. |
YES
|
SEQDETECT
|
Sequential detect flag. |
YES
|
DFT_PREFETCH_SZ
|
Default prefetch size (4 KB). |
32
|
LOGRETAIN
|
Sequential or circular log files. |
RECOVERY
Set this parameter to RECOVERY in a production environment. Otherwise, you will lose data should your database crash. When LOGRETAIN is set to RECOVERY , you must also activate USEREXIT or implement another method to manage the archived logs, so that LOGPATH does not fill up. |
MAXAPPLS
|
Maximum number of active applications. |
Twice the number of users. |
AVG_APPLS
|
Average number of active applications. |
Depends on the environment. |
MAXFILOP
|
Maximum DB files open per application. |
500
|
LOGFILSIZ
|
Log file size (4 KB). |
20000 |
LOGPRIMARY
|
Number of primary log files. |
25-50
The value of LOGPRIMARY and LOGSECOND together may not exceed 128. |
LOGSECOND
|
Number of secondary log files. |
Up to 103 The value of LOGPRIMARY and LOGSECOND together may not exceed 128. |
ESTORE_SEG_SZ
|
Deployments with servers with more than 4 GB of RAM can take advantage of this extended storage parameter. Use of this parameter also improves application sorting. Attach 4-KB and 16-KB buffer pools. |
Initially 16000 but can be up to 65536 . |
NUM_ESTORE_SEGS
|
See explanation of ESTORE_SEG_SZ . |
Initially 16 |
SOFTMAX
|
Percent log file reclaimed before soft checkpoint. |
80
|
APPLHEAPSZ
|
Default application heap (4 KB). |
2500
|
PCKCACHESZ
|
Package cache size (4 KB). |
40000 |
NUM_IOSERVERS
|
Number of disks on which the database resides. |
Number of disks. |