Statistics collection enhancements

In Db2 11, certain utilities and commands are enhanced to improve the ease of collecting and maintaining statistics for your database objects.

Db2 11 includes the following enhancements that improve statistics collection:

  • When you specify the USE PROFILE keyword in a RUNSTATS utility control statement, a default profile is applied when no profile exists for a target table.
  • You can use the RUNSTATS utility to reset the access path statistics to default values for a target table space.
  • You can use the ACCESS DATABASE command to immediately externalize in-memory real-time statistics to the catalog tables.
  • You can collect distribution statistics when you collect inline statistics when you run the following utilities:
    • LOAD
    • REORG TABLESPACE
  • You can collect histogram statistics when you collect inline statistics when you run the following utilities:
    • LOAD
    • REBUILD INDEX
    • REORG INDEX
    • REORG TABLESPACE
  • You can use information that Db2 externalizes during access path selection to identify missing and conflicting statistics to collect.