How to resolve DB2 JDBC Driver Data Stream Syntax Error "Execution failed due to a distribution protocol error that caused deallocation of the conversation" ?

How to resolve DB2 JDBC Driver Data Stream Syntax Error "Execution failed due to a distribution protocol error that caused deallocation of the conversation" ?

book

Article ID: KB0071770

calendar_today

Updated On:

Products

TIBCO Data Virtualization

Description

When connecting to the database, the JDBC driver returns the error below:

Execution failed due to a distribution protocol error that caused deallocation of the conversation.
A DRDA Data Stream Syntax Error was detected. Reason: 0x3.
ERRORCODE=-4499, SQLSTATE=58009

 

Issue/Introduction

Error DRDA (Distributed Relational Database Architecture) Data stream Syntax error was detected shown when trying to connect to a DB2 data source - "Execution failed due to a distribution protocol error that caused deallocation of the conversation"

Resolution

There are 2 possible reasons for this code:
1. The JDBC driver's DRDA error may be caused by a firewall preventing the application from connecting. To verify, try connecting to the same DB2 port using the hostname and DB2 port number. If it fails, please make sure the connection is allowed or try contacting your system administrator.

2. The error can also be caused if you are attempting a SSL connection and you missed providing "sslConnection=true" setting in the JDBC connection string. Set the keyword sslConnection to true to resolve this error.