asked on

DB2 procedure compilation error on Solaris 7 sparc

Hi,

OS: SUN 7.2.3
DB: DB2 7.2 with fickpack 11
Compiler :sunone Forte compiler pack [ForteDev_sparc-s1scc-FCS-ML-solsparc]
H/W: ultra 10 256 MB Ram ,enough swap space

When i try to run a procedure the following error occurs

ECCCL.ADD_DELEGATE - Create stored procedure returns -7032.

ECCCL.ADD_DELEGATE:
*** BIND /export/home/db2inst1/sqllib/function/routine/sqlproc/ECCCLSOL/ECCCL/tmp/P0936190.sqc ***

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

*** COMPILE /export/home/db2inst1/sqllib/function/routine/sqlproc/ECCCLSOL/ECCCL/tmp/P0936190.c ***

DB2_SQLROUTINE_COMPILER_PATH=/export/home/db2inst1/myenv

DB2_SQLROUTINE_COMPILE_COMMAND=CC -xarch=v9 -Kpic -mt -I/export/home/db2inst1/sqllib/include SQLROUTINE_FILENAME.C -G -o SQLROUTINE_FILENAME -L/export/home/db2inst1/sqllib/lib -R/export/home/db2inst1/sqllib/lib -ldb2

PATH=$PATH:/export/home/db2inst1/Forte/SUNWspro/bin
export PATH

SQLROUTINE_FILENAME=P0936190
export SQLROUTINE_FILENAME

CC -xarch=v9 -Kpic -mt -I/export/home/db2inst1/sqllib/include P0936190.C -G -o P0936190 -L/export/home/db2inst1/sqllib/lib -R/export/home/db2inst1/sqllib/lib -ldb2

*** /export/home/db2inst1/sqllib/function/routine/sqlproc/ECCCLSOL/ECCCL/tmp/P0936190.exp ***
pgsjmp

Could not open input file "P0936190.C".

----------------------------------------------------------------------------

SQL7032N SQL procedure "" not created. Diagnostic file is "". SQLSTATE=00000

ECCCL.ADD_DELEGATE - Build failed.

ECCCL.ADD_DELEGATE - Changes rolled back.
-------------------------------------------------------------------
on my solaris box
$cat myenv
PATH=$PATH:/export/home/db2inst1//Forte/SUNWspro/bin
export PATH

$ db2set
DB2_SQLROUTINE_COMPILER_PATH=/export/home/db2inst1/myenv
DB2_SQLROUTINE_COMPILE_COMMAND=CC -xarch=v9 -Kpic -mt -I/export/home/db2inst1
/sqllib/include SQLROUTINE_FILENAME.C -G -o SQLROUTINE_FILENAME -L/export/hom
e/db2inst1/sqllib/lib -R/export/home/db2inst1/sqllib/lib -ldb2
DB2COMM=tcpip
DB2AUTOSTART=TRUE
-------------------------------------------------------------------
I had also gone through this site and gave permission
https://www.experts-exchange.com/questions/20787883/SQL0035N-The-file-P5353255-msg-cannot-be-opened.html

Reference:
for compiler options
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/ad/r0006664.htm

http://www-106.ibm.com/developerworks/db2/library/techarticle/0205pilaka/0205pilaka.html

PDF Paper on SQL Procedures - Overview by :Nanda K. Pilaka [IBM]
-------------------------------------------------------------------

Thanks
Banu

ASKER CERTIFIED SOLUTION

BigSchmuh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

banumaran

ASKER

Dear BigSchmuh

Thanks , it worked .
Did you try to fully specify the temp directory in DB2_SQLROUTINE_COMPILE_COMMAND

i Had included the temp directory path in the above path

regards
Banu