We have same problems ...
Do not not set DB2CHECKCLIENTINTERVAL : did'nt work

What level of db2 ??
What Server Machine ???
What Application Server ??



-----Message d'origine-----
De : A Prabhakar Rao
[mailto:db2udbdba-ezmlmshield-x84781640.[Email address protected]
Envoyé : vendredi 30 septembre 2005 08:37
À : LazyDBA Discussion
Objet : DB2 Agent Expiry


Hi DBA's

We are observing some of the agents are alive for a long durations(days), even though the initiated java application has finished its job. And these agents are holding some of the locks and not releasing at all. This is causing for more deadlocks day by day.

Can any one help us what action need to be taken for avoiding db2 agents to hold locks for longer time or to kill the agents which are no longer in use. Is there any parameters setting to solve this problem.

Thanks & Regards
Prabhakar




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


***********************************
Ce message et toutes les pieces jointes (ci-apres le "message") sont confidentiels et etablis a l'intention exclusive de
ses destinataires.
Toute utilisation ou diffusion non autorisee est interdite.
Tout message electronique est susceptible d'alteration. Le Groupe France Telecom decline toute responsabilite au titre de
ce message s'il a ete altere, deforme ou falsifie.
Si vous n'etes pas destinataire de ce message, merci de le detruire immediatement et d'avertir l'expediteur.
***********************************
This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised
use or dissemination is prohibited.
Messages are susceptible to alteration. France Telecom Group shall not be liable for the message if altered, changed or
falsified.
If you are not receiver of this message, please cancel it immediately and inform the sender.
***********************************

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