Re: Hanged INFORMIX connections

Hi, right, TCP-KeepAlive should do that (according to its configuration, which by default is not 300 seconds but 2 hours). Alternatively you can put the plug of the network cable back in and everything should be fine as if never anything happened, as long as the client application process is still there that is. This is a "great feature" of TCP/IP, will work with normal telnet/rlogin etc. sessions as well and will get the security paranoids amongst us up on the highest palm tree in sight ... ;-) Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 11.04.2005 19:42:11: > Rafael Padilla wrote: > > Hi all, > > > > I realized that client connections to INFORMIX remained open if You > > accidentally remove network cable; it's just to give an example. Other > > kind of similar event did same thing. > > > > How can you monitor a connection to Informix with this problem? > > When I reviewed user threads with onstat -u or onstat -g ses, They > > seems to be in normal conditions, but they were lost for conditions as > > I described above. > > > > Any tip? > > > > I got a SUN Box and IDS 9.40 FC3 > > > > Thanks in advance! > > I would have thought that the network settings for TCP_KEEPALIVE would > kick in after a while (300 seconds and then the retry period and number > of times I think is the default); then they would be "cleanly tidied up" > because the connection would get a signal. sending to informix-list