SQL1131N DARI (Stored Procedure) problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dromuss - 04 Apr 2005 16:44 GMT

I have a problem registering Stored Procedures.
I tried diferent stored procedure and non of them work.

Not even an empty stored procedure like the following:

    CREATE PROCEDURE DB2INST1.PRUEBA ()
    LANGUAGE SQL
    BEGIN
    END

I always get "SQL1131N DARI (Stored Procedure) process has been terminated
abnormally. SQLSTATE=38503"

I have looked in the db2diag.log file and I found the message: "An non-EDU
child crashed"

En vironment:
    O.S Linux 7.3(Redhat)
    DB2 7.1

Any idea ?

Thanks in advance..

Reply to this Message

Sean McKeough - 04 Apr 2005 18:11 GMT

Most often this is caused by access permissions making ipc communication
impossible...check that the id you chose to run fenced stored procedures
'owner of sqllib/adm/.fenced file' has read access to the sqllib directory.

> I have a problem registering Stored Procedures.
> I tried diferent stored procedure and non of them work.
[quoted text clipped - 19 lines]
>
> Thanks in advance..

Reply to this Message

dromuss - 04 Apr 2005 19:17 GMT

This is my permission configuration:

./db2inst1/sqllib/
drwxrwsr-t 14 db2inst1 db2iadm1 4096 Mar 31 12:48 sqllib

./db2inst1/sqllib/adm/.fenced
-r--r--r-- 1 db2fenc1 db2fadm1 0 Oct 23 2003 .fenced

I think it's ok.
Isn't it?

I also tried to run a CREATE PROCEDURE with root user. It didn't work.

Reply to this Message

Sean McKeough - 04 Apr 2005 20:07 GMT

It can often be one of the directories leading up to sqllib that has the
problem...try backtracking. One foolproof way to check this out is to su
to db2fenc1 and try looking into sqllib/bin. If you can see the contents
of that directory, then you'll need to open a pmr...

> This is my permission configuration:
>
[quoted text clipped - 8 lines]
>
> I also tried to run a CREATE PROCEDURE with root user. It didn't work.

Reply to this Message

dromuss - 14 Apr 2005 16:11 GMT

I solved the problem installing the library gcc-c++-2.96-110.i386.rpm

Hope this help to others! :)

Reply to this Message