Table 9. 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 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 using Siebel Tools. |
3
|
DBHEAP
|
Database heap (4 KB). |
10000
|
CATALOGCACHE_SZ
|
Catalog cache size (4 KB). |
8000
|
LOGBUFSZ
|
Log buffer size (4 KB). |
512
|
LOCKLIST
|
Maximum storage for lock list (4 KB). |
25000
The setting must 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, increment the parameter by 1200 for each 10 users per connection for best scalability. |
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 may need to be set below the recommended range if you have a high number of Siebel users. Therefore, you need to always monitor database server memory and performance to find the best setting for your environment. |
5000
|
STMTHEAP
|
Minimum setting. If needed, increment this parameter in 1048 blocks. |
40960
|
STAT_HEAP_SZ
|
Statistics heap size (4 KB). |
20000
|
MAXLOCKS
|
Percentage of lock lists per application. |
30
|
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. Set this parameter to RECOVERY in a production environment. Otherwise, you will lose data if your database crashes. 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. |
RECOVERY
|
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 (in 4 KB increments). |
40000 (minimum)
|
LOGPRIMARY
|
Number of primary log files. |
25-50
The value of LOGPRIMARY and LOGSECOND together may not exceed 256. |
LOGSECOND
|
Number of secondary log files. |
Up to 103 The value of LOGPRIMARY and LOGSECOND together may not exceed 256. |
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. NOTE: Performance testing is strongly recommended for this setting.
|
Initially 0 but can be up to 65536 . |
NUM_ESTORE_SEGS
|
See explanation of ESTORE_SEG_SZ . |
Initially 0 . |
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. |