Java Stored procedures 8.1.6

[Uma]

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

[Rhino]

"Uma" <ta******@hotmail.com> wrote in message
news:fd**************************@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