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 |