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 ?
ODBC connection timeout error after upgrade to Linux 11
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 59
- Joined: Fri Apr 22, 2011 8:02 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.
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.
Thanks,
Madhumitha
Madhumitha