DSNZPARM Parameter Settings for Siebel CRM

To run your Siebel CRM applications, you must set the values of some of the DSNZPARM parameters to required settings; other DSNZPARM parameter values are recommended to improve the performance of your Siebel CRM applications. This topic describes both the recommended and the required DSNZPARM parameter settings.

Note: Use the IBM default values for any DSNZPARMs for which recommended or required values are not listed in this topic. The IBM default values for any DSNZPARMs not listed here are the most appropriate values for running the current release of Siebel CRM.

You can configure some DSNZPARM parameters online, but to configure other parameters, you must shut down DB2. For information on the parameters that can be updated online, refer to the vendor documentation on the IBM Web site.

The following table lists the required and recommended DSNZPARM parameter settings.

Parameter	Explanation	Setting	Required or Recommended
DSN6SPRM
CACHEDYN	Turns on dynamic statement caching.	YES	Required
CDSSRDEF	Turns off parallelism for dynamic statements.	1	Required
CONTSTOR	Compresses storage on a regular basis. Set this value to YES if DBM1 storage is an issue.	YES	Recommended
EVALUNC	Allows predicate evaluation on uncommitted data.	YES	Recommended
MAXKEEPD	The total number of prepared, dynamic SQL statements that can be saved past a commit point by applications that run with the KEEPDYNAMIC(YES) bind option.	0	Recommended
NPGTHRSH	Allows small tables to use indexes.	10	Recommended
NUMLKUS	Number of locks for each user. It is recommended that the DBA monitors and sets this value. If you experience persistent locking problems, consider setting the parameter to 0 (unlimited number of locks). During Incremental Repository Merge, Oracle recommends setting the parameter to 0 (unlimited number of locks). For more information about Incremental Repository Merge, see Siebel Database Upgrade Guide.	100,000	Recommended
PARTKEYU	Allows update of partitioning keys.	YES	Required if using partitioning
RETVLCFK	Allows index-only access of varying-length characters. Set this value to NO due to padding.	NO	Required
DSN6SYSP
CHKFREQ	Avoids frequent checkpoints in a high-update environment. It is recommended that DBAs monitor and set this value for between 10 and 20 minutes.	500,000	Recommended
CONDBAT	Maximum number of concurrent remote connections. It is recommended that the DBA monitors and set this value.	10,000	Recommended
EXTSEC	Allows DB2 Connect to receive more complete error messages. Allows you to change passwords from DB2 Connect.	YES	Required
LOBVALA	Specifies the maximum amount of storage, in KB, assigned to each user for storing large object (LOB) values in the subsystem. If the value specified for this parameter is too low, the job that imports seed data during the Siebel database installation process can fail.	48,000	Recommended
LOBVALS	Specifies the maximum amount of memory, in MB, assigned to each subsystem for storing LOB values.	24,000	Recommended
MAXDBAT	Maximum number of database threads (DBAT). It is recommended that the DBA monitors and set this value.	500	Recommended
DSN6FAC
CMTSTAT	Allows a greater number of remote threads without affecting storage. Enables DDF thread pooling.	INACTIVE	Recommended
IDTHTOIN	Number of seconds before an idle thread is canceled. Prevents long-running threads from holding resources. The DBA should monitor and set this value.	600	Recommended
POOLINAC	Number of seconds an inactive thread remains in the DDF pool. The DBA should monitor and set this value.	120	Recommended