DB2 FOR LUW / DB2FORLUW / 970 - DB2

Description: 
The optimizer might choose a table scan over an index access of 
a range partitioned table in a database partitioned environment 
under the following conditions: 
- the table is range partitioned and hash distributed on the 
same single column; e.g. 
    create table t1 (C1 date, ...) distribute by hash (C1) 
partition by range (C1) (starting (minvalue) ending 
('2010-12-31'), starting('2011-01-01') ending ('2011-01-31'), 
...) 
- the query contains an equality predicate on the column; e.g. 
C1='2012-01-15' 
- a partitioned index containing C1 in the key exists 
 
This problem is more likely to occur for tables with a large 
number of range partitions where the majority are empty.

**************************************************************** 
* USERS AFFECTED:                                              * 
* This problem is more likely to occur for tables with a large * 
* number of range partitions where the majority are empty.     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Description:                                                 * 
* The optimizer might choose a table scan over an index access * 
* of                                                           * 
* a range partitioned table in a database partitioned          * 
* environment                                                  * 
* under the following conditions:                              * 
* - the table is range partitioned and hash distributed on the * 
* same single column; e.g.                                     * 
*     create table t1 (C1 date, ...) distribute by hash (C1)   * 
* partition by range (C1) (starting (minvalue) ending          * 
* ('2010-12-31'), starting('2011-01-01') ending                * 
* ('2011-01-31'),                                              * 
* ...)                                                         * 
* - the query contains an equality predicate on the column;    * 
* e.g.                                                         * 
* C1='2012-01-15'                                              * 
* - a partitioned index containing C1 in the key exists        * 
*                                                              * 
* This problem is more likely to occur for tables with a large * 
* number of range partitions where the majority are empty.     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgraded to DB2 version 9.7 fixpack 8.                       * 
****************************************************************

You can use an optimization guideline to produce an index 
access.

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
 

You can use an optimization guideline to produce an index 
access.

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

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

10.12.2012
02.04.2013
02.04.2013

9.7.FP8