DB2 FOR LUW / DB2FORLUW / 970 - DB2

The cardinality estimate for index scan operations requiring a 
FETCH (IXSCAN, IOA and IXA) might be inaccurate. The situations 
when this inaccuracy can occur will vary depending on many 
factors. It is more likely to occur if the index's table has 
many other indexes, column group statistics, statistical views 
or the table is range partitioned. The cardinality of the FETCH 
operator corresponding to the index scan operation might also be 
inaccurate.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See the APAR text                                            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FP6                                       * 
****************************************************************

None available.

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 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
 

A fix was provided in DB2 9.7 FP6

keiner bekannt / siehe Local-Fix

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

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

24.10.2011
05.06.2012
05.06.2012

9.7.FP6