473,765 Members | 1,987 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 7797
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
2450
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 preventing a runaway process? I'd like to empower my users AND keep my server online :-) Thanks!
2
4752
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 running and the only way to kill this procedure is to restart the DB2 instance. Any pointers would be helpful. _Micky
4
5433
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 server. Data is sent and received over these connections using the asynchronous model. The server is currently in beta testing. Sporadically over the course of the day, I'll observe the thread count on the process (via perfmon) start climbing....
10
3004
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 Python have any way to kill it? This is not hypothetical; I'm doing it now, and it's working pretty well, but I would like to be able to handle this run-on condition. I'm using Windows 2000, but I want my program to be portable to linux. ...
1
6186
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) Err#11 EAGAIN /4: nanosleep(0xFC4CFBF8, 0xFC4CFBF0) = 0 /4: semop(1441803, 0xFC4CFC78, 1) Err#11 EAGAIN /4: nanosleep(0xFC4CFBF8, 0xFC4CFBF0) = 0 etc ...
2
3467
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 this ?
0
3477
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 : 2639 TID : 45063056 PROC : db2fmp ( INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 Common, OSSe, ossGetDiskInfo, probe:140 MESSAGE : ECF=0x90000017=-1879048169=ECF_FILE_PATH_ACCESS_DENIED
4
2561
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 agents/subagents/sqls when client is no longer connected ?
6
16916
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 executed conditionally through Program A based on the commands it gets from the user. Let's say, we have two inputs, "start" and "stop" to drive the Program B. I have thought of various alternatives. (1) Using Thread to control the execution...
0
9568
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10007
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9955
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9833
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8831
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7378
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5421
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3924
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3531
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.