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.