Table 7. Database Manager Configuration Parameters (DSNZPARM)
|
|
|
|
DSN6SPRM |
CACHEDYN
|
Turns on dynamic statement caching. |
v7 v8 |
YES (required)
|
CDSSRDEF
|
Turns off parallelism for dynamic statements. |
v7 v8 |
1 (required)
|
CONTSTOR
|
Compresses storage on a regular basis. Set this value to YES if DBM1 storage is an issue. |
v7 v8 |
YES
|
EVALUNC
|
Allows predicate evaluation on uncommitted data. |
v7 v8 |
YES
|
IRLMRWT
|
Time in seconds before a time-out occurs. |
v7
|
300
|
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. |
v7 v8 |
0 |
MINSTOR
|
Compresses storage on a regular basis. Set this value to YES if DBM1 storage is an issue. |
v7 v8 |
YES
|
MXTBJOIN
|
Sets the maximum number of tables in a join. The default (15) is not sufficient for Siebel Business Applications. NOTE: Unlike other DSNZPARMs that cannot be updated through the installation panels, this parameter must be updated manually.
|
v7 v8 (default)
|
128 (required)
|
NPGTHRSH
|
Allows small tables to use indexes. |
v7 v8 |
10
|
NUMLKUS
|
Number of locks per user. The DBA should monitor and set this value. If you experience persistent locking problems, consider setting the parameter to 0 (unlimited number of locks). |
v7 v8 |
100,000
|
OPTCCOS1
|
Allows multiple, predicate optimizer enhancements. |
v7 v8 (default) |
ON (required)
|
OPTSUBQ1
|
Allows noncorrelated, subquery optimizer enhancements. |
v7 v8 |
YES
|
PARTKEYU
|
Allows update of partitioning keys. |
v7 v8 |
YES (required)
|
RETVLCFK
|
Allows index-only access of varying-length characters. This value should be set to NO due to padding. |
v7 v8 |
NO (required)
|
DSN6SYSP |
CHKFREQ
|
Avoids frequent checkpoints in a high-update environment. DBAs should monitor and set this value for between 10 and 20 minutes. |
v7 v8 |
20 |
CONDBAT
|
Maximum number of concurrent remote connections. The DBA should monitor and set this value. |
v7 v8 (default) |
10,000
|
EXTSEC
|
Allows DB2 Connect to receive more complete error messages. Allows you to change passwords from DB2 Connect. |
v7 v8 (default) |
YES (required)
|
MAXDBAT
|
Maximum number of database threads (DBAT). The DBA should monitor and set this value. |
v7 v8 |
500
|
MGEXTSZ |
Specifies whether or not the secondary extent allocations for DB2-managed data sets are sized according to a sliding scale that optimizes the likelihood of reaching the maximum data set size before secondary extents are exhausted. If you specify YES, DB2 automatically optimizes the secondary extent allocations. |
v8 |
NO |
DSN6FAC |
CMTSTAT
|
Allows a greater number of remote threads without affecting storage. Enables DDF thread pooling. |
v7 v8 (default) |
INACTIVE
|
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. |
v7 v8 |
600
|
POOLINAC
|
Number of seconds an inactive thread remains in the DDF pool. The DBA should monitor and set this value. |
v7 v8 (default) |
120
|
PADIX |
Determines whether or not new indexes are padded by default. If you specify YES, a new index is padded unless the NOT PADDED option is specified on the CREATE INDEX statement. |
v8 |
YES |