FW: Killing Idle Client Sessions

---------- From: Jane Vohden Sent: Friday, September 13, 1996 9:22 AM To: 'Ted Martinez' Subject: RE: Killing Idle Client Sessions Ted - Would you mind sending me a copy of your script, please? It sounds like something we could use here. Thanks. Jane Vohden, Database Administrator Fairbanks North Star Borough jvohden@co.fairbanks.ak.us ---------- From: Ted Martinez[SMTP:tedm@vcd.hp.com] Sent: Thursday, September 12, 1996 10:23 AM To: informix-list@rmy.emory.edu Subject: Re: Killing Idle Client Sessions Jeff Craig (settler@hobbes.dbintellect.com) wrote: : Does anyone know how to determine whether a database connection from : a desktop client application to an Informix database server through : an OpenLink (ORB) ODBC is an idle/inactive connection? I want to : onmode -z idle connections to free up resources for active users. : ------------------------------------------------------------------- : Jeff Craig | dbINTELLECT Technologies, Inc. : ------------------------------------------------------------------- Jeff, this is kind of an indirect answer to your question; We have a script that cron runs every hour or so, that checks for ODBC connections that are older than 6 hours and get's rid of 'em. We also check for ip's that have more than 4 connections at any time, blow the earliest one away... I know our method seems a little heavy handed, but we rationalize it with the thought that if they *really* have a query/job that's been running for that amount of time, then we need to talk about what there trying to do... tedm:-) Ted Martinez CIM Hewlett Packard (VCD) Factory Information