APAR status
Closed as program error.
Error description
UNABLE TO INSERT/UPDATE A REMOTE BYTE/TEXT COLUMN FROM A DRDA CONNECTION While trying to do a remote insert or update of a byte column from a connection created using a DRDA alias (DSC/JCC) the connection between the client and the server gets broken. An example error from a JCC client might look something like this . Failed to perform setAsciiStream: com.ibm.db2.jcc.am.io: [jcc][t4][2030][11211][4.7.85] A communication error occurred during operations on the connection's underlying socket, socket input stream,or socket output stream. Error location: Reply.fill(). Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001 com.ibm.db2.jcc.am.io: [jcc][t4][2030][11211][4.7.85] A communication error occurred during operations on the connection's underlying socket, socket input stream, or socket output stream. Error location: Reply.fill(). Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001 at com.ibm.db2.jcc.am.dd.a(dd.java:319) at com.ibm.db2.jcc.t4.a.a(a.java:365) at com.ibm.db2.jcc.t4.a.a(a.java:360) at com.ibm.db2.jcc.t4.ab.b(ab.java:222)
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * IDS 11.10 and above * **************************************************************** * PROBLEM DESCRIPTION: * * While trying to insert/update a remote table with text/byte * * columns via DRDA connection in the following scenarios: * * * * 1. select <text/byte column> from <local table> insert * * into <remote table>; * * 2. insert into <remote table> with text/byte host * * variables binding. * * * * Communication error is reported to client and server/client * * connection is broken. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 11.50.xC8 when available. * ****************************************************************
Problem conclusion
The problem is first fixed in IDS 11.50.xC8.
Temporary fix
Comments
APAR Information
APAR number
IC68740
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-05-19
Closed date
2011-01-20
Last modified date
2011-01-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
IBM IDS ENTRP E
Fixed component ID
5724L2304
Applicable component levels
RB15 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
20 January 2011