DB2 FOR LUW / DB2FORLUW / B10 - 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 11.1 Mod 3 Fix Pack 3 or higher               * 
****************************************************************

Connect your application directly to your DB2 server.

Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
 Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
 

First fixed in Db2 11.1 Mod 3 Fix Pack 3

not known / see Local fix

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

09.08.2017
19.03.2018
19.03.2018