Talend - IBM DB2 connection failure

ARavi1653219680 — Fri, 15 Nov 2024 22:54:12 GMT

Hi Team

I am using Talend open studio 8.1, I had created Metadata DB2 connection and while testing connection I am getting the error shown below.

Can some help me here?

Connection failure. You must change the Database Settings.

java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.14.111] Exception java.net.SocketTimeoutException: Error opening socket to server tsoc/147.179.190.117 on port 446 with message: Connect timed out. ERRORCODE=-4499, SQLSTATE=08001

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

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

at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)

at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)

at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:3983)

at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.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.util.concurrent.FutureTask.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.14.111] Exception java.net.SocketTimeoutException: Error opening socket to server tsoc/147.179.190.117 on port 446 with message: Connect timed out. ERRORCODE=-4499, SQLSTATE=08001

at com.ibm.db2.jcc.am.ed.a(ed.java:320)

at com.ibm.db2.jcc.am.ed.a(ed.java:338)

at com.ibm.db2.jcc.t4.vb.a(vb.java:434)

at com.ibm.db2.jcc.t4.vb.<init>(vb.java:93)

at com.ibm.db2.jcc.t4.a.b(a.java:354)

at com.ibm.db2.jcc.t4.b.newAgent_(b.java:2030)

at com.ibm.db2.jcc.am.Connection.initConnection(Connection.java:731)

at com.ibm.db2.jcc.am.Connection.<init>(Connection.java:680)

at com.ibm.db2.jcc.t4.b.<init>(b.java:334)

at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:232)

at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:198)

at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:475)

at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:116)

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:186)

... 9 more

Caused by: java.net.SocketTimeoutException: Connect timed out

at java.net.SocksSocketImpl.readSocksReply(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at com.ibm.db2.jcc.t4.v.run(v.java:49)

at java.security.AccessController.doPrivileged(Native Method)

at com.ibm.db2.jcc.t4.vb.a(vb.java:420)

... 21 more

Re: Talend - IBM DB2 connection failure

Anonymous — Mon, 23 May 2022 07:45:47 GMT

Hi Ravi,

Does the same credentials work outside talend from the same studio machine? Can you please try connecting to the same DB from tDBconnection component?

Re: Talend - IBM DB2 connection failure

ARavi1653219680 — Sun, 31 Jul 2022 12:45:05 GMT

Thanks. It's firewall issue, I solved it.

topic Re: Talend - IBM DB2 connection failure in Talend Studio

Talend - IBM DB2 connection failure

Re: Talend - IBM DB2 connection failure

Re: Talend - IBM DB2 connection failure