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....

[Anonymous]

I can confirm, the tDB2 components works well even if the DB2 server is not the on the same machine. The mentioned error is a misconfiguration in the server or in the connection properties.

[Anonymous]

Thank you guys, I will check on the suggestions, Thanks again

[_AnonymousUser]

Bonojur
Quand j'exécute, mon job talend, je reçois l'erreur suivante :
Exception in component tDB2Input_3
com.ibm.db2.jcc.a.DisconnectException: java.net.BindException : Error opening socket to server VMERMAC/56.45.118.86 on port 50000 with message : Address already in use: 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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at cocpit_homol.alimentation_lot1_tables_base1_si_0_1.Alimentation_lot1_tables_base1_SI.tDB2Input_3Process(Alimentation_lot1_tables_base1_SI.java:13649)
at cocpit_homol.alimentation_lot1_tables_base1_si_0_1.Alimentation_lot1_tables_base1_SI.tDB2Input_1Process(Alimentation_lot1_tables_base1_SI.java:8275)
at cocpit_homol.alimentation_lot1_tables_base1_si_0_1.Alimentation_lot1_tables_base1_SI.runJobInTOS(Alimentation_lot1_tables_base1_SI.java:14019)
disconnected
at cocpit_homol.alimentation_lot1_tables_base1_si_0_1.Alimentation_lot1_tables_base1_SI.runJob(Alimentation_lot1_tables_base1_SI.java:13866)
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.tRunJob_1Process(JOB_DWH_MASTER.java:963)
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.tRunJob_19Process(JOB_DWH_MASTER.java:842)
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.runJobInTOS(JOB_DWH_MASTER.java:4521)
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.main(JOB_DWH_MASTER.java:4362)
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.tRunJob_1Process(JOB_DWH_MASTER.java:982)
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.tRunJob_19Process(JOB_DWH_MASTER.java:842)
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.runJobInTOS(JOB_DWH_MASTER.java:4521)
at cocpit_homol.job_dwh_master_0_1.JOB_DWH_MASTER.main(JOB_DWH_MASTER.java:4362)
Job JOB_DWH_MASTER terminé à 12:31 12/09/2014.
est ce que quelqu'un peut m'aider ?
Merci 

[Anonymous]

Hi ilhamiss,
This is an international forum and English is the language we use. Posting in English will allow you to get more visibility and more help. Thanks for your understanding!

Exception in component tDB2Input_3
com.ibm.db2.jcc.a.DisconnectException: java.net.BindException : Error opening socket to server VMERMAC/56.45.118.86 on port 50000 with message : Address already in use: connect  DB2ConnectionCorrelator: null

For your issue, is port 50000 (the default DB2 port)  the right one? Can you connect to DB2 server without using Talend Tool? Please verify that the credentials you've used in the component are right.
Best regards
Sabrina

[Anonymous]

I work every week since 3 years with Talend and DB2 and it works well. This problem is definitely not caused by Talend because at this time the JDBC driver tries to establish the connection and this functionality is not changed or manipulated by Talend Studio. 
I guess you are unable to establish a connection with any other JDBC based database tool like SQLDeveloper or SQuirrel or DBVisualizer etc.
Please post us the connection properties.