470,591 Members | 2,005 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

Unable to debug a DB2 Procedure

Hi,

I am on DB2 v8.1.2.96 and FP 10. Till sometime back I was able to debug
the procedures, now whenever I try to debug the procedure, it comes out
with the following error:

"Exception occurred while debugging:
A severe error occurred while initializing the debugger session. To use
the debugger you must restart your database instance. Return code =
-1879048118"

I have restarted the instance but that did not help my cause.

Can someone please help me

Chettiar

Sep 5 '06 #1
5 2484
chettiar wrote:
Hi,

I am on DB2 v8.1.2.96 and FP 10. Till sometime back I was able to debug
the procedures, now whenever I try to debug the procedure, it comes out
with the following error:

"Exception occurred while debugging:
A severe error occurred while initializing the debugger session. To use
the debugger you must restart your database instance. Return code =
-1879048118"

I have restarted the instance but that did not help my cause.

Can someone please help me
Can you open a PMR with support?

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 5 '06 #2
Sure will let you know in case I get a resolution

Serge Rielau wrote:
chettiar wrote:
Hi,

I am on DB2 v8.1.2.96 and FP 10. Till sometime back I was able to debug
the procedures, now whenever I try to debug the procedure, it comes out
with the following error:

"Exception occurred while debugging:
A severe error occurred while initializing the debugger session. To use
the debugger you must restart your database instance. Return code =
-1879048118"

I have restarted the instance but that did not help my cause.

Can someone please help me
Can you open a PMR with support?

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 5 '06 #3
I have recently had this (DB2 v8.2 with FP 4 or v8.1 with FP12).
The db2fmp processes seem to get "messed up" when they are abnormally
terminated.

Restarting the instance often does not help.

I had to reboot the machine to fix this.

Earlier, I also had a problem when I had audit turned on and I hit a
bug which crashed the fmp process. I opened a PMR and the problem
dragged for about 2-3 weeks, but with no resolution.

The problem was resolved by rebooting the server.

I am still interesed in (1) knowing what causes this and (2) how to
rectify it gracefully (without instance restart or server reboots, but
do not have the time/bandwidth and cannot consistently recreate it in a
test instance.

Hope you make a breakthrough......

Jayesh

chettiar wrote:
Sure will let you know in case I get a resolution

Serge Rielau wrote:
chettiar wrote:
Hi,
>
I am on DB2 v8.1.2.96 and FP 10. Till sometime back I was able to debug
the procedures, now whenever I try to debug the procedure, it comes out
with the following error:
>
"Exception occurred while debugging:
A severe error occurred while initializing the debugger session. To use
the debugger you must restart your database instance. Return code =
-1879048118"
>
I have restarted the instance but that did not help my cause.
>
Can someone please help me
Can you open a PMR with support?

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 6 '06 #4
I deleted the trace files and the log files in the db2dump directory.
Also cleaned up the *.nfy file

I need to find out a reason as to why this happened though.

Jayesh Thakrar wrote:
I have recently had this (DB2 v8.2 with FP 4 or v8.1 with FP12).
The db2fmp processes seem to get "messed up" when they are abnormally
terminated.

Restarting the instance often does not help.

I had to reboot the machine to fix this.

Earlier, I also had a problem when I had audit turned on and I hit a
bug which crashed the fmp process. I opened a PMR and the problem
dragged for about 2-3 weeks, but with no resolution.

The problem was resolved by rebooting the server.

I am still interesed in (1) knowing what causes this and (2) how to
rectify it gracefully (without instance restart or server reboots, but
do not have the time/bandwidth and cannot consistently recreate it in a
test instance.

Hope you make a breakthrough......

Jayesh

chettiar wrote:
Sure will let you know in case I get a resolution

Serge Rielau wrote:
chettiar wrote:
Hi,

I am on DB2 v8.1.2.96 and FP 10. Till sometime back I was able to debug
the procedures, now whenever I try to debug the procedure, it comes out
with the following error:

"Exception occurred while debugging:
A severe error occurred while initializing the debugger session. To use
the debugger you must restart your database instance. Return code =
-1879048118"

I have restarted the instance but that did not help my cause.

Can someone please help me
Can you open a PMR with support?
>
Cheers
Serge
>
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
>
IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 18 '06 #5
I deleted the trace files and the log files in the db2dump directory.
Also cleaned up the *.nfy file

I need to find out a reason as to why this happened though.

Jayesh Thakrar wrote:
I have recently had this (DB2 v8.2 with FP 4 or v8.1 with FP12).
The db2fmp processes seem to get "messed up" when they are abnormally
terminated.

Restarting the instance often does not help.

I had to reboot the machine to fix this.

Earlier, I also had a problem when I had audit turned on and I hit a
bug which crashed the fmp process. I opened a PMR and the problem
dragged for about 2-3 weeks, but with no resolution.

The problem was resolved by rebooting the server.

I am still interesed in (1) knowing what causes this and (2) how to
rectify it gracefully (without instance restart or server reboots, but
do not have the time/bandwidth and cannot consistently recreate it in a
test instance.

Hope you make a breakthrough......

Jayesh

chettiar wrote:
Sure will let you know in case I get a resolution

Serge Rielau wrote:
chettiar wrote:
Hi,

I am on DB2 v8.1.2.96 and FP 10. Till sometime back I was able to debug
the procedures, now whenever I try to debug the procedure, it comes out
with the following error:

"Exception occurred while debugging:
A severe error occurred while initializing the debugger session. To use
the debugger you must restart your database instance. Return code =
-1879048118"

I have restarted the instance but that did not help my cause.

Can someone please help me
Can you open a PMR with support?
>
Cheers
Serge
>
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
>
IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 18 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Serdar Kalaycý | last post: by
1 post views Thread by Jeppe Jespersen | last post: by
1 post views Thread by =?Utf-8?B?TWFuaXNoIEJhZm5h?= | last post: by
9 posts views Thread by Brad Pears | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.