ODBC connection timeout error after upgrade to Linux 11

ruf888 · Post by **ruf888** » Fri Oct 12, 2012 12:12 am

Hi, All

we upgraded our operation server SUSE Linux from version 10 to 11. After that our parallel jobs which use ODBC connections to write to DB2 tables get the message ODBC function "SQLConnect" reported: SQLSTATE = HYT00: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver]Timeout expired. (CC_OdbcConnection::connect, file CC_OdbcConnection.cpp, line 440).

The error happens if we run several jobs in sequence, one of the jobs aborted with the timeout error, but if I start the aborted job itself, then it finishs without error.

Can somebody help ?

chulett · Post by **chulett** » Fri Oct 12, 2012 6:38 am

That kind of thing always screams 'resource issue' to me. Have you talked to your SysAdmin and/or DBA about it? Perhaps some settings need to be bumped up.

ruf888 · Post by **ruf888** » Fri Oct 12, 2012 8:32 am

actually I solved the problem. I setted the auto commit in ODBC property to on, then it works

chulett · Post by **chulett** » Fri Oct 12, 2012 9:38 am

That sounds more like a 'workaround' to me and doesn't really address the root of the problem, especially if you didn't have that on before. But... ok.

Madhumitha_Raghunathan · Wed Jul 15, 2015 10:34 am

Hi,

We are facing the same issuse when multiple inctances of the same job runs, one instance fails. We have the auto commit set to off and it used to run fine. After the servers were relocated, we are facing this issue.

Also the job is failing in 16 seconds when we are trying to load just 1 record.

Will be grateful if anyone has any suggestions on resolving this.

chulett · Post by **chulett** » Wed Jul 15, 2015 12:40 pm

You really should start your own topic in situations like this. Make sure we have all of your particulars including your actual error message. Please.