Re: Killing off client threads

It seems to me that a proper solution to this problem requires processes on each machine (client and server) that talks to each other and sends keep alive packages of some sort while the client is idle. The ODBC driver on the client machine should either know when the client has crashed, or more likely crash with the client. There need to be a special server side process that keeps sending keep alive packages to the client. If there is no responce (or a responce that the client program crashed) this server process could gracefully disconnect from the database and terminate any server side processes. Open transactions would of course be rolled back. This type of setup should be easy to implement within ODBC drivers where a part of it runs on the server (like OpenLink, SQL Retriever and others). We should simply have to tell the driver writers about this requirement and they should deliver it within a reasonably short time. I actually think they will. That's the way the world can work and should work. Informix should of course implement the same functionallity within I-Net, but I would expect that to take some time. ammist@io.com (The Mist) wrote: :Hello - : I've been following the discussion about idle client threads for :the past couple of days because I'm having a similar problem. I'm using :ODBC to connect to Informix 7.12 and occasionally, the driver does not :release the connection when my client program crashes. I'm using :Intersolv's DataDirect drivers for Informix 5 on an NT machine. I'm :trying to get updates to happen using transactions, and occasionally the :client crashes. When this happens, the database rows end up being locked :and I have to restart the on-line server to flush the connections. : Obviously there should be a way to just disconnect all of the :clients and unlock those rows. Our soon-to-be DBA is off getting trained :this week, but I'm getting tired of bringing things up and down every time :I run into a bug in the client code. Can one of you send me the simple :unix command that will let me disconnect idle users? Nils.Myklebust@idg.no <- New E-mail adress NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company