Additional settings for configuration parameters on DB2 database
For optimal performance, use these parameters and values for DB2® database.
Parameter | Description | Value |
---|---|---|
SELF_TUNING_MEM |
Enables the DB2 self-tuning memory manager (STMM) to automatically and dynamically set memory allocations to memory consumers such as buffer pools, lock lists, package cache, and sort heap. |
ON |
DATABASE_MEMORY |
Allows DB2 to adjust the amount of database memory depending on load, memory pressures, and other factors. |
AUTOMATIC |
LOCKLIST |
Allows STMM to dynamically manage memory allocations. |
AUTOMATIC |
MAXLOCKS |
Allows STMM to dynamically manage memory allocations. |
AUTOMATIC If AUTOMATIC is not supported: 100 |
PCKCACHESZ |
Allows STMM to dynamically manage memory allocations. |
AUTOMATIC |
SHEAPTHRES_SHR |
Allows STMM to dynamically manage memory allocations. |
AUTOMATIC |
SORTHEAP |
Allows STMM to dynamically manage memory allocations. |
AUTOMATIC |
NUM_IOCLEANERS |
AUTOMATIC |
|
NUM_IOSERVERS |
AUTOMATIC |
|
DFT_PREFETCH_SZ |
AUTOMATIC |
|
MAXAPPLS |
AUTOMATIC |
|
APPLHEAPSZ |
AUTOMATIC |
|
APPL_MEMORY |
AUTOMATIC |
|
DBHEAP |
Amount that is required depends on the amount of memory available and the traffic volume. |
AUTOMATIC Attention: The default
DBHEAP value is inadequate.
|
LOGFILSIZ |
Refer to the topic Log Configuration. |
65536 if you are configuring 20 transaction logs of 256 MB (65536 4KB pages) |
LOGPRIMARY |
Number of primary transaction logs. Refer to the topic Log Configuration. |
40 or more |
LOGSECOND |
Number of secondary transaction logs. These logs are allocated by DB2 when it cannot reuse any of the primary logs due to active transactions. Refer to the topic Log Configuration. |
12 |
NUM_LOG_SPAN |
Refer to the topic Log Configuration. |
LOGPRIMARY - Safety buffer |
DFT_DEGREE |
Sets the default degree of parallelism for intrapartition parallelism. In general, online transactional applications such as Sterling B2B Integratortypically experience a high volume of short queries that do not benefit from parallel queries. |
1 – Disable intrapartition parallelism |
DB2LOCK_TO_RB |
STATEMENT |
|
STMT_CONC | OFF | |
DB2_COMPATIBILITY_VECTOR | Enables one or more DB2 compatibility features. | NULL |