Collecting statistics by using Db2 utilities
You can run certain Db2 utilities to collect access path statistics for your database objects. Accurate statistics are an essential component of access path selection.
Before you begin
You can use the statistics feedback data to identify missing or conflicting statistics. For more information, see Identifying missing or conflicting statistics.
You
can reset access path statistics for database objects before you collect new statistics. Doing so
can prevent stale statistics from impacting access path selection or increasing your statistics
collection costs because a statistics profile starts collecting them. For more information, see
Resetting access path statistics and Cleaning stale or unneeded Db2 catalog statistics.
About this task
You can use Db2 online utilities to collect statistics for database objects. The purpose of the RUNSTATS utility is to collect statistics for database objects. However, you can also collect inline statistics when you run certain other Db2 utilities.
Procedure
To collect statistics for database objects, use any of the following approaches: