Default automatic statistics collection

Auto runstats uses distribution and sampled detailed indexes all when no profile is set for a table.

Collecting statistics using a statistics profile

The SET PROFILE clause creates a statistics profile for a table, so later stats collection will use it. If you use automatic maintenance on the database, it will also use this profile for the stats collection:

[db2instp@nodedb21 ~]$ db2 "RUNSTATS ON TABLE POSP.DAILY_SALES
>      ON ALL COLUMNS AND INDEXES ALL
>      ALLOW WRITE ACCESS
>      TABLESAMPLE BERNOULLI ( 10 )
>      SET PROFILE
>      UTIL_IMPACT_PRIORITY 10"

Background stats collecting (asynchronous)

Background stats collecting (or automatic runstats) is enabled by default when creating a database. The database configuration parameter is AUTO_RUNSTATS. You can change it directly or through the control center. The characteristics for automatic runstats are as follows:

• Performed using throttled runstats, adjusts its priority automatically...