Unable to connect with DB2 data source from TDM portal

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Getting below issue when tried to connect to the DB2 database.

[jcc][t4][2034][11148][4.33.31] 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

Environment

TDM Portal 4.11.127

DB2 for LUW

Cause

The issue was caused due to missing sslConnection parameter.

Resolution

The reported error could be due to firewall issue between TDM Portal machine and DB2 server. It could also be due to missing SSL paramter.

Providing additional parameter sslConnection=true resolved the issue.

For more details refer below IBM link:

https://www.ibm.com/support/pages/faq-jdbc-driver-data-stream-syntax-error