Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2007
    Posts
    265

    Unanswered: Java UDF error -- DB2 8.1 FP 18

    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!

  2. #2
    Join Date
    Nov 2007
    Posts
    265
    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...

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by db2user24 View Post

    I think one ( or more) of the libraries is missing but can't tell which one
    I think it should be pretty clear:
    Code:
    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 ....
    Make sure that the JVM bitness matches that of the DB2 instance.

  4. #4
    Join Date
    Nov 2007
    Posts
    265
    thank you.. will look into that!

  5. #5
    Join Date
    Nov 2007
    Posts
    265
    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!

  6. #6
    Join Date
    Jan 2010
    Posts
    335
    Hi,

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

  7. #7
    Join Date
    Nov 2007
    Posts
    265
    Quote Originally Posted by nvk@vhv View Post
    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".

  8. #8
    Join Date
    Nov 2007
    Posts
    265
    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
    Last edited by db2user24; 05-03-11 at 13:24.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •