Db2 database checklist
You can review the Db2® database checklist for recommendations.
| 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 |
| Volatile Table | Volatile tables | NA | C | Mark tables that change significantly as volatile. |