RUNSTATS
The RUNSTATS utility collects statistics about the data distribution of the specified Db2 objects. Valid objects include combinations of tables, tablespaces, and indexes. The Db2 optimizer uses catalog statistics to determine the most efficient access path. Updated catalog statistics help you reorganize a tablespace or index, or analyze a database's design.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*