From: Shaun.Racine@intier.com
Date: Tue Mar 04 2003 - 07:00:30 EST
Hi all,
We have an Ingres database running on several independent servers using
Tru64 v4.0E or v5.1A, all non-clustered. There is an occasional problem
with client side (Win-NT) applications stopping in such a way they don't
close the connection to the DB server (for instance, if power fails to
client PC, app crashes etc).
CA-Ingres support have suggested reducing tcp_keepidle to 300, and
tcp_keepintvl=15. Which I have tested on our development server and work
as required (dbms server disconnects timed out sessions gracefully).
Before I make these changes to our live servers, are there any 'gotchas' to
consider, or unexpected side-effects?
Info: All users connect to their local Unix server over a local area
network or access via a kilostream link, with some occasional dial-in via
Windows RAS connection.
TIA
Shaun Racine
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:49:09 EDT