home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC83737 Status: Geschlossen

OPTIMIZER RE-I/O COST ESTIMATION CAN BE INACCURATE FOR IXSCAN-FETCH

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
The Re-I/O Cost estimation can be inaccurate for the FETCH 
operator in IXSCAN-FETCH when sequential prefetch is present in 
the FETCH operator, and the index is not 100% clustered, and the 
index is not fully qualified. Consequently, the Re-Total Cost, 
which includes Re-I/O Cost, can be inaccurate too. 
 
This problem was introduced in DB2 v9.5 Fixpack 9.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.5 Fixpack 10 or higher                     * 
****************************************************************
Local-Fix:
Lösung
First fixed in DB2 v9.5 Fixpack 10 or higher
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
24.05.2012
22.08.2012
22.08.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP10
Problem behoben lt. FixList in der Version
9.5.0.10 FixList