IT20262: APPLICATIONS FAIL WITH ERROR SQL30020N "0X124C"("0100") WHEN CONNECTING THROUGH A GATEWAY
https://www.ibm.com/mysupport/s/defect/aCI3p000000kFjD/dt158090?language=en_US
-
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.
Show less
-
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 10.5 Fix Pack 9 or higher *
****************************************************************
-
First fixed in Db2 10.5 Fix Pack 9
-
Connect your application directly to your DB2 server.
Status
Closed
Programming Error - Fix provided (PER)
A fix is available
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and WindowsDB2 Version 10.5 Fix Pack 11 for Linux, UNIX, and WindowsDB2 Version 10.5 Fix Pack 10 for Linux, UNIX, and WindowsFixed Version(s) :
Subscribe
By subscribing, you receive periodic emails alerting you to the status of the known issue, along with a link to the fix after it becomes available.
Notify me when a known issue for this product changes
Manage my notifications-
Product
Db2 Linux, Unix and Windows
Software version
10.5
Document number
DT158090
Last modified
2023年8月24日 GMT+8 18:50
-
APAR Number
IT20262
Reported component id
DB2FORLUW
Reported component release
A50
Status
Closed
PTF in error
NoPE
HIPER:
NoHIPER
Special attention
NoSpecatt
-Product Specific
Submitted date:
2017年4月19日 GMT+8 11:00
Closed date:
2017年9月29日 GMT+8 11:00
Last modified date:
2023年8月24日 GMT+8 18:50
------------------------------------------------------------------------------------------
如果你觉得文章有用，欢迎打赏
-