Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    7

    Unanswered: SQL4301N Java or .NET interpreter startup..., reason code "2". SQLSTATE=58004

    Hello,

    First of all I'm not an expert in DB2 :-(
    My problem here is that I'm trying to make to sqlj.INSTALL_JAR from DB2 and it's returning me an error:

    db2 => Call sqlj.INSTALL_JAR('file:///home/db2admin/db2siscripts/schema/core/idgenerator/PRC_NEXTVAL.jar',TEST.PRC_NEXTVAL',0);
    SQL4301N Java or .NET interpreter startup or communication failed, reason
    code "2". SQLSTATE=58004

    I've found a lot of possibilities on Internet and I've tried all the solutions proposed on this IBM forum thread:
    http://www-128.ibm.com/developerwork...m=291#13783896

    but it still doesn't work...
    In the /opt/IBM/db2data/test/sqllib/db2dump/db2diag.log, I can see that there's a problem starting the JVM:

    2007-07-04-11.16.50.537032+120 I4144151G343 LEVEL: Info
    PID : 28253 TID : 4140369600 PROC : db2fmp
    INSTANCE: testdb2 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:401
    MESSAGE : -Xmx8388608
    DATA #1 : Hexdump, 4 bytes
    0xF633ACB4 : 0000 0000 ....
    ...
    ...

    2007-07-04-11.16.50.537190+120 I4144836G336 LEVEL: Info
    PID : 28253 TID : 4140369600 PROC : db2fmp
    INSTANCE: testdb2 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:403
    MESSAGE : exit
    DATA #1 : Hexdump, 4 bytes
    0xF633ACC4 : 283E 69F7 (>i.

    2007-07-04-11.16.50.537312+120 I4145173G337 LEVEL: Info
    PID : 28253 TID : 4140369600 PROC : db2fmp
    INSTANCE: testdb2 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:404
    MESSAGE : abort
    DATA #1 : Hexdump, 4 bytes
    0xF633ACCC : 543D 69F7 T=i.

    2007-07-04-11.16.50.537391+120 I4145511G706 LEVEL: Info
    PID : 28253 TID : 4140369600 PROC : db2fmp
    INSTANCE: testdb2 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:405
    MESSAGE : -Djava.class.path=/opt/IBM/db2data/test/sqllib/java/db2java.zip:/opt/IB
    M/db2data/test/sqllib/java/db2jcc.jar:/opt/IBM/db2data/test/sqllib/java/
    db2jcc_license_cu.jar:/opt/IBM/db2data/test/sqllib/java/sqlj.zip:/opt/I
    BMJava2-14//jre/lib:/opt/IBMJava2-14//jre/lib/rt.jar:/opt/IBMJava2-14/
    /jre/lib/i18n.jar:/opt/IBMJava2-14//lib/tools.jar:
    DATA #1 : Hexdump, 4 bytes
    0xF633ACD4 : 0000 0000 ....

    2007-07-04-11.16.50.537488+120 I4146218G365 LEVEL: Info
    PID : 28253 TID : 4140369600 PROC : db2fmp
    INSTANCE: testdb2 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:406
    MESSAGE : -Djava.home=/opt/IBMJava2-14//jre
    DATA #1 : Hexdump, 4 bytes
    0xF633ACDC : 0000 0000 ....

    2007-07-04-11.16.50.537567+120 I4146584G383 LEVEL: Info
    PID : 28253 TID : 4140369600 PROC : db2fmp
    INSTANCE: testdb2 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:407
    MESSAGE : -Dibm.db2.instance.path=/opt/IBM/db2data/test/sqllib
    DATA #1 : Hexdump, 4 bytes
    0xF633ACE4 : 0000 0000 ....

    2007-07-04-11.16.50.537886+120 I4146968G365 LEVEL: Error
    PID : 28253 TID : 4140369600 PROC : db2fmp
    INSTANCE: testdb2 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:35
    MESSAGE : Error from JNI_CreateJavaVM. RC:
    DATA #1 : Hexdump, 4 bytes
    0xFFFFA278 : FFFF FFFF ....

    2007-07-04-11.16.50.537979+120 I4147334G354 LEVEL: Error
    PID : 28253 TID : 4140369600 PROC : db2fmp
    INSTANCE: testdb2 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloJAttach, probe:5
    MESSAGE : JVM startup failed. RC:
    DATA #1 : Hexdump, 4 bytes
    0xFFFFD494 : 33EF FFFF 3...

    My confguration is:

    OS: Linux 2.6.9-42.0.10.ELsmp #1 SMP Tue Feb 27 09:40:21 EST 2007 x86_64 x86_64 x86_64 GNU/Linux

    The default java (but if I refer to the (JDK_PATH) in the DB2 config, it's not using it)
    java version "1.5.0_06"
    Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)
    Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_06-b05, mixed mode)

    The DB2 level:
    DB21085I Instance "testdb2" uses "32" bits and DB2 code release "SQL08021" with
    level identifier "03020106".
    Informational tokens are "DB2 v8.1.1.80", "s041221", "MI00102", and FixPak "8".
    Product is installed at "/opt/IBM/db2/V8.1".


    db2 => get dbm cfg

    Database Manager Configuration

    Node type = Database Server with local and remote clients

    Database manager configuration release level = 0x0a00
    CPU speed (millisec/instruction) (CPUSPEED) = 2.676618e-07
    Max number of concurrently active databases (NUMDB) = 8
    Data Links support (DATALINKS) = NO
    Federated Database System Support (FEDERATED) = NO
    Transaction processor monitor name (TP_MON_NAME) =
    Default charge-back account (DFT_ACCOUNT_STR) =
    Java Development Kit installation path (JDK_PATH) = /opt/IBMJava2-14/
    Diagnostic error capture level (DIAGLEVEL) = 4
    Notify Level (NOTIFYLEVEL) = 3
    Diagnostic data directory path (DIAGPATH) = /opt/IBM/db2data/test/sqllib/db2dump
    Default database monitor switches
    Buffer pool (DFT_MON_BUFPOOL) = OFF
    Lock (DFT_MON_LOCK) = OFF
    Sort (DFT_MON_SORT) = OFF
    Statement (DFT_MON_STMT) = OFF
    Table (DFT_MON_TABLE) = OFF
    Timestamp (DFT_MON_TIMESTAMP) = ON
    Unit of work (DFT_MON_UOW) = OFF
    Monitor health of instance and databases (HEALTH_MON) = ON
    SYSADM group name (SYSADM_GROUP) = DB2
    SYSCTRL group name (SYSCTRL_GROUP) =
    SYSMAINT group name (SYSMAINT_GROUP) =
    SYSMON group name (SYSMON_GROUP) =
    Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
    Client Kerberos Plugin (CLNT_KRB_PLUGIN) =
    Group Plugin (GROUP_PLUGIN) =
    GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
    Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
    Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
    Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
    Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
    Database manager authentication (AUTHENTICATION) = SERVER
    Cataloging allowed without authority (CATALOG_NOAUTH) = NO
    Trust all clients (TRUST_ALLCLNTS) = YES
    Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
    Bypass federated authentication (FED_NOAUTH) = NO
    Default database path (DFTDBPATH) = /opt/IBM/db2data/test
    Database monitor heap size (4KB) (MON_HEAP_SZ) = 90
    Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048
    Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
    Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC
    Backup buffer default size (4KB) (BACKBUFSZ) = 1024
    Restore buffer default size (4KB) (RESTBUFSZ) = 1024
    Sort heap threshold (4KB) (SHEAPTHRES) = 20000
    Directory cache support (DIR_CACHE) = YES
    Application support layer heap size (4KB) (ASLHEAPSZ) = 15
    Max requester I/O block size (bytes) (RQRIOBLK) = 32767
    Query heap size (4KB) (QUERY_HEAP_SZ) = 1000
    Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
    Priority of agents (AGENTPRI) = SYSTEM
    Max number of existing agents (MAXAGENTS) = 200
    Agent pool size (NUM_POOLAGENTS) = 100(calculated)
    Initial number of agents in pool (NUM_INITAGENTS) = 0
    Max number of coordinating agents (MAX_COORDAGENTS) = MAXAGENTS
    Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS
    Max number of client connections (MAX_CONNECTIONS) = MAX_COORDAGENTS
    Keep fenced process (KEEPFENCED) = YES
    Number of pooled fenced processes (FENCED_POOL) = MAX_COORDAGENTS
    Initial number of fenced processes (NUM_INITFENCED) = 0
    Index re-creation time and redo index build (INDEXREC) = RESTART
    Transaction manager database name (TM_DATABASE) = 1ST_CONN
    Transaction resync interval (sec) (RESYNC_INTERVAL) = 180
    SPM name (SPM_NAME) =
    SPM log size (SPM_LOG_FILE_SZ) = 256
    SPM resync agent limit (SPM_MAX_RESYNC) = 20
    SPM log path (SPM_LOG_PATH) =
    TCP/IP Service name (SVCENAME) = test
    Discovery mode (DISCOVER) = SEARCH
    Discover server instance (DISCOVER_INST) = ENABLE
    Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
    Enable intra-partition parallelism (INTRA_PARALLEL) = NO
    No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 1024
    Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC
    Number of FCM connection entries (FCM_NUM_CONNECT) = AUTOMATIC
    Number of FCM message anchors (FCM_NUM_ANCHORS) = AUTOMATIC

    Thanks again for your help !

    Phil

  2. #2
    Join Date
    Jul 2007
    Posts
    7

    Solved ?

    Hello,

    I'm posting here the first solution(?) I've found.
    But before closing this issue, I need to test more...

    For the story, I've upgraded my SDK to the most recent from IBM but it didn't solve the problem.
    So I've finally installed version IBMJava2-131 32 bits version and relink:

    cd /usr/lib
    ln -fs /opt/IBM/db2/V8.1/lib/libdb2jext.so .
    ln -fs /opt/IBMJava2-131/jre/bin/libjava.so .
    ln -fs /opt/IBMJava2-131/jre/bin/classic/libjvm.so .
    ln -fs /opt/IBMJava2-131/jre/bin/libhpi.so .
    ln -fs /opt/IBMJava2-131/jre/bin/libjsig.so .

    adapted all JDK_PATH from the:
    db2 get admin cfg
    db2 get dbm cfg

    then

    db2stop
    db2start

    and connect to my instance and run the command to have :
    db2 => Call sqlj.INSTALL_JAR('file:///home/db2admin/db2siscripts/schema/core/idgenerator/PRC_NEXTVAL.jar',TEST.PRC_NEXTVAL',0);

    DB20000I The CALL command completed successfully.

Posting Permissions

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