Call Java Stored Procedure fail after Migrate DB2 V7 to V8

[richardshen]

DB2 V8 FP4 on W2K.

After a long long time waiting..

SQL1131N DARI (Stored Procedure) process has been terminated
abnormally.
SQLSTATE=38503

And in DB2Diag.log

PID:1116 TID:1524 Node:000 Title: Fenced mode process encountered an
abnormal situation...terminating
0x02B925C4 : 0x00000000

Any suggestion?
Thanks.
Richard

[Remove the obvious for replies]

Uggh!

I have been thru a lot on this one :

1. Drop and rebuild all stored procs, especially if they have been
built using the stored proc builder. They may not drop from the Stored
Proc Builder, but will drop from the command line.

2. Drop and re-register all UDFs regardless of language they were
built in.

On 2 Jan 2004 09:49:21 -0800, ri*********@canada.com
(ri*********@canada.com) wrote:

DB2 V8 FP4 on W2K.

After a long long time waiting..

SQL1131N DARI (Stored Procedure) process has been terminated
abnormally.
SQLSTATE=38503

And in DB2Diag.log

PID:1116 TID:1524 Node:000 Title: Fenced mode process encountered an
abnormal situation...terminating
0x02B925C4 : 0x00000000

Any suggestion?
Thanks.
Richard

[richardshen]

DB2 Java Stored Procedure is a big shit.
Actually, same problem happens when you do a DB2 Backup/Restore.
All the Java Stored Procedure doesnot work, you need to rebuild all of them.
kurt.wood@NO**@M.state.mn.us (Remove the obvious for replies) wrote in message news:<3f***************@news.state.mn.us>...

Uggh!

I have been thru a lot on this one :

1. Drop and rebuild all stored procs, especially if they have been
built using the stored proc builder. They may not drop from the Stored
Proc Builder, but will drop from the command line.

2. Drop and re-register all UDFs regardless of language they were
built in.

On 2 Jan 2004 09:49:21 -0800, ri*********@canada.com
(ri*********@canada.com) wrote:

DB2 V8 FP4 on W2K.

After a long long time waiting..

SQL1131N DARI (Stored Procedure) process has been terminated
abnormally.
SQLSTATE=38503

And in DB2Diag.log

PID:1116 TID:1524 Node:000 Title: Fenced mode process encountered an
abnormal situation...terminating
0x02B925C4 : 0x00000000

Any suggestion?
Thanks.
Richard

[Sean McKeough]

If you have them in jar files, you can use the sqlj.recover_jar command
(they're stored in the catalogs). Or copy them into the lib
directory...backup support for sps in general is something that's being
worked on.

ri*********@canada.com wrote:

DB2 Java Stored Procedure is a big shit.
Actually, same problem happens when you do a DB2 Backup/Restore.
All the Java Stored Procedure doesnot work, you need to rebuild all of them.
kurt.wood@NO**@M.state.mn.us (Remove the obvious for replies) wrote in message news:<3f***************@news.state.mn.us>...

Uggh!

I have been thru a lot on this one :

1. Drop and rebuild all stored procs, especially if they have been
built using the stored proc builder. They may not drop from the Stored
Proc Builder, but will drop from the command line.

2. Drop and re-register all UDFs regardless of language they were
built in.

On 2 Jan 2004 09:49:21 -0800, ri*********@canada.com
(ri*********@canada.com) wrote:

DB2 V8 FP4 on W2K.

After a long long time waiting..

SQL1131N DARI (Stored Procedure) process has been terminated
abnormally.
SQLSTATE=38503

And in DB2Diag.log

PID:1116 TID:1524 Node:000 Title: Fenced mode process encountered an
abnormal situation...terminating
0x02B925C4 : 0x00000000

Any suggestion?
Thanks.
Richard

[PM \(pm3iinc-nospam\)]

Documeted apar
http://www-306.ibm.com/cgi-bin/db2ww...2&totalSize=38

PM
<ri*********@canada.com> a écrit dans le message de
news:7c**************************@posting.google.c om...

DB2 V8 FP4 on W2K.

After a long long time waiting..

SQL1131N DARI (Stored Procedure) process has been terminated
abnormally.
SQLSTATE=38503

And in DB2Diag.log

PID:1116 TID:1524 Node:000 Title: Fenced mode process encountered an
abnormal situation...terminating
0x02B925C4 : 0x00000000

Any suggestion?
Thanks.
Richard