DB2 FOR LUW / DB2FORLUW / 970 - DB2

When a statistics profile exists for a table which specifies 
frequency and/or quantile options that are different from the 
defaults, and the profile also specifies "ON ALL COLUMNS" in the 
Distribution Clause, RUNSTATS USE PROFILE ignores the specified 
frequency and quantile options and uses the defaults.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When a statistics profile exists for a table which specifies * 
* frequency and/or quantile options that are different from    * 
* the defaults, and the profile also specifies "ON ALL         * 
* COLUMNS" in the Distribution Clause, RUNSTATS USE PROFILE    * 
* ignores the specified frequency and quantile options and     * 
* uses the defaults.                                           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to Version 9.7 Fix Pack 5                             * 
****************************************************************

When creating the profile, specify the Distribution Clause in 
the profile using explicit column specifications for each column 
of the table, without using "ON ALL COLUMNS". 
 
For example, table P73903.T1 has 4 columns and it is desired to 
have a profile where one column has distribution options that 
are different from default NUM_FREQVALUES 10 and default 
NUM_QUANTILES 20. 
 
Instead of: 
RUNSTATS ON TABLE P73903.T1 WITH DISTRIBUTION ON ALL COLUMNS AND 
COLUMNS (c2 NUM_FREQVALUES 25 NUM_QUANTILES 50) AND SAMPLED 
DETAILED INDEXES ALL SET PROFILE 
 
Specify: 
RUNSTATS ON TABLE P73903.T1 WITH DISTRIBUTION ON COLUMNS (c2 
NUM_FREQVALUES 25 NUM_QUANTILES 50, c1, c3, c4) AND SAMPLED 
DETAILED INDEXES ALL SET PROFILE

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 9.7 Fix Pack 5

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

03.03.2011
17.01.2012
17.01.2012

9.7.FP5