DB2 FOR LUW / DB2FORLUW / 970 - 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 V97 FP7 and lower                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V97 FP8                                       * 
****************************************************************

Execute RUNSTATS after the CREATE INDEX.

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
 

First Fixed in DB2 V97 FP8

not known / see Local fix

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

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

12.10.2012
08.04.2013
08.04.2013

9.7.FP8