DB2 FOR LUW / DB2FORLUW / A50 - DB2

When use db2look mimic mode (-m) against a table which has 
distribution statistics collected on specific columns, the 
RUNSTATS command generated by db2look -m will include all 
columns in the "WITH DISTRIBUTION ON COLUMNS" clause with 
"NUM_FREQVALUES -1 NUM_QUANTILES -1" option for the columns 
which have no distribution statistics collected. 
 
Reproduce steps: 
 
-> db2 "CREATE TABLE SAMPLE.T1  ( 
                   "C1" INTEGER NOT NULL , 
                   "C2" VARCHAR(100) , 
                   "C3" VARCHAR(100) )" 
DB20000I  The SQL command completed successfully. 
 
-> db2 "insert into t1 values(1,'John','Smith'),(2, 'Tom', 
'Jones'), (3,'Jack', 'Levis')" 
DB20000I  The SQL command completed successfully. 
 
-> db2 " runstats on table sample.t1 with distribution on 
columns(c3)" 
DB20000I  The RUNSTATS command completed successfully. 
 
-> db2look -d sample -e -m -t t1 
 
In the script, the RUNSTATS command likes below: 
-- Mimic table T1 
 
RUNSTATS ON TABLE "SAMPLE"."T1" 
        WITH DISTRIBUTION ON COLUMNS ( 
                "C1" NUM_FREQVALUES -1 NUM_QUANTILES -1, 
                "C2" NUM_FREQVALUES -1 NUM_QUANTILES -1, 
                "C3" NUM_FREQVALUES 3 NUM_QUANTILES 3);

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 Version 10.5 FixPack 4                        * 
****************************************************************

Before execute the script, manually remove those columns from 
"WITH DISTRIBUTION ON COLUMNS"

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 10.5 FixPack 4

keiner bekannt / siehe Local-Fix

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

27.12.2013
08.09.2014
08.09.2014