Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Belgium
    Posts
    12

    Unanswered: UDF in JAVA problems

    I've got 2 DB2 v8.1 configuration problems.

    1) AFTER I run a UDF written in Java on my DB2 installation on Solaris, a process called 'db2fmp' starts running and in a mum of time it takes 95% of the CPU-time.
    First I don't understand why he does this after the function has runned, I already have my output. And secondly why it goes up to to 95% of the CPU-time .
    Anyone an idea how to silve this problem

    2)I've also a DB2 installation on a Slackware-machine (Linux). Everything works fine, only when I try following code:

    CREATE TABLE tester(a int)
    INSERT INTO tester VALUES(2),(5),(3)
    CREATE FUNCTION test2(Int) RETURNS Int external name 'udfs.func' deterministic no external action NOT FENCED language JAVA parameter style DB2GENERAL no sql

    SELECT test2(a) FROM tester

    I've got following error:
    'SQL1042C An unexpected system error
    occurred. SQLSTATE=58004'

    And when I look at the db2diag.log I get:

    error loading module: libdb2jext.so
    errno = 2


    6c69 626a 6176 612e 736f 3a20 6361 6e6e libjava.so: cann
    6f74 206f 7065 6e20 7368 6172 6564 206f ot open shared o
    626a 6563 7420 6669 6c65 3a20 4e6f 2073 bject file: No s
    7563 6820 6669 6c65 206f 7220 6469 7265 uch file or dire
    6374 6f72 79 ctory

    2004-02-19-15.04.28.303501 Instance:db2inst Node:000
    PID:26533(db2fmp) TID:16384 Appid:none
    BSU Java support sqlejGetBlocks Probe:40

    sqloLoadModule failed. RC:
    0a00 0f86 ....

    2004-02-19-15.04.28.311060 Instance:db2inst Node:000
    PID:26533(db2fmp) TID:16384 Appid:none
    routine_infrastructure sqlerFmpOneTimeInit Probe:110

    DiagData
    eefb ffff ....

    2004-02-19-15.04.28.325262 Instance:db2inst Node:000
    PID:25963(db2agent (UDF)) TID:16384 Appid:*LOCAL.db2inst.0A79A9160414
    routine_infrastructure sqlerGetFmpThread Probe:20 Database:UDF

    DIA0001E An internal error occurred. Report the following error code :
    "ZRC=0xFFFFFBEE".

    The two files he complains about (libdb2jext.so and libjava.so) are installed at my pc.
    Anyone an idea how to solve this problem?

  2. #2
    Join Date
    Nov 2003
    Location
    Belgium
    Posts
    12
    I'm still looking for the solution of the first problem, the second is quite easy. I just had to ad following files to the file /etc/ld.so.conf:

    /opt/IBMJava2-131/jre/bin/
    /opt/IBM/db2/V8.1/lib/
    /opt/IBMJava2-131/jre/bin/classic/

  3. #3
    Join Date
    Nov 2003
    Location
    Belgium
    Posts
    12
    To be more correct, I had to add the directories, not files

Posting Permissions

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