DB2 SQL Stored Procedure Build problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dharmadam - 22 Oct 2004 20:01 GMT

I am trying to build a simple SQL stored procedure in DB2 Stored
Procedure Builder V7.

It gives me the following message. Can someone help me to identify the
problem.

QCPI039.CREATE_DAILY_BENEF_XREF_DN - Create stored procedure returns
-7032.

QCPI039.CREATE_DAILY_BENEF_XREF_DN:
-- LOG FILE P3530964.log FOR PROCEDURE QCPI039
.CREATE_DAILY_BENEF_XREF_DN

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR
/udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp/P3530964.sqc

LINE MESSAGES FOR P3530964.sqc
------ --------------------------------------------------------------------
SQL0060W The "C" precompiler is in progress.
SQL0091W Precompilation or binding was ended with "0"
errors and "0" warnings.

-- CONTENTS OF /udbprod/udbins40/sqllib/function/routine/sr_cpath

#!/bin/sh
PATH=$PATH:/usr/vacpp/bin
PATH=$PATH:/usr/ibmcxx/bin
PATH=$PATH:/usr/lpp/xlC/bin
export PATH

-- CONTENTS OF /udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp/P3530964.sh

SQLROUTINE_FILENAME=P3530964
export SQLROUTINE_FILENAME
export SQLROUTINE_ENTRY=pgsjmp

-- COMPILATION COMMAND:

xlC_r -I/udbprod/udbins40/sqllib/include P3530964.c -bE:P3530964.exp
-e pgsjmp -o P3530964 -L/udbprod/udbins40/sqllib/lib -ldb2

-- CONTENTS OF /udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp/P3530964.exp

pgsjmp

-- COMPILATION MESSAGES FOR
/udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp/P3530964.c
xlC_r: 1501-224 fatal error in /usr/ibmcxx/exe/munch: signal 4
received

-- END OF LOG FILE (SQLCODE: -7032)

QCPI039.CREATE_DAILY_BENEF_XREF_DN - Changes rolled back.

QCPI039.CREATE_DAILY_BENEF_XREF_DN - Build failed.

Reply to this Message

N. Shamsundar - 23 Oct 2004 01:32 GMT

> I am trying to build a simple SQL stored procedure in DB2 Stored
> Procedure Builder V7.
[quoted text clipped - 13 lines]
> -- PREP/BIND MESSAGES FOR
> /udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp/P3530964.sqc

<SNIP>

Check the permissions on directory

/udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp

DB2 is unable to write to that directory.

N. Shamsundar
University of Houston

Reply to this Message

dharmadam - 25 Oct 2004 15:38 GMT

> > I am trying to build a simple SQL stored procedure in DB2 Stored
> > Procedure Builder V7.
[quoted text clipped - 24 lines]
> N. Shamsundar
> University of Houston

I don't thinh that was the problem. I see the log, scm,sqc files are
created in the directory.

Reply to this Message

N. Shamsundar - 28 Oct 2004 19:17 GMT

>>>I am trying to build a simple SQL stored procedure in DB2 Stored
>>>Procedure Builder V7.
[quoted text clipped - 27 lines]
> I don't thinh that was the problem. I see the log, scm,sqc files are
> created in the directory.

Try, anyway:

chmod a+wx
/udbprod/udbins40/sqllib/function/routine/sqlproc/ANARPT/QCPI039/tmp

and then try to install the SP. This won't hurt and won't take much time
to do.

If this works, you may need to examine your umask settings.

N. Shamsundar
University of Houston

Reply to this Message

Serge Rielau - 25 Oct 2004 14:47 GMT

Signal 4 is SIGILL on AIX, illegal instruction. Can you compile a
different SQL procedure on that system, or do they all fail? It might
be a problem with the C compiler that's installed.

Cheers
Serge

Reply to this Message

dharmadam - 28 Oct 2004 18:52 GMT

> Signal 4 is SIGILL on AIX, illegal instruction. Can you compile a
> different SQL procedure on that system, or do they all fail? It might
> be a problem with the C compiler that's installed.
>
> Cheers
> Serge

I tied with very simple SQL statement and all fails with the same error.

Reply to this Message