DB2 FOR LUW / DB2FORLUW / A10 - DB2

When using "INDEXSAMPLE SYSTEM" to collect index statistics, the 
RUNSTATS utility can generate inacurrate AVGLEAFKEYSIZE and 
AVGNLEAFKEYSIZE. 
 
This problem affects the REORGCHK utility which uses the 
AVGLEAFKEYSIZE and AVGNLEAFKEYSIZE statistical values. 
 
For example: 
 
RUNSTATS ON TABLE MYSCHEMA.MYTABLE AND INDEXES ALL INDEXSAMPLE 
SYSTEM (10.000000) 
 
This runstats command results in: 
 
AVGLEAFKEYSIZE AVGNLEAFKEYSIZE 
-------------- --------------- 
             5               5 
 
 
Compare to: 
 
RUNSTATS ON TABLE MYSCHEMA.MYTABLE AND INDEXES ALL  ; 
 
AVGLEAFKEYSIZE AVGNLEAFKEYSIZE 
-------------- --------------- 
            53              53

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 5.                      * 
****************************************************************

First fixed in DB2 Version 10.1 Fix Pack 5.

not known / see Local fix

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

21.03.2014
23.07.2015
23.07.2015