Tuning considerations for Db2

When setting up Db2®, the Self-Tuning Memory Manager (STMM) should initially be enabled. As the database grows, these settings may be adjusted to tune the system loads. Refer to Recommended DB CFG Parameters and the IBM® documentation regarding these settings.

Registry settings for Db2

For Sterling Order Management System Software , set the registry variables as follows (the variables with nothing following the equal sign ensure the default setting):

db2set DB2_MMAP_WRITE=OFF db2set DB2_MMAP_READ=OFF db2set DB2_PINNED_BP= db2set DB2MEMMAXFREE=

db2set DB2_ENABLE_BUFPD= db2set DB2_USE_ALTERNATE_PAGE_CLEANING=ON db2set DB2_EVALUNCOMMITTED=ON db2set DB2_SKIPDELETED=ON db2set DB2_SKIPINSERTED=ON db2set DB2_SELECTIVITY=YES db2set DB2LOCK_TO_RB=STATEMENT db2set DB2_NUM_CKPW_DAEMONS=0

Db2 dbset registry variables describes the effects of these parameters with Sterling Order Management System Software .