Re: Clients remaining locks when connection to server is broken
Posted in 1998
In article <3603b1bc.105461075@news.siemens.at>,
johann.luczanich@siemens.at wrote:
> Hi Comrades,
>
> how can I kill automatically (I know onmode -z) sessions remained by
> clients (e.g. MS-Query, ...) that lost connection to a server,
> for example, PC users shut off the power
> without first exiting from the client application ???
>
> Who has experience with the Keep-Alive Option (fifth column in
> sqlhosts) ???
>
> MfG luczanich
>
Hi I had a similar problem to this and tried using the k=n option as well.
However, I found that tuning kernel tcp parameters was more effective. I
don't if you're able to do this on your platform but on Solaris the ndd
command is the way to go. Needless to say but extreme caution should be
exercised when changing this stuff.
--
# Matt Pierce
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum