DB2 FOR LUW / DB2FORLUW / 970 - DB2

CLI queries which needs internal translation, for eg. query 
using fn TimestampDiff function will internally be translated to 
use SYSFUN.TIMESTAMPDIFF instead, may throw error "CLI0118E 
Invalid SQL syntax.SQLSTATE=37000". This is because the length 
of the translated query is exceeding the allocated temporary 
buffer. In trace you may see failure in CLI_scnTranslate 
function 
 
1305278       31.954000729   | | | | CLI_scnReplaceToken entry 
1305279       31.954001518   | | | | CLI_scnReplaceToken error 
[probe 1] 
1305280       31.954001913   | | | | | CLI_errStoreError entry 
1305281       31.954002308   | | | | | CLI_errStoreError data 
[probe 999] 
1305282       31.954002703   | | | | | CLI_errStoreError exit 
1305283       31.954002703   | | | | CLI_scnReplaceToken exit 
[rc = 0xFFFFFFFF = -1] 
1305284       31.954002703   | | | | CLI_memFree entry 
1305285       31.954003097   | | | | CLI_memFree exit 
1305286       31.954003097   | | | CLI_scnTranslate exit [rc = 
0xFFFFFFFF = -1]

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fixpack 11                        * 
****************************************************************

First fixed in DB2 Version 9.7 Fixpack 11

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

06.03.2015
20.10.2015
20.10.2015

9.7.FP11