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 IT02722 Status: Geschlossen

INVALID FILTER FACTOR ESTIMATION FOR RANGE PREDICATE

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
Under rare circumstances DB2 optimizer may calculate invalid 
Filter Factor for range predicate(s). 
The invalid Filter Factor for the range predicate will be 
noticed in a query plan explain output (db2exfmt) as following: 
 
  Filter Factor:             -1.#IND 
 
Following are the conditions to hit this issue: 
 
- DB2 LUW running on Windows platform 
- string column (char or varchar) 
- quantile distribution statistics have been collected on the 
column 
- range predicate on the column
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1 FixPack 5                               * 
****************************************************************
Local-Fix:
Lösung
First fixed in DB2 V10.1 FixPack 5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.06.2014
16.07.2015
16.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList