DB2 FOR LUW / DB2FORLUW / B10 - DB2

DB2 might abend when running queries containing CASE Expression,
UNION and UDF

DB2 might abend when users run a query with the following
characteristics:
1. The query contains at least one UNION
2. In the UNION branches, the query references a UDF
3. This UDF has at least one input parameter
4. This query also contains at least a CASE expression

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
****************************************************************

db2set DB2COMPOPT = NO_SIMPL_CASE_PRD

keiner bekannt / siehe Local-Fix

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

11.07.2018
27.11.2018
27.11.2018