|
Problem IC74811
|
Status: Closed |
RUNSTATS USE PROFILE IGNORES FREQUENCY AND QUANTILE OPTIONS OF THE DISTRIBUTION CLAUSE WHEN "ON ALL COLUMNS" IS ALSO SPECIFIED |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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. |
| Problem Summary: |
****************************************************************
* 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 *
**************************************************************** |
| Local Fix: |
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 |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.03.2011
17.01.2012
17.01.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
