Filter
Top Products
Parameter Recommended value
NUM_IOCLEANERS Recommended value: AUTOMATIC
NUM_IOSERVERS Recommended value: AUTOMATIC
DFT_PREFETCH_SZ Recommended value: AUTOMATIC
MAXAPPLS Recommended value: AUTOMATIC
APPLHEAPSZ Recommended value: AUTOMATIC
APPL_MEMORY Recommended value: AUTOMATIC
APP_CTL_HEAP_SZ 512
Note: APP_CTL_HEAP_SZ is deprecated in DB2 9.5.
DBHEAP Amount required depends on the amount of memory available and the
traffic volume.
Recommended value: AUTOMATIC
Note: The default DBHEAP value is inadequate.
LOGFILSIZ Refer to the topic Log Configuration.
Recommended value: 65536 if configuring 20 transaction logs of 256 MB
(65536 4 K pages)
LOGPRIMARY Number of primary transaction logs. Refer to the topic Log Configuration.
Recommended value: 40 or more
LOGSECOND Number of secondary transaction logs. These are allocated by DB2 when it
cannot reuse any of the primary logs due to active transactions. Refer to the
topic Log Configuration.
Recommended value: 12
NUM_LOG_SPAN Refer to the topic Log Configuration.
Recommended value: LOGPRIMARY - Safety buffer
DFT_DEGREE Sets the default degree of parallelism for intrapartition parallelism. In
general, online transactional applications such as Sterling B2B Integrator
typically experience a high volume of short queries that do not benefit from
parallel queries.
Recommended value: 1 – Disable intrapartition parallelism
DB2LOCK_TO_RB Recommended value: STATEMENT
Performance Management 41