Re: Killing Idle Client Sessions

In a message dated 96-09-12 19:27:10 EDT, you write: << 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 >> Jeff: Check out the simple onstat -g sql,.. and look for the "F.E. Ver" column, which may help to to differentiate between the sql sources.. Thanx, Vikram