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.
About this task
DB2 uses statistics profiles when you enable autonomic statistics maintenance. When you first enable autonomic statistics maintenance, the ADMIN_UTL_MONITOR stored procedure sets a profile for each monitored table based on the existing statistics. However, if a profile exists for a table, DB2 uses the existing profile.
Procedure
To set a statistics profile, complete one of the following actions:
Results
No statistics are collected when you run the RUNSTATS utility with the SET PROFILE option. If a profile exists for the specified table, that profile is replaced with the new one, and the existing profile is lost. Only one profile can exist for a particular table.