Store Procedure Builder hangs (AIX 4.3, DB2 v.7.1, XLC)

Store Procedure Builder hangs (AIX 4.3, DB2 v.7.1, XLC)

Post by Adam Kuchars » Sun, 01 Jul 2001 20:08:19

Hello All !!!

When I'm trying to build stored procedure with SPB - it hangs while
done 70% and  Registering ...
I'm looking LOG files and tehy are:
*** PREPCOMPILE /database/db2taran/sqllib/function/routine/sqlproc/TARANPRO/DB2TARAN/tmp/P2529630.sqc

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

*** COMPILE /database/db2taran/sqllib/function/routine/sqlproc/TARANPRO/DB2TARAN/tmp/P2529630.c

export PATH

export SQLROUTINE_ENTRY=pgsjmp

xlC -H512 -T512  -I/database/db2taran/sqllib/include P2529630.c
-bE:P2529630.exp -e pgsjmp -o P2529630 -L/database/db2taran/sqllib/l
ib -lc -ldb2

*** /database/db2taran/sqllib/function/routine/sqlproc/TARANPRO/DB2TARAN/tmp/P2529630.exp


SQL7032N  SQL procedure "PROC_AK" not created.  Diagnostic file is
"P2529630.log".  SQLSTATE=42904

Can anyone help me ???


Sorry for my bad English.


Store Procedure Builder hangs (AIX 4.3, DB2 v.7.1, XLC)

Post by Dirk » Wed, 04 Jul 2001 02:11:58

Hi Adam,

Quote:> xlC -H512 -T512  -I/database/db2taran/sqllib/include P2529630.c
> -bE:P2529630.exp -e pgsjmp -o P2529630 -L/database/db2taran/sqllib/l
> ib -lc -ldb2

When it hangs:
- does the compiler create the P2529630 file?
- try to copy one of those Pxxxx.c and Pxxxx.exp files and run the compiler
command from the shell. Maybe the license server doesn't respond or

Quote:> P.S.
> Sorry for my bad English.

That's the least you should worry about here. I'd rather have a posting with
lots of error messages and diagnostic info then one in perfect english! ;-)


1. Parasoft Insure++ with DB2 Stored-Procedures on AIX ?

I'm using DB2 v7.1 (fp3) on AIX, and I have
many 'C' DARI style embedded-SQL stored procedures.

We use Parasoft Insure++ v5.1 successfully on
most applications in this environment.

But we dont know if Insure++ can be made to work on the
DB2-stored-procedures themselves.

At present it looks like it just wont work!

DB2-stored-procedures on AIX are shared-libraries,
so I've built them for Insure++ appropriately.
(i.e they seem to load successfully using the load()
system call).

Although I can build the stored-procedures for
insure++, DB2 is unable to load them. It gives
SQL10012N. This is despite the instance having
the DB2LIBPATH prefixed with the insure directories,
and the DB2ENVLIST having LIBPATH included with
a suitable insure-directory prefix.

Has anyone out there managed to get
Insure++ running for DB2 'C' stored procedures on AIX ?

If so , can you email or post exactly how you
did it, with details of the compile+link lines
from your makefile/script, and your db2 and .psrc
setup to make it work.


2. Reading is much more interesting than TV (1513/1708)

3. AIX - DB2 - Transformer Stored Procedure Files - db2_07_01.tspf

4. Java 2 Enterprise Edition (j2ee) on Linux?

5. iODBC DB2 Problem on AIX 4.3

6. Yahoo Messenger Voice behind NAT

7. create a shared library on AIX 4.3 with xlC

8. Offline mailing automation (scripts?)

9. Differences between the xlC 3.1.4 and 3.6.4 compilers on AIX 4.3

10. Differences between xlC v3.1.4 and 3.6.4 on AIX 4.3

11. IBM C++ 3.6.6 (xlC) Compiler error on AIX 4.3

12. Stored Procedures AIX V4.1 RS6000,DB26000 V2.1

13. sending mail from linux to AIX 4.3 hangs (but works when done using telnet xxx 25)