DB2 FOR LUW / DB2FORLUW / 970 - DB2

In some cases, the I/O cost associated with a data page fetch 
operation will be under-estimated when the index is partitioned, 
detailed index statistics have been collected and all index 
partitions must be accessed i.e. the query doesn't contain any 
predicates that can limit the number of index partitions that 
are accessed. The problem can be avoided by collecting 
non-detailed index statistics i.e. do not include the 'DETAILED' 
keyword on the RUNSTATS command.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Same as error description.                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 5.                       * 
****************************************************************

N/A

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

First fixed in DB2 Version 9.7 Fix Pack 5.

N/A

N/A

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

30.08.2011
20.09.2011
20.09.2011

9.7.FP5