DB2 FOR LUW / DB2FORLUW / A10 - DB2

The COLLECT STATISTICS option of the CREATE INDEX statement can 
generate incorrect external index statistics for: 
    - AVGLEAFKEYSIZE and AVGNLEAFKEYSIZE, 
    - AVGPARTITION_CLUSTERRATIO, for non-partitioned indexes in 
partitioned table 
    - DATAPARTITION_CLUSTERFACTOR, when the table is not a 
partitioned table 
which are visible in the SYSCAT.INDEXES catalog view. 
 
AVGLEAFKEYSIZE and AVGNLEAFKEYSIZE are used by the REORGCHK 
utility, and its recommendations might be affected by incorrect 
statistics. 
 
AVGPARTITION_CLUSTERRATIO and DATAPARTITION_CLUSTERFACTOR are 
statistics collected for the query optimizer.  While unexpected 
statistics values might be visible in the external catalogs, the 
optimizer is not affected as it uses statistics stored in 
internal descriptors.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL users on DB2 V101 FP2 and earlier                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V101 FP3                                      * 
****************************************************************

Execute RUNSTATS after the CREATE INDEX.

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First Fixed in DB2 v101 FP3

not known / see Local fix

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

22.01.2013
01.10.2013
01.10.2013