When I issue
call sqlj.install_jar('file:///f:/jars/mail.jar','MAIL');
I get the messages
SQL4301N Java or .NET interpreter startup or communication failed,
reason
code "2". SQLSTATE=58004
2005-10-11-15.31.15.558066+600 I2352539C331 LEVEL: Warning
PID : 950280 TID : 1 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMvfprintf, probe:20
MESSAGE : Can't load library "/usr/lib/libcore.a", because load ENOENT
on shared library(s)
2005-10-11-15.31.15.558360+600 I2352871C365 LEVEL: Error
PID : 950280 TID : 1 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:35
MESSAGE : Error from JNI_CreateJavaVM. RC:
DATA #1 : Hexdump, 4 bytes
0x2FF1EFD0 : FFFF FFFF ....
2005-10-11-15.31.15.558516+600 I2353237C354 LEVEL: Error
PID : 950280 TID : 1 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJAttach, probe:5
MESSAGE : JVM startup failed. RC:
DATA #1 : Hexdump, 4 bytes
0x2FF221C0 : FFFF EF33 ...3
2005-10-11-15.31.15.558639+600 I2353592C355 LEVEL: Error
PID : 950280 TID : 1 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, BSU Java support, sqlejAttach, probe:10
MESSAGE : Error from sqloJAttach. RC:
DATA #1 : Hexdump, 4 bytes
0x2FF22230 : FFFF EF33 ...3
2005-10-11-15.31.25.569713+600 I2353948C1072 LEVEL: Severe
PID : 479466 TID : 1 PROC : db2agent
(LSDEV) 0
INSTANCE: db2inst1 NODE : 000 DB : LSDEV
APPHDL : 0-280 APPID: GA712335.G207.00C281024739
FUNCTION: DB2 UDB, common communication, sqlccIPCSignalDariEnd,
probe:10
MESSAGE : FMP didn't respond in 10 seconds, initStruct =
DATA #1 : Hexdump, 132 bytes
0x30193F10 : 0060 8040 0000 0600 0001 0000 0001 0000
..`.@............
0x30193F20 : A060 8040 A000 0000 0E9E C000 0000 0003
..`.@............
0x30193F30 : 0002 0000 0001 E014 0508 0024 0000 0003
............$....
0x30193F40 : FFFF FFFF FFFF FFFF 0000 0002 FFFF FFFF
.................
0x30193F50 : 0000 0000 0000 0001 0000 0002 0000 0000
.................
0x30193F60 : 0000 0001 0000 0000 0001 0000 0000 0000
.................
0x30193F70 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30193F80 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30193F90 : 0000 0000 ....
2005-10-11-15.31.25.570502+600 I2355021C1595 LEVEL: Severe
PID : 479466 TID : 1 PROC : db2agent
(LSDEV) 0
INSTANCE: db2inst1 NODE : 000 DB : LSDEV
APPHDL : 0-280 APPID: GA712335.G207.00C281024739
FUNCTION: DB2 UDB, routine_infrastructure, sqlerCleanThreadResource,
probe:1
MESSAGE : FMP process didn't respond for 10 seconds, fmpThread =
DATA #1 : Hexdump, 244 bytes
0x301896D4 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x301896E4 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x301896F4 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189704 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189714 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189724 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189734 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189744 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189754 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189764 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189774 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189784 : 0000 0000 0000 0000 0000 F000 0000 0000
.................
0x30189794 : 0000 0000 0000 04EA 0000 00A3 0000 0000
.................
0x301897A4 : 0000 0000 0000 0000 0000 0000 3018 96C0
.............0...
0x301897B4 : 3019 3F10 0000 0000 0000 0001 0000 0000
0.?.............
0x301897C4 : 0000 0000 ....
2005-10-11-15.31.25.570785+600 I2356617C1811 LEVEL: Severe
PID : 479466 TID : 1 PROC : db2agent
(LSDEV) 0
INSTANCE: db2inst1 NODE : 000 DB : LSDEV
APPHDL : 0-280 APPID: GA712335.G207.00C281024739
FUNCTION: DB2 UDB, routine_infrastructure, sqlerCleanThreadResource,
probe:1
MESSAGE : FMP process didn't respond for 10 seconds, fmpRow =
DATA #1 : Hexdump, 292 bytes
0x301896C0 : 000E 8008 0000 0000 01BE 0000 0000 0000
.................
0x301896D0 : 01BF 0000 0000 0000 0000 0000 0000 0000
.................
0x301896E0 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x301896F0 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189700 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189710 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189720 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189730 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189740 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189750 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189760 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189770 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x30189780 : 0000 0000 0000 0000 0000 0000 0000 F000
.................
0x30189790 : 0000 0000 0000 0000 0000 04EA 0000 00A3
.................
0x301897A0 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x301897B0 : 3018 96C0 3019 3F10 0000 0000 0000 0001
0...0.?.........
0x301897C0 : 0000 0000 0000 0000 0000 0000 3018 7A40
.............0.z@
0x301897D0 : 0000 0000 0000 0011 0000 0000 0000 0000
.................
0x301897E0 : 0333 0100 .3..
It works on our other boxes at same fixpak level.
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
"SQL08021"
with level identifier "03020106".
Informational tokens are "DB2 v8.1.1.80", "s041221", "U800400", and
FixPak "8".
Product is installed at "/usr/opt/db2_08_01".
Only difference appears to be
Java Development Kit installation path (JDK_PATH) = /usr/java14
where as working one has /usr/java131. Note. /usr/java14 exists and
works (used by other applications).
Here are the other settings in case asked
Database Manager Configuration
Node type = Enterprise Server Edition with local and remote
clients
Database manager configuration release level = 0x0a00
CPU speed (millisec/instruction) (CPUSPEED) = 4.802167e-07
Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+02
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) = /usr/java14
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) =
/home/db2inst1/sqllib/db2dump
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = ON
Lock (DFT_MON_LOCK) = ON
Sort (DFT_MON_SORT) = ON
Statement (DFT_MON_STMT) = ON
Table (DFT_MON_TABLE) = ON
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = ON
Monitor health of instance and databases (HEALTH_MON) = ON
SYSADM group name (SYSADM_GROUP) = DB2GRP1
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) =
/home/db2inst1
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) = 40000
Directory cache support (DIR_CACHE) = YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 65535
Query heap size (4KB) (QUERY_HEAP_SZ) = 32768
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
Priority of agents (AGENTPRI) = SYSTEM
Max number of existing agents (MAXAGENTS) = 500
Agent pool size (NUM_POOLAGENTS) =
250(calculated)
Initial number of agents in pool (NUM_INITAGENTS) = 200
Max number of coordinating agents (MAX_COORDAGENTS) = (MAXAGENTS -
NUM_INITAGENTS)
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) = 40
Initial number of fenced processes (NUM_INITFENCED) = 40
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) = aixstl02
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) =
db2c_db2inst1
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) = 4096
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
Node connection elapse time (sec) (CONN_ELAPSE) = 10
Max number of node connection retries (MAX_CONNRETRIES) = 5
Max time difference between nodes (min) (MAX_TIME_DIFF) = 60
db2start/db2stop timeout (min) (START_STOP_TIME) = 10
