RE: Sample script to kill the idle threads in DB2

RE: Sample script to kill the idle threads in DB2

 

  

Well, well, well!
It's ravi! Hehe. How have you been? The link below may beo fo help
to you! Hehe.


http://www.ibm.com/developerworks/db2/library/techarticle/dm-0710gupta/i
ndex.html


Partyyyyyyyyy! Hehe.

Have a great Day!






Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: ravi
[mailto:db2udbdba-ezmlmshield-x54782274.[Email address protected]
Sent: Monday, October 29, 2007 5:56 AM
To: LazyDBA Discussion
Subject: 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