Automatically disconnecting DB2 clients which are inactive for some time

Rahul B

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

Aug 28 '07 #1

kavallin

Rahul.. check db2gov, search for it here
http://publib.boulder.ibm.com/infoce.../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

Aug 28 '07 #2