473,386 Members | 1,598 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,386 software developers and data experts.

How can I safely kill a runaway db2fmp that came from a java UDF?

aj
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.3.1, J2RE 1.3.1 IBM build cxia32131-20020302 (JIT
enabled: jitc))

I tried to test one of my java UDF's and it hung. I did a FORCE
APPLICATION to kill the connection (which worked), but now I notice
that a db2fmp process is taking a LOT of my processor.

So I think my JVM is trapping recursively. How can I safely kill
this db2fmp process? This is a production server...

TIA

allen
Nov 12 '05 #1
2 7711
aj wrote:
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.3.1, J2RE 1.3.1 IBM build cxia32131-20020302 (JIT
enabled: jitc))

I tried to test one of my java UDF's and it hung. I did a FORCE
APPLICATION to kill the connection (which worked), but now I notice
that a db2fmp process is taking a LOT of my processor.

So I think my JVM is trapping recursively. How can I safely kill
this db2fmp process? This is a production server...

TIA

allen


I think you can just kill -9 it. You will lose all the java stored
procedures that are currently running in the db2fmp though.

Nov 12 '05 #2
Yes, it's safe to kill with -9...the db2sysc will ignore a sigchld from
any db2fmp process.

W Gemini wrote:
aj wrote:
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.3.1, J2RE 1.3.1 IBM build cxia32131-20020302 (JIT
enabled: jitc))

I tried to test one of my java UDF's and it hung. I did a FORCE
APPLICATION to kill the connection (which worked), but now I notice
that a db2fmp process is taking a LOT of my processor.

So I think my JVM is trapping recursively. How can I safely kill
this db2fmp process? This is a production server...

TIA

allen

I think you can just kill -9 it. You will lose all the java stored
procedures that are currently running in the db2fmp though.

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: David Hane | last post by:
Hi all, I would like give users the ability to experiment with complex queries but I'm worried about them creating queries that will bog down the server. Does anyone have any ideas for...
2
by: Micky | last post by:
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...
4
by: Matthew Groch | last post by:
Hi all, I've got a server that handles a relatively high number of concurrent transactions (on the magnitude of 1000's per second). Client applications establish socket connections with the...
10
by: I. Myself | last post by:
Suppose we spawn a child process with Popen. I'm thinking of an executable file, like a compiled C program. Suppose it is supposed to run for one minute, but it just keeps going and going. Does...
1
by: kavallin | last post by:
I have a problem with that the db2fmp process are hung , with truss can I see this : /4: nanosleep(0xFC4CFBF8, 0xFC4CFBF0) = 0 /4: semop(1441803, 0xFC4CFC78, 1) ...
2
by: db2admin | last post by:
Hi, I have db2 database at V8 + FP 12 and i saw db2fmp process running at 80% cpu I have health monitor turned off and automatic maintainence turned off as well what could be the reason for...
0
by: p.thorn.ru | last post by:
Hello, I am running db2 express-c 9.5 under linux (fedora 7), and my error log frequently shows messages like these: 2008-01-08-18.30.01.952964+180 I651334G1048 LEVEL: Error (OS) PID ...
4
by: db2admin | last post by:
Hello, Sometime, clients disconnect after starting sql and sql keep running in the db2 engine making it a runaway sql. is there something in DB2 which can avoid this behavior i.e. clean any...
6
by: itsraghz | last post by:
Dear All, I have an issue with destroy() method of java.lang.Process class. All what I am trying to do is, controlling the execution of one program through another. Let's say, Program B has to be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.