Re: Problems with ODBC Drivers

billy.wheeler@digitec.co.za wrote: >-> I am having problems with orphan sqlturbo processes left after a failure on >-> the client. I there anyway of trapping drop outs of clients on the server >-> and removing the sqlturbo process. > [...snip...] > Write a shell script to do the following > >1. ps -ef | grep sqlturbo | grep -v grep > >2. Pipe this to awk to see if the value in the PPID column is 1, and if so >tbmode -z the value in the PID column. > >I stand, as ever, under correction, and assume no responsibility for the >destruction of your database if this doesn't work! :) >[...snip...] There is already a facility within TCP/IP called KEEPALIVE which should be looking after these connections. By default KEEPALIVE does nothing for 2 1/2 hours after which it should kick into action and sort things out correctly. KEEPALIVE does involve an in-depth change on your UNIX side. If you want more info mail me. (or look back in your history of these messages - about 2 weeks ago (i think) there were a few more detailed messages about this very thing). -- Mark Bradshaw (not) not@hoople.demon.co.uk