Hello,

We have DB2 setup on CentOS.. I get this error after calling a java UDF

db2 "select METER_EXP (100, 'x * 120') from sysibm.sysdummy1"

1
------------------------
SQL4301N Java or .NET interpreter startup or communication failed, reason
code "0". SQLSTATE=58004

I think one ( or more) of the libraries is missing but can't tell which one... I set the db2diag level to 4 and here is the output below as well --- Thanks!

2011-05-02-17.23.11.621033-300 I506220E381 LEVEL: Info
PID : 7734 TID : 47284992328528PROC : db2fmpr
INSTANCE: nrg1 NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejSuffixEnv, probe:20
MESSAGE : Setting environment variable:
DATA #1 : Hexdump, 15 bytes
0x00002B0163E766DF : 4C44 5F4C 4942 5241 5259 5F50 4154 48 LD_LIBRARY_PATH


2011-05-02-17.23.11.621287-300 I506602E686 LEVEL: Info
PID : 7734 TID : 47284992328528PROC : db2fmpr
INSTANCE: nrg1 NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejSuffixEnv, probe:21
MESSAGE : New value:
DATA #1 : Hexdump, 79 bytes
0x00002B0167AEDD20 : 2F68 6F6D 652F 6E72 6731 2F73 716C 6C69 /home/nrg1/sqlli
0x00002B0167AEDD30 : 622F 6C69 623A 2F68 6F6D 652F 6E72 6731 b/lib:/home/nrg1
0x00002B0167AEDD40 : 2F73 716C 6C69 622F 6675 6E63 7469 6F6E /sqllib/function
0x00002B0167AEDD50 : 3A2F 6F70 742F 4942 4D4A 6176 6132 2D31 :/opt/IBMJava2-1
0x00002B0167AEDD60 : 3432 2F6A 7265 2F62 696E 2F6A 3976 6D 42/jre/bin/j9vm


2011-05-02-17.23.11.621423-300 I507289E456 LEVEL: Info
PID : 7734 TID : 47284992328528PROC : db2fmpr
INSTANCE: nrg1 NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejGetBlocks, probe:22
MESSAGE : Attempting to load JEXT DLL Path:
DATA #1 : Hexdump, 21 bytes
0x00007FFF47396690 : 2F68 6F6D 652F 6E72 6731 2F73 716C 6C69 /home/nrg1/sqlli
0x00007FFF473966A0 : 622F 6C69 62 b/lib


2011-05-02-17.23.11.621515-300 I507746E383 LEVEL: Info
PID : 7734 TID : 47284992328528PROC : db2fmpr
INSTANCE: nrg1 NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejGetBlocks, probe:27
MESSAGE : Attempting to load JEXT DLL Name:
DATA #1 : Hexdump, 13 bytes
0x00002B01640C9EAC : 6C69 6264 6232 6A65 7874 2E73 6F libdb2jext.so


2011-05-02-17.23.11.622123-300 I508130E384 LEVEL: Info
PID : 7734 TID : 47284992328528PROC : db2fmpr
INSTANCE: nrg1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSuffixEnv, probe:20
MESSAGE : Setting environment variable:
DATA #1 : Hexdump, 15 bytes
0x00002B0163E766DF : 4C44 5F4C 4942 5241 5259 5F50 4154 48 LD_LIBRARY_PATH


2011-05-02-17.23.11.622221-300 I508515E1008 LEVEL: Info
PID : 7734 TID : 47284992328528PROC : db2fmpr
INSTANCE: nrg1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSuffixEnv, probe:21
MESSAGE : New value:
DATA #1 : Hexdump, 137 bytes
0x00002B0167AEDD20 : 2F68 6F6D 652F 6E72 6731 2F73 716C 6C69 /home/nrg1/sqlli
0x00002B0167AEDD30 : 622F 6C69 623A 2F68 6F6D 652F 6E72 6731 b/lib:/home/nrg1
0x00002B0167AEDD40 : 2F73 716C 6C69 622F 6675 6E63 7469 6F6E /sqllib/function
0x00002B0167AEDD50 : 3A2F 6F70 742F 4942 4D4A 6176 6132 2D31 :/opt/IBMJava2-1
0x00002B0167AEDD60 : 3432 2F6A 7265 2F62 696E 2F6A 3976 6D3A 42/jre/bin/j9vm:
0x00002B0167AEDD70 : 2F6F 7074 2F49 424D 4A61 7661 322D 3134 /opt/IBMJava2-14
0x00002B0167AEDD80 : 322F 6A72 652F 6269 6E2F 6A39 766D 3A2F 2/jre/bin/j9vm:/
0x00002B0167AEDD90 : 6F70 742F 4942 4D4A 6176 6132 2D31 3432 opt/IBMJava2-142
0x00002B0167AEDDA0 : 2F6A 7265 2F62 696E 3A /jre/bin:


