Collecting statistics history

You can collect statistics history by using the RUNSTATS utility.

Procedure

To collect statistics history:

Specify the HISTORY option in the RUNSTATS utility control statement.

When you specify HISTORY with a value other than NONE, RUNSTATS updates the catalog history tables with the access path statistics, space statistics, or both, depending on the parameter that you specify with HISTORY. The HISTORY option does not update the main catalog statistics that Db2 uses to select access paths. You can use the HISTORY option to monitor how statistics change over time without updating the main catalog statistics that Db2 uses to select access paths.