Connection Timeout Problemmmmmmmm...

[_AnonymousUser]

Hi All,
I am trying to migrate the data from flat file to DB2 using Talend.
Following Components are used:
Tmap
TDb2output.
The problem i have is connection timeout on db2 server side.
There is no error.
Error message by Talend:
*********************************************************************************
Exception in component tDB2Input_1
Exception in component tDB2Input_1
Exception in component tDB2Input_1
com.ibm.db2.jcc.a.DisconnectException: java.net.ConnectException : Error opening socket to server BLREQR2008/129.1.32.16 on port 50000 with message : Connection timed out: connect DB2ConnectionCorrelator: null
at com.ibm.db2.jcc.b.fc.a(fc.java:371)
at com.ibm.db2.jcc.b.fc.<init>(fc.java:66)
at com.ibm.db2.jcc.b.a.v(a.java:254)
at com.ibm.db2.jcc.b.b.a(b.java:1792)
at com.ibm.db2.jcc.a.p.<init>(p.java:936)
at com.ibm.db2.jcc.b.b.<init>(b.java:324)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:165)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at datamigration.savtodb2_gld0data.SAVTODB2_GLD0DATA.tDB2Input_1Process(SAVTODB2_GLD0DATA.java:10877)
at datamigration.savtodb2_gld0data.SAVTODB2_GLD0DATA.tFileInputPositional_1Process(SAVTODB2_GLD0DATA.java:1542)
at datamigration.savtodb2_gld0data.SAVTODB2_GLD0DATA.tJava_1Process(SAVTODB2_GLD0DATA.java:10559)
at datamigration.savtodb2_gld0data.SAVTODB2_GLD0DATA.main(SAVTODB2_GLD0DATA.java:12837)
********************************************************************************************
Question : how can i increase the connection timeout on Talend site or i do have to do on db2 server side.
this problem is very frequent.
plzzzzzz help me out....

[_AnonymousUser]

yes.. i am also facing the same problem..
if the db2 server is on the local machine, then we dont get this error..
if the server is on the different machine, then we get this error very frequently..
is this the problem with TALEND or with DB2?
my second question is why do we need seperated connection for each DB2Out ??cant we have one connection for all output tables?

[Anonymous]

Hi
about the first question, we have tested DB2 components to connect to different machine and they run fine, so I think it's depend on your machine or connection timeout. you can try to change your timeout on DB2 server.

why do we need seperated connection for each DB2Out ??cant we have one connection for all output tables?

we have created the connection component for the main databases, such as: tMySQLConnection, about this kind component for DB2, please report a new features in our bugtracker.
Thanks for your support !
Best regards

shong

[Anonymous]

Hi,
Can anyone tell me the steps for importing data from csv file to our database in talend profiler.
thnaks
leena

[_AnonymousUser]

I am facing same exception though i am using tMySqlConnection component .I am trying to connect to remote server and session is getting removed

[_AnonymousUser]

Please help me with the solution to the session time out problem uasing Talend

[janhess]

I found this info. Don't know if it helps at all.
http://publib.boulder.ibm.com/infocenter/tamit721/v7r2m1/index.jsp?topic=/com.ibm.license.mgmt.probd...
The connection with the database cannot be established despite the fact that the values specified for the tlmsrv user, host name and port number are correct. The <temp_dir>/tad4d721/Server.log contains the following error message: A SQLException caught: java.net.ConnectException : Error opening socket to server <db2_host> on port <db2_port> with message : Connection timed out DB2ConnectionCorrelator: null.
Try to connect to the database using the DB2 client to find out more about the problem.

Also found info suggesting you need to use a DB2 type 4 driver.

[_AnonymousUser]

How about the issue i am facing using the tMySqlConnection.
I observed that after a period of time database connection session is lossed.
Please suggest

[Anonymous]

Please help I'm getting this error message..
Exception in component tMysqlInput_11
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 1,148 milliseconds ago. The last packet sent successfully to the server was 421,259 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3589)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3478)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4019)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1929)
at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDynamic.java:417)

[Anonymous]

Hi rockysree
Search forum topics with key word "Communications link failure", you will find many similar topics, that provide the possible causes and solutions.
Shong