473,378 Members | 1,457 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

How to kill running procedures.

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
2 4662
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Bob Swerdlow | last post by:
My application starts up a number of processes for various purposes using: self.popen = popen2.Popen3("/usr/local/bin/python -O "myscript.py") and then shuts them down when appropriate with...
3
by: Alex Hunsley | last post by:
I'm running a monitoring script under linux written in python. It's nohup'ed so that I can log out and it will continue running happily and so on, but sometimes I need to kill the script before...
12
by: Jerry Sievers | last post by:
Greetings Pythonists; I have limited experience with threaded apps and plenty with old style forked heavyweight multi-processing apps. Using Python 2.3.3 on a Redhat 7.x machine. Wondering...
2
by: aj | last post by:
Red Hat Linus AS 2.1 DB2 WSE 8.1 FP5 I am using the following JVM for my java UDF's: java version "1.3.1" Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1) Classic VM (build...
1
by: Alexander N. Spitzer | last post by:
I am trying to write a program that will fork a process, and execute the given task... the catch is that if it runs too long, I want to clean it up. this seemed pretty straight forward with a...
6
by: Matthew Wieder | last post by:
What permissions must a user have to be able to succesffuly execute a Process.Kill? I can run it with Admin privleges but not with regular user priveleges - I get an "Access is Denied." The...
0
by: WATYF | last post by:
This is my problem... I have some code that starts a Process and returns it to a variable... (prcBat) At any time while that process is running... I want to be able to Kill it by pressing a...
8
by: Jord Tanner | last post by:
Greetings, Does anyone know what the effect of sending an INT signal (kill -2) to each of: - pg backend - psql running an insert or select into - Perl script with DBI connection to pg, running...
0
by: __Beat__ | last post by:
Ho to kill a page? When calling my .NET 2.0 DLL from a page, I pass a reference to the page in the NEW: MyDLL = new MyClass(Page,Context) New Sets a global Variable that is then referenced in...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.