DB2 FOR LUW / DB2FORLUW / A50 - DB2

If you have an application that connects to a DB2 server through 
a gateway, your application may fail with the following error if 
one of your query is interrupted by a SQLCancel(). 
SQL30020N Execution of the command or SQL statement failed 
because of a 
syntax error in the communication data stream that will affect 
the successful 
execution of subsequent commands and SQL statements: Reason Code 
 
"0x124C"("0100")"". SQLSTATE=58009 
 
In your db2diag.log, you can also see this error message : 
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReadDssHdr, 
probe:20 
	MESSAGE : ZRC=0x8036008D=-2143944563=SQLJC_ERROR_SYNTAX "SYNTAX 
ERROR" 
 
 
This error happens when DRDA layer sends two buffers to IPC but 
only one is received after the client interrupts the connection 
while waiting a reply from the server.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 10.5 Fix Pack 9 or higher                     * 
****************************************************************

Connect your application directly to your DB2 server.

First fixed in Db2 10.5 Fix Pack 9

not known / see Local fix

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

19.04.2017
29.09.2017
29.09.2017

9.0.