APAR status
Closed as program error.
Error description
V9.7 Fixpak 1 client running a JDBC Type 4 application receives DRD Data Stream Syntax error. Reason: 0x2. ERRORCODE=-4499, SQLSTATE=58009. This is a boundary condition which only occurs when dealing with a large number of columns, input or output, such that the length of the SQLDARD is exactly 65518 bytes. (Two DSS where the first DSS length is X'FFFF and the second DSS length is X'7FFFF). This problem occurs with a large number of columns, such that the describe information for the columns expand exactly 2 complete, full drda blocks. ---- Begin backtrace for Nested Throwables com.ibm.db2.jcc.am.uo: [jcc][t4][2034][11148][4.8.87] Execution failed due to a distribution protocol error that caused deallocation of the conversation. A DRDA Data Stream Syntax Error was detected. Reason: 0x2. ERRORCODE=-4499, SQLSTATE=58009 at com.ibm.db2.jcc.am.gd.a(gd.java:317) at com.ibm.db2.jcc.am.gd.a(gd.java:365) at com.ibm.db2.jcc.t4.cb.l(cb.java:942) at com.ibm.db2.jcc.t4.cb.e(cb.java:324) at com.ibm.db2.jcc.t4.cb.d(cb.java:259) at com.ibm.db2.jcc.t4.fb.b(fb.java:2672) at com.ibm.db2.jcc.t4.fb.a(fb.java:2630) at com.ibm.db2.jcc.t4.fb.a(fb.java:172) at com.ibm.db2.jcc.t4.fb.b(fb.java:83) at com.ibm.db2.jcc.t4.t.b(t.java:69) at com.ibm.db2.jcc.t4.vb.c(vb.java:242) at com.ibm.db2.jcc.am.xm.mc(xm.java:2891) at com.ibm.db2.jcc.am.xm.pc(xm.java:2997) at com.ibm.db2.jcc.am.xm.vc(xm.java:3126) at com.ibm.db2.jcc.am.xm.a(xm.java:547) at com.ibm.db2.jcc.am.lb.a(lb.java:2183) at com.ibm.db2.jcc.am.lb.a(lb.java:2142) at com.ibm.db2.jcc.am.lb.prepareStatement(lb.java:1688) at com.ibm.db2.jcc.am.bf.prepareStatement(bf.java:243) at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.pmiPrepareStatement(W SJdbcConnection.java:2503)
Local fix
Problem summary
Fixed in DB2 V9.5 FP7 JDBC driver.
Problem conclusion
Upgrade DB2 JDBC driver to V9.5 FP7.
Temporary fix
Comments
APAR Information
APAR number
IC69477
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-06-29
Closed date
2014-03-26
Last modified date
2014-03-26
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
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
R950 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
26 March 2014