Creating statistics profiles

You can create and use statistics profiles to collect statistics for particular tables with consistent options, without the need to explicitly specify the options each time. Db2 also uses the statistics profiles when you implement autonomic statistics maintenance.

To set a statistics profile, complete one of the following actions:

• Set the value of the STATFDBK_PROFILE subsystem parameter to YES.
  When you specify this option, Db2 automatically creates and modifies profiles based on statistics recommendations when it writes the recommendations to the SYSIBM.SYSSTATFEEDBACK catalog table. For more information about this approach, see Applying statistics recommendations to statistics profiles automatically.
  
• Issue the following utility control statement to explicitly specify collection options for the profile:

  RUNSTATS TABLESPACE ts-name TABLE table-name runstats-options SET PROFILE

  Db2 records the values specified by runstats-options in the PROFILE_TEXT column of the SYSIBM.SYSTABLES_PROFILES catalog table. Db2 uses the default values for any options that are not specified.
• Issue the following utility control statement to automatically specify options in the profile based on the existing statistics for the specified table:

  RUNSTATS TABLESPACE ts-name TABLE table-name SET PROFILE FROM EXISTING STATS

  The generated profile is based on the statistics that exist in the catalog tables. However, the keywords used in the generated profile do not necessarily match the keywords that were used to collect the statistics previously.