DB2 FOR LUW / DB2FORLUW / A10 - DB2

Under rare scenarios, DB2 might abend or produce SQL0901N when 
the following conditions are true: 
1) DB2 must be running on MPP configuration 
2) The query contains a recursive UNION ALL construct 
3) The recursive branch of the UNION ALL contains one or more 
join predicates 
4) Atleast one of the joins is of type: <expression> = <col>, 
where <expression> involves only columns from a single subselect 
eg. T1.C1 + T1.c2 + 1 = T2.c1

**************************************************************** 
* USERS AFFECTED:                                              * 
* MPP                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1 Fix Pack 5 or higher.            * 
****************************************************************

Manually rewrite the query to push the expression to the 
subselect and use the output column reference for join predicate

Problem first fixed in DB2 version 10.1 Fix Pack 5.

keiner bekannt / siehe Local-Fix

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

16.03.2015
26.07.2015
26.07.2015