2011-05-02-17.23.11.622373-300 I509524E462 LEVEL: Info
PID : 7734 TID : 47284992328528PROC : db2fmpr
INSTANCE: nrg1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:35
MESSAGE : Attempting to load JNI Path:
DATA #1 : Hexdump, 30 bytes
0x00007FFF47395A30 : 2F6F 7074 2F49 424D 4A61 7661 322D 3134 /opt/IBMJava2-14
0x00007FFF47395A40 : 322F 6A72 652F 6269 6E2F 6A39 766D 2/jre/bin/j9vm


2011-05-02-17.23.11.622490-300 I509987E379 LEVEL: Info
PID : 7734 TID : 47284992328528PROC : db2fmpr
INSTANCE: nrg1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:36
MESSAGE : Attempting to load JNI DLL Name:
DATA #1 : Hexdump, 9 bytes
0x00002B01640CA2CC : 6C69 626A 766D 2E73 6F libjvm.so


2011-05-02-17.23.11.623002-300 I510367E370 LEVEL: Error
PID : 7734 TID : 47284992328528PROC : db2fmpr
INSTANCE: nrg1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:30
MESSAGE : sqloloadmodule failed. RC:
DATA #1 : Hexdump, 4 bytes
0x00007FFF473948AC : 0A00 0F86 ....


2011-05-02-17.23.11.623141-300 I510738E365 LEVEL: Error
PID : 7734 TID : 47284992328528PROC : db2fmpr
INSTANCE: nrg1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJAttach, probe:5
MESSAGE : JVM startup failed. RC:
DATA #1 : Hexdump, 4 bytes
0x00007FFF473975AC : 34EF FFFF 4...


2011-05-02-17.23.11.623230-300 I511104E366 LEVEL: Error
PID : 7734 TID : 47284992328528PROC : db2fmpr
INSTANCE: nrg1 NODE : 000
FUNCTION: DB2 UDB, BSU Java support, sqlejAttach, probe:10
MESSAGE : Error from sqloJAttach. RC:
DATA #1 : Hexdump, 4 bytes
0x00007FFF4739763C : 34EF FFFF 4...


2011-05-02-17.23.11.623374-300 I511471E476 LEVEL: Severe
PID : 6951 TID : 47503306786720PROC : db2agent (ENERGY1)
INSTANCE: nrg1 NODE : 000 DB : ENERGY1
APPHDL : 0-747 APPID: *LOCAL.nrg1.110502222139
FUNCTION: DB2 UDB, routine_infrastructure, sqlerMasterThreadReq, probe:900
MESSAGE : marking fmp as unstable:
DATA #1 : Hexdump, 4 bytes
0x0000000200168D20 : 361E 0000 6...



2011-05-02-17.23.11.623556-300 I511948E480 LEVEL: Severe
PID : 6951 TID : 47503306786720PROC : db2agent (ENERGY1)
INSTANCE: nrg1 NODE : 000 DB : ENERGY1
APPHDL : 0-747 APPID: *LOCAL.nrg1.110502222139
FUNCTION: DB2 UDB, routine_infrastructure, sqlerMasterThreadReq, probe:901
MESSAGE : marking fmp as unstable:
DATA #1 : Hexdump, 8 bytes
0x000000020016B0C0 : 0000 0000 0000 0000 ........


