In article <c6c28b7a1b8042ffdb385bf67f8234f9
@localhost.talkaboutdatabases.com>, JKCGI (jf****@comcast.net)
says...
Description of the DB2 Connect problem:
Users of two LTC client-server applications are experiencing intermittent
disconnects from the mainframe. Users of the Retail Workflow application
and the Group LTC Care application are experience SQL errors after
attempting to execute a transaction after leaving the application idle for
approx. 30 minutes.
The WLTC application architecture was "cloned" from GLTC Care. The
architecture is as follows:
PowerBuilder 9.0 GUI running on an NT client
DB2 Connect 8.1 gateway for connectivity to the mainframe
DB2 on MVS database
DB2 Stored procedure using MVS Cobol modules in composite link for the
business logic
Communication uses ODBC ---> DB2 CLI ---> TCP/IP ---> DB2 Connect
gateway ---> MVS DB2 on the mainframe
The TCP error 1127 as displayed in your messages means a connection
timeout error. This looks like a TCP/IP configuration problem. I'm
not a TCP/IP expert but the Keep-alive interval might be worth
checking.