Connecting Tech Pros Worldwide Forums | Help | Site Map

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

aj
Guest
 
Posts: n/a
#1: Nov 12 '05
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

W Gemini
Guest
 
Posts: n/a
#2: Nov 12 '05

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


aj wrote:[color=blue]
> 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[/color]

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

Sean McKeough
Guest
 
Posts: n/a
#3: Nov 12 '05

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


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

W Gemini wrote:[color=blue]
> aj wrote:
>[color=green]
>> 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[/color]
>
>
> I think you can just kill -9 it. You will lose all the java stored
> procedures that are currently running in the db2fmp though.
>[/color]
Closed Thread