Cancel DDF Thread

Francis Leblanc

Cancel DDF Thread
Hi Everyone!

We have a DDF thread that we're having trouble canceling. It does not appear to respond to the cancel command. Does anyone know of another way to kill this?

Thanks,

Fritz

Lance D Ziegler1

Re: Cancel DDF Thread
(in response to Francis Leblanc)


Fritz,

If the thread will not exit the system, perhaps it is waiting on something external.  Check the DBM1 JES2LOG to see if you are in allocation for a dataset.  Check the output in a -DIS THD(SERVER) DETAIL command ... what is the status of the thread?  Is the thread hung up in a WLM-controlled stored procedure ... or is the thread queued, for example?   American Express made the following annotations on Thu Jan 03 2008 15:52:41 ------------------------------------------------------------------------------ "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you." American Express a ajouté le commentaire suivant le Thu Jan 03 2008 15:52:41 Ce courrier et toute pièce jointe qu'il contient sont réservés au seul destinataire indiqué et peuvent renfermer des renseignements confidentiels et privilégiés. Si vous n'êtes pas le destinataire prévu, toute divulgation, duplication, utilisation ou distribution du courrier ou de toute pièce jointe est interdite. Si vous avez reçu cette communication par erreur, veuillez nous en aviser par courrier et détruire immédiatement le courrier et les pièces jointes. Merci. ****************************************************************************** -------------------------------------------------------------------------------
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services

Francis Leblanc

Re: Cancel DDF Thread
(in response to Lance D Ziegler1)
Hi Lance!

The task is not waiting for anything. But it is gobbling up CPU at a rapid rate. We suspect that it is in a loop of some kind but have not been able to kill it yet. We've not been able to contact the user either.

Thanks,

Fritz

>>> Lance D Ziegler1 <[login to unmask email]> 01/03/08 5:55 PM >>>



Fritz,

If the thread will not exit the system, perhaps it is waiting on something external. Check the DBM1 JES2LOG to see if you are in allocation for a dataset. Check the output in a -DIS THD(SERVER) DETAIL command ... what is the status of the thread? Is the thread hung up in a WLM-controlled stored procedure ... or is the thread queued, for example? American Express made the following annotations on Thu Jan 03 2008 15:52:41 ------------------------------------------------------------------------------ "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you." American Express a ajouté le commentaire suivant le Thu Jan 03 2008 15:52:41 Ce courrier et toute pièce jointe qu'il contient sont réservés au seul destinataire indiqué et peuvent renfermer des renseignements confidentiels et privilégiés. Si vous n'êtes pas le destinataire prévu, toute divulgation, duplication, utilisation ou distribution du courrier ou de toute pièce jointe est interdite. Si vous avez reçu cette communication par erreur, veuillez nous en aviser par courrier et détruire immédiatement le courrier et les pièces jointes. Merci. ****************************************************************************** -------------------------------------------------------------------------------
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services
This E-Mail has been scanned for viruses.

Lance D Ziegler1

Re: Cancel DDF Thread
(in response to Francis Leblanc)


Fritz,

In the DB2z V8 Command Reference, check the section titled "Using TCP/IP Commands to Cancel TCP/IP Distributed Threads".
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsncrj14/3.8.5?SHELF=&DT=20061204114126

American Express made the following annotations on Thu Jan 03 2008 16:21:54 ------------------------------------------------------------------------------ "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you." American Express a ajouté le commentaire suivant le Thu Jan 03 2008 16:21:54 Ce courrier et toute pièce jointe qu'il contient sont réservés au seul destinataire indiqué et peuvent renfermer des renseignements confidentiels et privilégiés. Si vous n'êtes pas le destinataire prévu, toute divulgation, duplication, utilisation ou distribution du courrier ou de toute pièce jointe est interdite. Si vous avez reçu cette communication par erreur, veuillez nous en aviser par courrier et détruire immédiatement le courrier et les pièces jointes. Merci. ****************************************************************************** -------------------------------------------------------------------------------
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services