DB2 FOR LUW / DB2FORLUW / 970 - 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 9.7 FixPack 10                        * 
****************************************************************

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

Problem was first fixed in Version 9.7 FixPack 10

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC98508 IC98510 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

05.12.2013
10.11.2014
10.11.2014

9.7.FP10