Bookshelf v8.1/8.2: Guidelines for Setting IBM DB2 Configuration Parameters

The database configuration parameters can be set by using the update database configuration command of the DB2 Command Line Processor or by using the DB2 Control Center.

For more information about modifying these configuration parameters, see IBM DB2 technical documentation.

Table 27 describes IBM DB2 database configuration parameters that differ from the default settings. However, these descriptions are guidelines only. Set these parameters for each database within an instance on which you run your Siebel application. For other parameters, accept the default settings.

Table 27. IBM DB2 Configuration Parameters
Parameter	Explanation	Setting
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).	`10000`
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.	`25600`
STAT_HEAP_SZ	Statistics heap size (4 KB).	`14000`
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).	`2500`
PCKCACHESZ	Package cache size (4 KB).	Automatic.
NUM_IOSERVERS	Number of disks on which the database resides.	Automatic.

Siebel Installation Guide for UNIX		Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.