Db2 connection issue with Talend Open Studio 6.4

Anonymous — Fri, 30 Aug 2019 02:27:34 GMT

Dear Team,

I am using Talend Open Studio 6.4 and had created Metadata DB2 connection successfully and able to read the data in designed jobs successfully.

With a Gap of 30 days again i tried to reconnect and giving errors. I tried to connect using other tools and able to connect successfully.

Please help me how to resolve the issue. Please find the below log for the reference

Log:

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

Thanks,

Suresh

Re: Db2 connection issue with Talend Open Studio 6.4

Anonymous — Fri, 30 Aug 2019 04:37:52 GMT

Also I tried creating DB connection inside job using tDb2Connection with same values and able to connect to Database.

Kindly help to fix issues for MetaData DB connection issue .

Thanks,

Suresh V.

Re: Db2 connection issue with Talend Open Studio 6.4

Anonymous — Mon, 06 Apr 2020 09:58:21 GMT

Hi

Did you fix this problem ?

topic Re: Db2 connection issue with Talend Open Studio 6.4 in Talend Studio

Db2 connection issue with Talend Open Studio 6.4

Re: Db2 connection issue with Talend Open Studio 6.4

Re: Db2 connection issue with Talend Open Studio 6.4