DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 instance may abend during compilation of a query that 
satisfies the following conditions: 
- There is an equality predicate (EQPRD) in the query 
- One side of EQPRD is either a constant, host-variable or 
special register (CONST) 
- The other side of EQPRD is a column derived from the output of 
a MAX or MIN aggregate function 
- The MAX or MIN function aggregates a column from a nested 
subselect (NS) 
- The column from NS is a CASE expression (CASEEXP) 
- CASEEXP has only 1 WHEN clause 
- The WHEN clause is also an EQPRD (WHENPRD) 
- One side of WHENPRD is CONST 
- The other side of WHENPRD is non-CONST 
- NS also has another CASE expression as an output column which 
is not referenced anywhere else 
- NS has a SELECT DISTINCT clause

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 5 or later.              * 
****************************************************************

Rewrite the problematic query into a semantically identical form 
to preclude any of the conditions described above, e.g., EQPRD 
may be rewritten as a redundant IN predicate.

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 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 Version 9.7 Fix Pack 5.

keiner bekannt / siehe Local-Fix

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

23.03.2011
07.12.2011
07.12.2011

9.7.FP5