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..

--
Message posted via http://www.dbmonster.com

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.

dromuss via DBMonster.com wrote:
> 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..
>

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.

--
Message posted via http://www.dbmonster.com

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...

dromuss via DBMonster.com wrote:
> 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.
>

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

Hope this help to others!

--
Message posted via http://www.dbmonster.com