Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to connect to IBM DB2 Database , i created a new connection and i put the configuration but i cannot connect to the database .
PS: I'm working on Talend Data Integration V8.0.1
here is the Error log :
Login failed. You need to modify the database settings.
java.lang.RuntimeException: com.ibm.db2.jcc.am.ko: [jcc][t4][2034][11148][4.7.85] Execution failed due to distribution protocol error which resulted in the conversation being released.
A DRDA dataflow syntax error was detected. Cause: 0x1. 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)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:317)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$75.runWithCancel(DatabaseForm.java:4556)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$75.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: com.ibm.db2.jcc.am.ko: [jcc][t4][2034][11148][4.7.85] Execution failed due to distribution protocol error which resulted in the conversation being released.
A DRDA dataflow syntax error was detected. Cause: 0x1. ERRORCODE=-4499, SQLSTATE=58009
at com.ibm.db2.jcc.am.dd.a(dd.java:321)
at com.ibm.db2.jcc.am.dd.a(dd.java:365)
at com.ibm.db2.jcc.t4.ab.l(ab.java:936)
at com.ibm.db2.jcc.t4.ab.c(ab.java:371)
at com.ibm.db2.jcc.t4.ab.v(ab.java:1139)
at com.ibm.db2.jcc.t4.bb.a(bb.java:42)
at com.ibm.db2.jcc.t4.b.m(b.java:1239)
at com.ibm.db2.jcc.t4.b.b(b.java:1113)
at com.ibm.db2.jcc.t4.b.d(b.java:700)
at com.ibm.db2.jcc.t4.b.c(b.java:686)
at com.ibm.db2.jcc.t4.b.a(b.java:375)
at com.ibm.db2.jcc.t4.b.<init>(b.java:311)
at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:214)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:224)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:199)
... 9 more
can anyone help please , thanks in advance
Hello,
What Db2jcc Driver version are you using?
It seems there is a known fix for an error with the same message as the one you reported
http://www-01.ibm.com/support/docview.wss?uid=swg1IZ07622
which recommends moving up to DB2 V9.5 fixpack 5 or above.
Best regards
Sabrina