| View previous topic :: View next topic |
| Author |
Message |
satyenderd
Beginner
Joined: 26 Aug 2005
Posts: 144
Topics: 73
|
 Posted: Fri Aug 17, 2007 2:22 am Post subject: Cancelling a DB2 thread in Batch |
 |
|
Hi,
I would like to request you all to help me in cancelling the threads.
I searched for the tips and got few tips given by KOLUSU.
I want to automate this cancellation process in rexx or jcl.
Could please anyone of you help me in this regard?
Thanks in advance..
_________________
Satya |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Fri Aug 17, 2007 7:33 am Post subject: |
|
|
| Quote: |
I would like to request you all to help me in cancelling the threads.
|
satyenderd,
cancel threads? What exactly do you mean? Please Post detailed information on what you're trying to accomplish. Do not make people guess what you mean. This will give you a much better chance of getting a good answer to your question.
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
satyenderd
Beginner
Joined: 26 Aug 2005
Posts: 144
Topics: 73
|
| Posted: Mon Aug 20, 2007 1:02 am Post subject: CANCELLING THREAD |
|
|
Kolusu.. thanks for u r response.
The situation is: I have to cancel specific application DB2 threads everyday in the evening. For this i am using everday
I want to automate this process by writing the job which will cancel the threads automatically at specified time. For this i want to write a job or a tool. I have seen u r tip in one of the posting. | Code: |
//STEP0100 EXEC PGM=IKJEFT01,DYNAMNBR=30,REGION=3072K
//SYSUDUMP DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
-DIS THD(*) TYPE(ACTIVE)
/*
|
when i used this one i am getting one error:
INVALID COMMAND SYNTAX NAME
Please help in how to write a job in cancelling the specific thread?
Hope u got it.
Thanks in Advance.
_________________
Satya |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Mon Aug 20, 2007 8:01 am Post subject: |
|
|
satyenderd,
The error you are getting is because you did not specify the DSN command. ie. change your SYSTSIN to the following
| Code: |
/SYSTSIN DD *
DSN SYSTEM(XXXX)
-DIS THD(*) TYPE(ACTIVE)
/*
|
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
satyenderd
Beginner
Joined: 26 Aug 2005
Posts: 144
Topics: 73
|
| Posted: Tue Aug 21, 2007 3:21 am Post subject: CANCELLING THREAD |
|
|
Thanks Kolusu for u r quick response..
Its been resolved.
Thanks for u r help.
have a great day.
_________________
Satya |
|
| Back to top |
|
|
satyenderd
Beginner
Joined: 26 Aug 2005
Posts: 144
Topics: 73
|
| Posted: Tue Aug 21, 2007 3:28 am Post subject: CANCELLING THREAD |
|
|
Kolusu,
Could you pls help me how to cancel a thread.
In the same manner, but need to cancel a specific thread.
for eg: If display thread displays 100 threads i need to cancel specific thread, identifying with AUTHID, PLAN NAME and TOKEN.
Is it possible to write a cancel thread job?
I have gone thru DB2 THREAD EXPERT but my system does not support that.
Pls help me in this regard. so that i can schedule that job to cancel that specific thread everyday.
Thanks in advance.
_________________
Satya |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Tue Aug 21, 2007 6:56 am Post subject: |
|
|
| Quote: |
If display thread displays 100 threads i need to cancel specific thread, identifying with AUTHID, PLAN NAME and TOKEN.
Is it possible to write a cancel thread job?
|
satyenderd,
Generate the cancel thread commands from the output of display thread command using an utitlity or sort .
| Quote: |
so that i can schedule that job to cancel that specific thread everyday
|
If your shop has scheduler software then schedule the job
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
satyenderd
Beginner
Joined: 26 Aug 2005
Posts: 144
Topics: 73
|
| Posted: Wed Aug 22, 2007 1:36 am Post subject: |
|
|
Kolusu,
Thanks once again.
I will try it today. I will let you know if i face any problems in this process.
Thanks a lot.
Have a great day.
_________________
Satya |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
