home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT03681 Status: Closed

RUNSTATS MAY COLLECT INCORRECT VALUES FOR AVGPATITION_PAGE_FETCH

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
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.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* both software and hardware                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* move to v101 fp5                                             * 
****************************************************************
Local Fix:
N/A
Solution
included in v101 fp5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
11.08.2014
04.08.2015
04.08.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.5 FixList