We too have seen this on DB2 Connect on Linux for zVM. We see orphaned agents on the gateway side. The Windows client machine shows the associated PID is dead, but the gateway still keeps the agent alive doing nothing for long time.
-----Original Message-----
From: A Prabhakar Rao [mailto:db2udbdba-ezmlmshield-x69936754.[Email address protected]
Sent: Friday, September 30, 2005 2:08 AM
To: LazyDBA Discussion
Subject: Re: DB2 Agent Expiry
We are using DB2 8.1.5
Linux AS 2.1
Websphere 5.0.1
Thanks & Regards
Prabhakar
----- Original Message -----
From: "LA RESERVE S Ext ROSI/DOSI " <slareserve.[Email address protected]
To: <[Email address protected]
Sent: Friday, September 30, 2005 12:22 PM
Subject: RE: DB2 Agent Expiry
> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email, **and removed
> any attachments, and kept your email address secret **from this
> person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address
> as
normal
> **Anything below this line is the original email text
>
>
>
> 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
> [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.
> ***********************************
>
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page