1. Installation Guide
  2. Guidelines for Setting IBM DB2 Configuration Parameters

Guidelines for Setting IBM DB2 Configuration Parameters

This topic is part of Configuring an IBM DB2 Database for Siebel CRM.

The database configuration parameters can be set by using the update database configuration command of the DB2 command line processor or DB2 command prompt (Windows).

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

The following table 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.

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).

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.