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