Hi,
I have a situation where many people will be connecting to DB2 through
various clients and applications.
Since people just connect to the Database through a client and leave
it as it is, the connections become more(even if he doesn't query
anything).
I want to disconnect all the client who remain idle for a specific
time so that they have to connect again.
Is there a way in which DB2 supports this?
Thanks
Rahul
kavallin@hotmail.com - 28 Aug 2007 09:18 GMT
Rahul.. check db2gov, search for it here
http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp. One of
the options in db2gov is :
idle nnn
Specifies the number of idle seconds allowed for a connection
before a specified action is taken. If you specify -1, the
connection's idle time is not limited.
/Roger