|
Problem IC69459
|
Status: Closed |
UNIVERSAL JDBC TYPE 4 APPLICATION RECEIVES ERROR. A DRDA DATA STREAM SYNTAX ERROR WAS DETECTED. REASON: 0X2. ERRORCODE=-4499 |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem 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) |
| Problem Summary: |
Users Affected: All using JDBC Type 4 drivers
Problem 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 problem occurs with a large number of columns, such that
the describe information for the columns expand exactly 2
complete, full drda blocks.
Problem Summary:
Problem Description:
V9.7 Fixpak 1 client running a JDBC Type 4 application receiv
DRD Data Stream Syntax error. Reason: 0x2. ERRORCODE=-4499,
SQLSTATE=58009.
This problem occurs with a large number of columns, such that
the describe information for the columns expand exactly 2
complete, full drda blocks. |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem first fixed in DB2 UDB Version 9.7 Fix Pack 3. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC69477
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.06.2010
04.10.2010
04.10.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
