By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,334 Members | 2,746 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,334 IT Pros & Developers. It's quick & easy.

Call Java Stored Procedure fail after Migrate DB2 V7 to V8

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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


Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

P: n/a
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

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.