#1: Use RUNSTATS on the Catalog
Run whenever substantial changes are made to your DB2 subsystems
- New database(s)
- New application(s)
- Significant modification(s)
Helps for querying the DB2 Catalog tables
Helps for determining when/if to reorganize the DB2 Catalog table spaces