467,201 Members | 1,017 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,201 developers. It's quick & easy.

Automatically disconnecting DB2 clients which are inactive for some time

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
  • viewed: 2821
Share:
1 Reply
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

18 posts views Thread by chris | last post: by
6 posts views Thread by Bart Nessux | last post: by
2 posts views Thread by jasonsgeiger@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.