469,648 Members | 1,469 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,648 developers. It's quick & easy.

SQL1131N DARI (Stored Procedure) problem

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
Nov 12 '05 #1
4 2610
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..

Nov 12 '05 #2
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
Nov 12 '05 #3
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.

Nov 12 '05 #4
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
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by N.V.Dev | last post: by
reply views Thread by Bruce Pullen | last post: by
reply views Thread by Michel Esber | last post: by
2 posts views Thread by Anonymous Sender | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.