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



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