DB2 database checklist

Table 1. DB2 database checklist
Recommendation Section Dev Prod Comments
Optimizer Statistics Index and table statistics NA C Regularly run runstats to keep table and index statistics up to date to ensure the DB2® optimizer picks appropriate execution plans.
Parameters governing DB2 locking strategy Recommended DB2 dbset registry variables C C Set DB2_EVALUNCOMMITTED, DB2_SKIPDELETED and DB2_SKIPINSERTED to reduce lock contention.
Parameters governing DB2 memory Recommended DB CFG parameters C C Set parameters to manage various memory structures such as the LOCKLIST, SORTHEAP, etc. at AUTOMATIC.

Set self_tuning_mem parameter to ON to enable the DB2 self-tuning memory features.

Volatile Table Volatile tables NA C Mark tables that change significantly as volatile.