SQL procedure tracing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Prashant Sogarwal - 10 Jul 2006 20:07 GMT

Hi

I am trying to debug a stored procedure by using the source code given
by Serge in one of the DW article about SQL procedure tracing
(http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0409rielau/)

I am unable to get rid of these errors while linking the sqlpltrc
program using sqlpltrc.exp file on AIX 5.2, any help is appreciated.

xlc_r $EXTRA_CFLAG -qmkshrobj -o $1 $1.o -ldb2 -ldb2psmd
-L$DB2PATH/$LIB -bE:$1.exp
ld: 0711-319 WARNING: Exported symbol not defined: L
ld: 0711-244 ERROR: No csects or exported symbols have been saved.

Thanks
Prashant

Reply to this Message

Serge Rielau - 10 Jul 2006 23:58 GMT

> Hi
>
[quoted text clipped - 9 lines]
> ld: 0711-319 WARNING: Exported symbol not defined: L
> ld: 0711-244 ERROR: No csects or exported symbols have been saved.

I'm far from an expert on the compiler, but are you sure
$DB2PATH/$LIB is set?

Cheers
Serge

PS: I thought I provided the binary for AIX (??)

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Prashant Sogarwal - 11 Jul 2006 20:22 GMT

Hi Serge,

Yes It is set, the error is same if you hard code the $DB2PATH/$LIB.

But Interestingly, I was able to compile by removing -bE:$1.exp, but I
don't know how valid the executable file is after removing the -bE
parameter.

> > Hi
> >
[quoted text clipped - 24 lines]
> IOD Conference
> http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Prashant Sogarwal - 11 Jul 2006 20:25 GMT

PS: The binaries are there for Windows32-bit and Linux Intel 32-bit

-Prashant

> > Hi
> >
[quoted text clipped - 24 lines]
> IOD Conference
> http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Serge Rielau - 12 Jul 2006 01:51 GMT

> PS: The binaries are there for Windows32-bit and Linux Intel 32-bit

Tsk, tsk... now why did I do that??
Anyway the exp-file exports the symbols so without it I fear you will
get a SQLCODE -444 becaue the entry point is missing.
If you send me an email I should be able to bounce you back the executable.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message