DB2 FOR LUW / DB2FORLUW / A10 - DB2

Under rare conditions, DB2 may return an SQL0401N or SQL0901N 
error when a query contains a complex CASE expression with a 
TIMESTAMP 
function in the branches of a WHEN clause. 
 
Example query snippet: 
 
(CASE WHEN TEST.BEG_DT > date('12/31/2015') THEN TIMESTAMP 
(TEST.BEG_DT, '00.00.00') ELSE TIMESTAMP('12/31/2015') END) 
AND (CASE WHEN TEST.END_DT < date('04/01/2015') THEN TIMESTAMP 
(TEST.END_DT, '23.59.59')

**************************************************************** 
* USERS AFFECTED:                                              * 
* db2 luw                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v101 fixpack 5                                * 
****************************************************************

Upgrade to DB2 v101 fixpack 5

keiner bekannt / siehe Local-Fix

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

10.04.2015
22.07.2015
01.09.2015