DB2 FOR LUW / DB2FORLUW / 970 - DB2

When range predicate literal values are beyond the highest 
quantile value, filter factor calculation may be incorrect. 
 
For example, suppose the highest quantile value for the column 
DATE is '2012-07-25'. Range predicates (DATE >= '2012-07-25' and 
DATE < '2012-07-26') can result in a combined FF of almost 0 
rather than the FF of the equality predicate DATE = 
'2012-07-25'.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to v9.7 Fix Pack 8                                    * 
****************************************************************

Use an equality predicate if it is logically equivalent to a set 
of range predicates

DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in v9.7 Fix Pack 8

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC85887 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

13.08.2012
15.04.2013
15.04.2013

9.7.FP8