DB2 FOR LUW / DB2FORLUW / 970 - DB2

An OR(disjunct) predicate has multiple subterm predicates, 
called SP1, SP2, and so on. Each OR subterm predicate SP is 
either a simple predicate or multiple predicates combined with 
AND (conjunct). Given two subterm predicates, SPi and SPj, if 
SPi is identical to SPj or SPi is identical to any conjunct 
predicate under SPj, SPj has no filtering effect and will be 
removed from the parent OR predicate. 
 
As example: 
select * from table where  ( ( col1 = 1 ) or ( col1 = 2 ) ) or ( 
( col2 = 1 ) and ( col1 = 2 ) ) 
 
P1:  ( col1 = 1 ) or 
P2: ( col1 = 2 ) ) or 
P3: ( ( col2 = 1 ) and ( col1 = 2 )) 
 
Predicate P3 is redundant - it is true only if P2 is true, thus 
can be safely removed during query rewrite phase

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 Fixpak 8                                  * 
****************************************************************

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 9.7 Fixpak 8

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC91303 
follow-up : 

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

30.11.2012
29.04.2013
29.04.2013

9.7.