AS400 Enterprise server with Windows batch server - timeout issues

markdcci

markdcci

Owner - Rockford Consulting LLC
Hello List,

We recently upgraded our firewall between our System I /AS400 and the rest of our network. Although I'm told there was no explicit change to the firewall's timeout settings, We are nonetheless seeing timeouts now between the Windows server and the AS400 that we did not see before. They manifest themselves in the Windows server logs as:

4252/1976 MAIN_THREAD Mon Sep 07 02:14:49.195000 ODBCLOG.C436
ODB0000162 - Connection lost during earlier operation.

4252/1976 MAIN_THREAD Mon Sep 07 02:14:49.195001 ODBCLOG.C436
ODB0000162 - Connection lost during earlier operation.

4252/1976 MAIN_THREAD Mon Sep 07 02:14:49.195002 jdbodbc.C8402
ODB0000163 - wSQLPrepare failure. rc=-1

4252/1976 MAIN_THREAD Mon Sep 07 02:14:49.195003 jdbodbc.C8402
ODB0000164 - STMT:00 [08S01][8413][2] [IBM][System i Access ODBC Driver]Communication link failure. comm rc=8413 - CWBCO1054 - A user-specified time-out occurred while sending or receiving data

4252/1976 MAIN_THREAD Mon Sep 07 02:14:49.195004 JDB_DRVM.C1143
JDB9900401 - Failed to execute db request

4252/1976 MAIN_THREAD Mon Sep 07 02:14:49.195005 JTP_CM.C1347
JDB9900255 - Database connection to F00941 (System - 900) has been lost.



Sometimes the connection re-establishes itself and sometimes it fails. We have checked the timeout on the AS400 and it is set to 2 hours. The firewall is set to 2 hours fifteen minutes. We have added a registry setting to the Windows server to set a TCP keep alive at 30 minutes, with no effect.

Our scheduled jobs are now sometimes failing, although not always. Anyone have any ideas on how to correct it? I am thinking I need to decrease the timeout on the Windows server, in the OS or in the jde.ini to have the Windows server time out before the firewall, but I haven't been able to find that as of yet.


AS400 7.1 Enterprise Server
Windows 2008 R2 Batch Server
EOne 9.0
Tools Release 8.98.4.11
 
Back
Top