DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 may abend when the SQL statement satisfies all the following 
conditions: 
1. Query has an equality predicate between simple column and a 
constant value, i.e. Q1.col1 = <literal>. 
2. The same query block also has an OR predicate, e.g. "P1 OR P2 
OR .. OR Pn", Pi stands for an OR subterm predicate. 
3. An OR subterm predicate Pi contains "Pa1 AND Pa2.. AND Pak". 
One Pa is a provable FALSE predicate and another Pa is an 
EXISTS, NOT EXISTS, IN, or NOT IN predicate.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users on V9.7 FP 7 and lower                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 Fix Pack 8 or higher                         * 
****************************************************************

Reduce query optimization level to 0,1, 2, or 3 by using 
command, e.g,  "db2 set current query optimization <optlevel>"

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 V9.7 FixPack 8

not known / see Local fix

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

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

22.10.2012
23.08.2013
23.08.2013

9.7.FP8