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
dBforums
>
SQL4301N Java or .NET interpreter startup..., reason code "2". SQLSTATE=58004
07-04-07, 06:47
Linear Mode