2011-05-02-17.23.11.623706-300 I512429E2345 LEVEL: Severe
PID : 6951 TID : 47503306786720PROC : db2agent (ENERGY1)
INSTANCE: nrg1 NODE : 000 DB : ENERGY1
APPHDL : 0-747 APPID: *LOCAL.nrg1.110502222139
FUNCTION: DB2 UDB, routine_infrastructure, sqlerMasterThreadReq, probe:902
MESSAGE : marking fmp as unstable:
DATA #1 : Hexdump, 376 bytes
0x0000000200168D20 : 361E 0000 01CC 7B01 01CC 7C01 0000 0000 6.....{...|.....
0x0000000200168D30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168D40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168D50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168D60 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168D70 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168D80 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168D90 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168DA0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168DB0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168DC0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168DD0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168DE0 : 20D9 AD34 342B 0000 9480 0410 0200 0000 ..44+..........
0x0000000200168DF0 : 9470 0510 0200 0000 00F0 0000 9A00 0000 .p..............
0x0000000200168E00 : 0000 0000 0061 0000 9A00 0000 0000 0000 .....a..........
0x0000000200168E10 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168E20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168E30 : 208D 1600 0200 0000 608C 1600 0200 0000 .......`.......
0x0000000200168E40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168E50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168E60 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000200168E70 : 8080 1600 0200 0000 603F 1600 0200 0000 ........`?......
0x0000000200168E80 : 1300 0000 0000 0000 0000 0000 3303 0100 ............3...
0x0000000200168E90 : 0100 0000 0000 0000 ........



2011-05-02-17.23.11.623969-300 I514775E372 LEVEL: Severe
PID : 6951 TID : 47503306786720PROC : db2agent (ENERGY1)
INSTANCE: nrg1 NODE : 000 DB : ENERGY1
APPHDL : 0-747 APPID: *LOCAL.nrg1.110502222139
FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFmpThread, probe:20
RETCODE : ZRC=0xFFFFFBEE=-1042

2011-05-02-17.23.21.609411-300 E515148E481 LEVEL: Warning
PID : 6714 TID : 47503306786720PROC : db2sysc
INSTANCE: nrg1 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerReturnFmpToPool, probe:999
DATA #1 : String, 22 bytes
Removing FMP from pool
DATA #2 : Hexdump, 24 bytes
0x00007FFF75FC9740 : 0000 0000 0000 0000 361E 0000 4100 0000 ........6...A...
0x00007FFF75FC9750 : 800A 0200 0200 0000 ........


2011-05-02-17.23.21.609648-300 I515630E379 LEVEL: Severe
PID : 6714 TID : 47503306786720PROC : db2sysc
INSTANCE: nrg1 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerReturnFmpToPool, probe:910
MESSAGE : marking fmp as unstable:
DATA #1 : Hexdump, 4 bytes
0x0000000200168D20 : 361E 0000 6...

I think it should be pretty clear:
Make sure that the JVM bitness matches that of the DB2 instance.

thank you.. will look into that!

I checked under /usr/lib and see libjvm.so so not sure why it's failing to load.. as a part of the setup, I gave these commands and see them all under /usr/lib

ln -fs /opt/IBMJava2-amd64-142/jre/bin/libjava.so .
ln -fs /opt/IBMJava2-amd64-142/jre/bin/classic/libjvm.so .
ln -fs /opt/IBMJava2-amd64-142/jre/bin/libhpi.so .

ln -fs /opt/IBM/db2/V8.1/lib/libdb2jext.so .
ln -fs /opt/IBMJava2-142/jre/bin/libjsig.so .


Any idea what else I can check? Thanks!

Hi,

do you have a 32 or 64 Bit Instance? -> db2level

It's 64 bit --


[nrg1@localhost ~]$ db2level
DB21085I Instance "nrg1" uses "64" bits and DB2 code release "SQL08029" with
level identifier "030A0106".
Informational tokens are "DB2 v8.1.3.160", "s090715", "MI00295", and FixPak
"18".
Product is installed at "/opt/IBM/db2/V8.1".

Seems like it's looking for /opt/IBMJava2-14/jre/bin/j9vm which doesn't exist..


Hmm, it's very confusing... does anyone know what the JDK_PATH for 64-bit DB2 is?

If I give this command, I get ---
db2 get dbm cfg | grep JDK
Java Development Kit installation path (JDK_PATH) = /opt/IBMJava2-amd64-142

But it seems like the java installation that comes with 8.1 64-bit db2 install is IBMJava2-142