DB2 FOR LUW / DB2FORLUW / A50 - DB2

DB2 might produce SQL0901N if the following conditions are true: 
1) The query consists of a predicate of form TIMESTAMP <relop> 
TIMESTAMP 
2) <relop> can refer to any relational operator such as =, <>, 
>, < , etc 
3) Either sides of the predicate is either column or constant 
of type TIMESTAMP or is a function which returns a datatype of 
TIMESTAMP 
4) At least one side of the predicate references some form of 
time duration arithmetic operation 
 
eg. 
select * from T1 
where TScol + current timezone = timestamp(DATE(current timezone 
+ TScol), current_time); 
 
Will generate stack similar to this: 
 
0        ossDumpStackTraceInternal 
1        ossDumpStackTraceV98 
2        OSSTrapFile::dumpEx 
3        sqlo_trce 
4        sqloDumpDiagInfoHandler 
5        __restore_rt 
6        pthread_kill 
7        ossPthreadKill 
8        sqloDumpEDU 
9        sqldDumpContext 
10       sqlrr_dump_ffdc 
11       sqlzeDumpFFDC 
12       sqlzeMapZrc 
13       sqlrrMapZrc 
14       sqlritme 
15       sqlriExecThread 
16       sqlriSectInvoke 
17       sqlriExecOpenThread 
18       sqlrr_process_open_request

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Cancun Release 10.5.0.4                       * 
****************************************************************

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Fixed in DB2 Cancun Release 10.5.0.4

keiner bekannt / siehe Local-Fix

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

07.04.2014
24.11.2014
24.11.2014