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.