By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,649 Members | 2,154 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,649 IT Pros & Developers. It's quick & easy.

Execution failed due to a distribution protocol error that caused deallocation of the conversation

P: n/a
hi,

we are using db2 udb v8.1 on win 64 bit with fp3 with type 4
db2jcc.jar driver.

i have this problem happened sometimes when try to execute a query and
failed.

com.ibm.db2.jcc.a.DisconnectException: Execution failed due to a
distribution protocol error that caused deallocation of the
conversation. A DRDA Data Stream Syntax Error was detected. Reason:
0x3

does any one know what does that mean?
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I would interpret such as message as meaning that you should open a PMR.
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
hi,

we are using db2 udb v8.1 on win 64 bit with fp3 with type 4
db2jcc.jar driver.

i have this problem happened sometimes when try to execute a query and
failed.

com.ibm.db2.jcc.a.DisconnectException: Execution failed due to a
distribution protocol error that caused deallocation of the
conversation. A DRDA Data Stream Syntax Error was detected. Reason:
0x3

does any one know what does that mean?

Nov 12 '05 #2

P: n/a
I don't suppose you are calling a stored procedure with MRSP resultset,
are you? I remember there was a known apar about JCC drivers and stored
procedure returning resultset.

Mark Yudkin wrote:
I would interpret such as message as meaning that you should open a PMR.
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
hi,

we are using db2 udb v8.1 on win 64 bit with fp3 with type 4
db2jcc.jar driver.

i have this problem happened sometimes when try to execute a query and
failed.

com.ibm.db2.jcc.a.DisconnectException: Execution failed due to a
distribution protocol error that caused deallocation of the
conversation. A DRDA Data Stream Syntax Error was detected. Reason:
0x3

does any one know what does that mean?



Nov 12 '05 #3

P: n/a
I'd rather believe this is a jcc jdbc driver bug. You need to contact IBM.

If this is not production system, You can use app jdbc driver to
temporarily replace jcc jdbc driver to bypass the error. Because app
driver is not type-4 jdbc driver, you have to configure the db2 client
first.
Using app jdbc driver will also solve the problem - error code 99999 - You
posted to this newsgroup before.

Regards,
FRX

xixi wrote:
hi,

we are using db2 udb v8.1 on win 64 bit with fp3 with type 4
db2jcc.jar driver.

i have this problem happened sometimes when try to execute a query and
failed.

com.ibm.db2.jcc.a.DisconnectException: Execution failed due to a
distribution protocol error that caused deallocation of the
conversation. A DRDA Data Stream Syntax Error was detected. Reason:
0x3

does any one know what does that mean?


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.