Re: Time out function utility for Applications

Chris Miller

Re: Time out function utility for Applications
(in response to Nash Gupta)
If you're running on unix or NT, you can use the DB2 govenor to force
applications off the database (or re-nice them) based on various events (i.e.
exceeded a max CPU time, clock time, etc.) We use the govenor for very basic
monitoring. It is not the most graceful/elegant thing I've ever seen, but seems
to work ok. You don't hear much about it. It doesn't have a GUI interface and
isn't well integrated into DB2 like other things are. You can, however, find
info in the admin guide about it.

I don't know about OS/390 if that's the platform you are referring to. I'm sure
there must be something like it.



Nash Gupta

Time out function utility for Applications
Hello List!

Is there any parameter/function/utility in DB2 whereby an application could
be terminated after a specfic time.
For example: Lets say I want to terminate all applications which are
connected to the database but have not been used since last 2 hrs. May
be somebody just forgot to log off. Is it possible to log off such an app
automatically.

Thanks!
- Nash



Viswanathan N

Re: Time out function utility for Applications
(in response to Chris Miller)
If you are talking about online transaction applications . Then CICS has a
parameter in the SIT which can specify a logoff after specific amount of
idle time.

Vishy



Frank D Marchese

Re: Time out function utility for Applications
(in response to Viswanathan N)
Check out the Admin Guide Vol 2, p 5-122 and 123. It's not exactly what you
describe
but maybe it's better than nothing. I'm just not sure if the manual is
describing distributed threads only or not.

-----Original Message-----
From: Nash Gupta [mailto:[login to unmask email]
Sent: Monday, January 03, 2000 6:57 PM
To: [login to unmask email]
Subject: Time out function utility for Applications


Hello List!

Is there any parameter/function/utility in DB2 whereby an application could
be terminated after a specfic time.
For example: Lets say I want to terminate all applications which are
connected to the database but have not been used since last 2 hrs. May
be somebody just forgot to log off. Is it possible to log off such an app
automatically.

Thanks!
- Nash