DB2 FOR LUW / DB2FORLUW / A10 - 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:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fixpack 3.                       * 
****************************************************************

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

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Fixed in Version 10.1 Fixpack 3.

keiner bekannt / siehe Local-Fix

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

22.04.2013
10.10.2013
10.10.2013