DB2 10.5 for Linux, UNIX, and Windows

Automatic statistics profiling is discontinued

Automatic statistics profiling is discontinued.

Details

Automatic statistics profiling is discontinued because of its noticeable performance overhead and restrictions. It is not supported in partitioned database environments, federated systems, or databases with intrapartition parallelism enabled or enables collection of section actuals.

The ASP value as a tool name parameter for the SYSINSTALLOBJECTS procedure is also discontinued.

The following tables are also discontinued as they are related to the automatic statistics profiler functionality:

SYSTOOLS.OPT_FEEDBACK_QUERY
SYSTOOLS.OPT_FEEDBACK_PREDICATE
SYSTOOLS.OPT_FEEDBACK_PREDICATE_COLUMN
SYSTOOLS.OPT_FEEDBACK_RANKING
SYSTOOLS.OPT_FEEDBACK_RANKING_COLUMN

In earlier releases, you could use automatic statistics profiling to determine recommended parameters for the RUNSTATS command. Also, automatic statistics profiling could detect whether table statistics were outdated.

Statistics profiles for the RUNSTATS command are not affected by this discontinuation and are still fully supported.

Resolution

Discontinue the use of Automatic statistics profiling functionality.

You can use the IBM® Data Studio tool to help you determine the best parameters for the RUNSTATS command to continue collecting statistics by using statistics profiles or by running the RUNSTATS command. The following capabilities can help you get recommendations for statistics collection:

Statistics Advisor. For more details, see Generating and acting on recommendations for collecting statistics for database objects that are in the access path for an SQL statement.
Workload Advisor. This advisor requires an active license for IBM InfoSphere® Optim™ Query Workload Tuner tool. For more details, see Creating MQTs, using multidimensional clustering, and redistributing data across database partitions.
Task assistant for the RUNSTATS command. For more details, see Database administration commands that you can run from task assistants.