By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

sqluexpr - external routine problem

P: n/a
Hi All;
I'm having a problem running an external routine (C language) under DB2
8.2 (FP 9) on AIX 5.3. Since the code was mostly copied from the DB2
sample library, I'm pretty sure it's sound. When executed ("call
export_util (parm1, parm2, parm3, ?)) it just hangs - nothing happening
for several hours - when the table being exported is very small.

I compiled the routine (using IBM-supplied bldrtn module) on a
different AIX box running AIX 5.3 but DB2 8.1 (FP4). I then copied the
module to the routine library on the other (8.2 FP9) box and ran
"Create Procedure" successfully. Could this be my problem? Must I
compile the routine on the target box? The only reason I'm not is that
the C compiler on the target machine is not configured correctly and I
was being lazy. Any insight appreciated.

Pete H

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
peteh wrote:
Hi All;
I'm having a problem running an external routine (C language) under DB2
8.2 (FP 9) on AIX 5.3. Since the code was mostly copied from the DB2
sample library, I'm pretty sure it's sound. When executed ("call
export_util (parm1, parm2, parm3, ?)) it just hangs - nothing happening
for several hours - when the table being exported is very small.

I compiled the routine (using IBM-supplied bldrtn module) on a
different AIX box running AIX 5.3 but DB2 8.1 (FP4). I then copied the
module to the routine library on the other (8.2 FP9) box and ran
"Create Procedure" successfully. Could this be my problem? Must I
compile the routine on the target box? The only reason I'm not is that
the C compiler on the target machine is not configured correctly and I
was being lazy. Any insight appreciated.
One problem might be the different shared libraries on the different
systems. If something changed in the shared libs between 8.1FP4 and 8.2FP9
then the routine would indeed fail at runtime.

Art S. Kagel
Pete H

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.