DB2: DRDA Data Stream Syntax Error was detected.

[JDansena1661944160]

I am to connect db while creating connection.

when trying to execute job then connection is failed not able to connect to IBM db2 not sure

Database connection is failed.

 java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientException: [jcc][t4][2034][11148][4.9.78] 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

   at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:208)

   at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1170)

[Tins1980]

I faced similar kind of issue last time, I am still searching for some proper solution.

[JDansena1661944160 · Accepted solution]

Fixed above issue, problems was while connecting through connection then connection was success but while execute with component time it not going to connect to DB that is the problems.

Solution: try to create JDBC connection and add jar after that we can use that connection on component.

Component level