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. |