SEO

#1 (**permalink**) 02-27-2008, 01:28 AM

I tried to compile Java stored procedures and I am getting this
message ..

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

I am using DB2 UDB 8.1.6 . When I tried to compile first time , I am
having no problems.but this is happening all of a sudden.

Thanks
Uma

#2 (**permalink**) 02-27-2008, 01:28 AM

"Uma" <talashil@hotmail.com> wrote in message
news:fd3302b1.0408190838.6a380fd2@posting.google.c om...
> I tried to compile Java stored procedures and I am getting this
> message ..
>
> SQL1131N DARI (Stored Procedure) process has been terminated
> abnormally. SQLSTATE=38503
>
>
> I am using DB2 UDB 8.1.6 . When I tried to compile first time , I am
> having no problems.but this is happening all of a sudden.
>
I suggest that you do an advanced newsgroups Google search on 'SQL1131N'
targetting this newsgroup (comp.databases.ibm-db2). I just tried that and
got 132 hits, although some were not for V8.

One person, Raquel, solved this problem by unsetting the DB2 registry
variable DB2ROUTINE_DEBUG. I didn't read the other 131 hits though so there
may be alternate solutions if that doesn't work; it would probably be better
to read a good sampling of these hits to make sure this solution is
appropriate for your situation.

Unsetting DB2ROUTINE_DEBUG solved a very big problem that I was having a
while back but I am on DB2 V7.2 so I don't know if that solution is
appropriate for DB2 V8.1.6; I thought that problem was fixed by now.

Rhino

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Java Stored procedures 8.1.6