DB2 FOR LUW / DB2FORLUW / 970 - DB2

Description: 
 
Under rare scenarios DB2 might not create implied predicates on 
generated columns leading to unoptimized access plans if the 
following conditions are true: 
1. The DB is created with DB2_COMPATIBILITY_VECTOR=ORA 
2. The query contains one or more partitioned tables 
3. The partitioned table is partitioned on one or more generated 
columns 
4. The generated expression contains mathematical operations 
such as DIV, MULT 
5. The columns referenced in the generated expression are used 
in a local predicate 
 
example: 
 
create table test_sales (a int, b int generated always as (a / 
5)) partition by range(b) (starting from (0) ending at (1000) 
every (50)); 
select * from test_sales where a > 500; 
An implied predicate: b> 100 can be generated for this scenario

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 9.7 users                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See problem description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 10 or higher.            * 
****************************************************************

First fixed in DB2 Version 9.7 Fix Pack 10.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

11.07.2014
22.10.2014
22.10.2014

9.7.FP10