> How can I kill all the idle Openingres sessions on the weekend before
> the weekly SYSMOD ?
> Something like an idle timeout or a process that will just knock
> everyone off, so that sysmod can have control of the database.

There are various scripts around for knocking sessions on the head, and if
memory serves (which mostly it doesn't) I think Karl Schendel has one on
the NAIUA web site somewhere.

But if what you want is an actual timeout, which I think is a good idea,
then consider connecting to iidbdb and then using GRANT IDLE_TIME_LIMIT n
ON CURRENT INSTALLATION TO PUBLIC, where n is the maximum number of seconds
before disconnecting sessions for being idle.

Roy Hann
BKB Client/Server (UK) Ltd.
http://www.bkbcs.com

Ingres Q & A

Back to William's Home Page

© William Yuan 2000

Email William