DB2 FOR LUW / DB2FORLUW / 970 - DB2

RUNSTATS may collect incorrect values for 
AVGPARTITION_PAGE_FETCH_PAIRS where buffer size value  for two 
consecutive pairs is the same but the page fetch value is not 
the same. 
 
This fails to meet the condition: For 
AVGPARTITION_PAGE_FETCH_PAIRS, if the buffer size value is the 
same in two consecutive pairs, then page fetch value must also 
be the same in both the pairs. 
 
 
This may cause sql1227 RC 10 when using these statistics 
(retrieved with db2mimic) to update the sysstat.indexes columns.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to v97 fp10                                          * 
****************************************************************

N/A

fixed in version v97 fp10

not known / see Local fix

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

09.12.2013
14.11.2014
14.11.2014

9.7.FP10