By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,649 Members | 2,154 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,649 IT Pros & Developers. It's quick & easy.

How to kill running procedures.

P: n/a
Can any one give me some pointers on how to kill a running procedure
in DB2? I have a long running procedure called from a Java routine and
after I kill the Java routine, the procedure keeps running and the
only way to kill this procedure is to restart the DB2 instance.

Any pointers would be helpful.

_Micky
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Micky wrote:
Can any one give me some pointers on how to kill a running procedure
in DB2? I have a long running procedure called from a Java routine and
after I kill the Java routine, the procedure keeps running and the
only way to kill this procedure is to restart the DB2 instance.

Any pointers would be helpful.

_Micky


And you have an operating system in mind?

Unix perhaps? How about kill -9.
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #2

P: n/a
DA Morgan wrote:
Micky wrote:
Can any one give me some pointers on how to kill a running procedure
in DB2? I have a long running procedure called from a Java routine and
after I kill the Java routine, the procedure keeps running and the
only way to kill this procedure is to restart the DB2 instance.

Any pointers would be helpful.

_Micky

And you have an operating system in mind?

Unix perhaps? How about kill -9.

This would work only for a FENCED procedure. Any unfenced procedure
(like SQL Procedures) run in the agent process.. Kill that you loose at
least yoru connection.
Micky, how do you kill the Java routine?

Cheers
Serge
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.