SQL Compiler for Linux on AMD/Opteron-64 bit machine

[ashokrathi]

I am trying to compile SQL procedures on Linux running on AMD/Opteron
64-bit machine. I have 'gcc', 'cc' and 'g++' compilers on my machine. I
have set DB2_SQLROUTINE_COMPILE_COMMAND with various options, such as,
db2set DB2_SQLROUTINE_COMPILE_COMMAND="gcc -fPIC -$HOME/sqllib/include
SQLROUTINE_FILENAME.c -shared -o SQLROUTINE_FILENAME -L$HOME/sqllib/lib
-ldb2"

I have tried with/without "-fPIC" option. Without "-fPIC", I get
following error in a log file:

-- COMPILATION MESSAGES FOR
/home/q9test/sqllib/function/routine/sqlproc/TSTOPTO9/DTOPT/tmp/P2095479.c
/usr/bin/ld: /tmp/cciT6kha.o: relocation R_X86_64_32 can not be used
when making a shared object; recompile with -fPIC
/tmp/cciT6kha.o: could not read symbols: Bad value
collect2: ld returned 1 exit status

With "-fPIC" option, I get following error:
-- COMPILATION MESSAGES FOR
/home/q9test/sqllib/function/routine/sqlproc/TSTOPTO9/DTOPT/tmp/P2103884.c
/usr/bin/ld: skipping incompatible /home/q9test/sqllib/lib/libdb2.so
when searching for -ldb2
/usr/bin/ld: cannot find -ldb2
collect2: ld returned 1 exit status

Has anyone tried compiling SQL procs on AMD/opteron-64 bit machine
running Linux? Your help will be greatly appreciated.
Thanks a lot!!!

-- ashok

[Another DB2 UDB DBA]

What does db2level say your DB2 FixPak level and is? Is your DB2
instance a 32-bit or 64-bit instance?

Also, if you upgrade to FP7a, you won't need a C compiler anymore to
build SQL procedures.

[ashokrathi]

Thanks for your prompt reply. Here is other info:

1) db2level output
DB21085I Instance "q9test" uses "32" bits and DB2 code release
"SQL08016" with
level identifier "02070106".
Informational tokens are "DB2 v8.1.1.58", "s040914", "MI00096", and
FixPak "6".
Product is installed at "/opt/IBM/db2/V8.1"

2) It is a 32-bit instance

3) We do not have an option to upgrade to FP7a yet. We prefer to be a
bit behind the curve.

-- ashok

[ashokrathi]

Thanks for your prompt reply. Here is other info:

1) db2level output
DB21085I Instance "q9test" uses "32" bits and DB2 code release
"SQL08016" with
level identifier "02070106".
Informational tokens are "DB2 v8.1.1.58", "s040914", "MI00096", and
FixPak "6".
Product is installed at "/opt/IBM/db2/V8.1"

2) It is a 32-bit instance

3) We do not have an option to upgrade to FP7a yet. We prefer to be a
bit behind the curve.

-- ashok