Re: Dead Clients with SQL*Net and TCP/IP
Date: 1995/09/05
Message-ID: <42go0k$8pt_at_news2.noc.netcom.net>#1/1
Andy Chan <chanandy_at_hk.super.net> wrote:
>
>
> Well you've have a RS6000 and I don't know whether it'll work for you.
> But I think the concept goes the same.
>
no it won't
> Don't believe the SQL*Net parameters can help you -- the "timeout"
> parameter doesn't really mean what it named. Instead, we tackle the TCP
amen to that.
..
> This method imply reconfiguration of the kernel. A reload of server may
> be required. (Solaris is an exception of this criteria.)
>
bing! sorry but you don't do kernel rebuilds on aix.
i cheated, i wrote a 5 line script that looked for dead connections, found the process numbers, killed the process and then went to sleep for a bit. ok ok maybe it was 6 lines, i forget. obtw this will not always work sometimes you need to reboot to clear the socket. sorry but i don't know whose fault it is. but if the code is as fine a quality as the oracle install's ...... ;-)
bill pociengel Received on Tue Sep 05 1995 - 00:00:00 CEST