You should investigate the use of the DB2GOV command.
The governor allows you to set a configuration File where you specify:
Set idle time 1800 action force;

You decide with the interval how often you want the governor to wake up, say
every 300 seconds
It will then force all idle connections that are over 1800 seconds.
Regards, Pierre.


-----Message d'origine-----
De : ravi [mailto:db2udbdba-ezmlmshield-x54782274.[Email address protected]
Envoyé : 29 octobre 2007 05:56
À : LazyDBA Discussion
Objet : Sample script to kill the idle threads in DB2

Hello Guru's

Please can you send me any sample script on unix/aix to kill the idle
threads in db2.

I want to schedule a script which runs every 3 hours, which kills all idel
threads (hanging for more than 30 minutes in DB2)


Thanks
Ravi.

Disclaimer: This communication is for the exclusive use of the intended
recipient(s) and shall not attach any liability on the originator or ITC
Infotech India Ltd./its Holding company/ its Subsidiaries/ its Group
Companies. If you are the addressee, the contents of this e-mail are
intended for your use only and it shall not be forwarded to any third
party, without first obtaining written authorization from the originator or
ITC Infotech India Ltd./ its Holding company/its Subsidiaries/ its Group
Companies. It may contain information which is confidential and legally
privileged and the same shall not be used or dealt with by any third
party in any manner whatsoever without the specific consent of ITC
Infotech India Ltd./ its Holding company/ its Subsidiaries/ its Group
Companies.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page