We help IT Professionals succeed at work.
Get Started

DB2 procedure compilation error on Solaris 7 sparc

banumaran
banumaran asked
on
689 Views
Last Modified: 2013-12-05
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/Databases/IBM_UDB/Q_20787883.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


Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE