JAVA udf 8.2.2

Christos Kalantzis

Hello,

I am trying to get JAVA UDFs working in DB2 8.2.2.
I created a class, then I compiled it using with the IBM JDK included
with DB2. I put the class in the sqllib folder and created a function
that references the class and the function within that class.

When I run it, this is the message I get.
db2 "select db2inst1.test(0) FROM sysibm.sysdummy1"

1
----------
SQL4301N Java or .NET interpreter startup or communication failed, reason
code "2". SQLSTATE=58004
It does not complain about not finding the class, or some other error,
from what I understand. It is saying that it cannot even start the JVM.

Below is the db2diag.log

2005-05-12-13.32.32.233311-240 I143627G365 LEVEL: Error
PID : 1470 TID : 290192832 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
0xBFFFD4E4 : FFFF FFFF ....

2005-05-12-13.32.32.233597-240 I143993G354 LEVEL: Error
PID : 1470 TID : 290192832 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
0xBFFFD534 : 33EF FFFF 3...

2005-05-12-13.32.32.233706-240 I144348G355 LEVEL: Error
PID : 1470 TID : 290192832 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
0xBFFFD55C : 33EF FFFF 3...

2005-05-12-13.32.32.233894-240 I144704G372 LEVEL: Severe
PID : 776 TID : 332712768 PROC : db2agent (SAMPLE)
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-7 APPID: *LOCAL.db2inst1.050512172342
FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFmpThread, probe:20
RETCODE : ZRC=0xFFFFFBEE=-1042

2005-05-12-13.32.32.186482-240 I143324G302 LEVEL: Warning
PID : 743 TID : 332712768 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
MESSAGE : Removing FMP from pool
DATA #1 : Hexdump, 12 bytes
0xBFFFBBB4 : 0000 0000 5C05 0000 5402 0000 ....\...T...

2005-05-12-13.32.32.233311-240 I143627G365 LEVEL: Error
PID : 1470 TID : 290192832 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
0xBFFFD4E4 : FFFF FFFF ....

2005-05-12-13.32.32.233597-240 I143993G354 LEVEL: Error
PID : 1470 TID : 290192832 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
0xBFFFD534 : 33EF FFFF 3...

2005-05-12-13.32.32.233706-240 I144348G355 LEVEL: Error
PID : 1470 TID : 290192832 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
0xBFFFD55C : 33EF FFFF 3...

2005-05-12-13.32.32.233894-240 I144704G372 LEVEL: Severe
PID : 776 TID : 332712768 PROC : db2agent (SAMPLE)
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-7 APPID: *LOCAL.db2inst1.050512172342
FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFmpThread, probe:20
RETCODE : ZRC=0xFFFFFBEE=-1042

2005-05-12-13.32.42.188780-240 I145077G302 LEVEL: Warning
PID : 743 TID : 332712768 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
MESSAGE : Removing FMP from pool
DATA #1 : Hexdump, 12 bytes
0xBFFFBBB4 : 0000 0000 BE05 0000 0000 0000 ............

2005-05-12-13.32.42.188780-240 I145077G302 LEVEL: Warning
PID : 743 TID : 332712768 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
MESSAGE : Removing FMP from pool
DATA #1 : Hexdump, 12 bytes
0xBFFFBBB4 : 0000 0000 BE05 0000 0000 0000 ............
Thank you

Christos

Nov 12 '05 #1

Subscribe Reply

3696

Knut Stolze

Christos Kalantzis wrote:

Hello,

I am trying to get JAVA UDFs working in DB2 8.2.2.
I created a class, then I compiled it using with the IBM JDK included
with DB2. I put the class in the sqllib folder and created a function
that references the class and the function within that class.

When I run it, this is the message I get.
db2 "select db2inst1.test(0) FROM sysibm.sysdummy1"

1
----------
SQL4301N Java or .NET interpreter startup or communication failed, reason
code "2". SQLSTATE=58004
It does not complain about not finding the class, or some other error,
from what I understand. It is saying that it cannot even start the JVM.

How did you configure DB2 with respect to Java? What is the JDK path set to
etc.?

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

Nov 12 '05 #2

Christos Kalantzis

I reinstalled DB2, and now it is a vanilla install of 8.2 Express,
installed on suse 9.2.

So the defaults are in place (see below for full instance config)

I created the sample DB.

http://users.sdsc.edu/~viswanat/docs/javaudfs.pdf
I used the above document to test the JAVA UDF features, however instead
of creating the view as described in the document, I ran the following
query:

select BitAnd(5,9) from sysibm.sysdummy1

and got the folloting message:
SQL1042C An unexpected system error occurred. SQLSTATE=58004
The db2dia.log shows the messages below:

2005-05-13-09.33.11.930128-240 E13845G618 LEVEL: Error (OS)
PID : 19010 TID : 558748544 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:190
CALLED : OS, -, dlopen OSERR: ENOENT (2)
RETCODE : ECF=0x9000001A=-1879048166=ECF_FILE_DOESNT_EXIST
File doesn't exist
DATA #1 : Library name or path, 13 bytes
libdb2jext.so
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
256
DATA #3 : String, 69 bytes
libjava.so: cannot open shared object file: No such file or directory

2005-05-13-09.33.11.930482-240 I14464G357 LEVEL: Error
PID : 19010 TID : 558748544 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejGetBlocks, probe:40
MESSAGE : sqloLoadModule failed. RC:
DATA #1 : Hexdump, 4 bytes
0xBFFFE1A4 : 0A00 0F86 ....

2005-05-13-09.33.11.930587-240 I14822G351 LEVEL: Severe
PID : 19010 TID : 558748544 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpOneTimeInit, probe:110
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFFFF774 : EEFB FFFF ....

2005-05-13-09.33.11.930745-240 I15174G372 LEVEL: Severe
PID : 17764 TID : 606077120 PROC : db2agent (SAMPLE)
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-18 APPID: *LOCAL.db2inst1.050513125959
FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFmpThread, probe:20
RETCODE : ZRC=0xFFFFFBEE=-1042

Database Manager Configuration

Node type = Database Server with local and remote clients

Database manager configuration release level = 0x0a00

CPU speed (millisec/instruction) (CPUSPEED) = 3.621306e-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-141

Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) =
/db2/home/db2inst1/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) = DB2IADM1
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) =
/db2/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) = 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) = 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) = 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

Knut Stolze wrote:

Christos Kalantzis wrote:

Hello,

I am trying to get JAVA UDFs working in DB2 8.2.2.
I created a class, then I compiled it using with the IBM JDK included
with DB2. I put the class in the sqllib folder and created a function
that references the class and the function within that class.

When I run it, this is the message I get.
db2 "select db2inst1.test(0) FROM sysibm.sysdummy1"

1
----------
SQL4301N Java or .NET interpreter startup or communication failed, reason
code "2". SQLSTATE=58004
It does not complain about not finding the class, or some other error,
from what I understand. It is saying that it cannot even start the JVM.

How did you configure DB2 with respect to Java? What is the JDK path set to
etc.?

Nov 12 '05 #3

shenanwei

>From the DB2Diag.log,
libjava.so: cannot open shared object file: No such file or directory
You should make a link of libjava.so to the $LIB

Christos Kalantzis wrote:

I reinstalled DB2, and now it is a vanilla install of 8.2 Express,
installed on suse 9.2.

So the defaults are in place (see below for full instance config)

I created the sample DB.

http://users.sdsc.edu/~viswanat/docs/javaudfs.pdf
I used the above document to test the JAVA UDF features, however instead of creating the view as described in the document, I ran the following query:

select BitAnd(5,9) from sysibm.sysdummy1

and got the folloting message:
SQL1042C An unexpected system error occurred. SQLSTATE=58004
The db2dia.log shows the messages below:

2005-05-13-09.33.11.930128-240 E13845G618 LEVEL: Error (OS)
PID : 19010 TID : 558748544 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:190
CALLED : OS, -, dlopen OSERR: ENOENT (2)
RETCODE : ECF=0x9000001A=-1879048166=ECF_FILE_DOESNT_EXIST
File doesn't exist
DATA #1 : Library name or path, 13 bytes
libdb2jext.so
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
256
DATA #3 : String, 69 bytes
libjava.so: cannot open shared object file: No such file or directory

2005-05-13-09.33.11.930482-240 I14464G357 LEVEL: Error
PID : 19010 TID : 558748544 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejGetBlocks, probe:40
MESSAGE : sqloLoadModule failed. RC:
DATA #1 : Hexdump, 4 bytes
0xBFFFE1A4 : 0A00 0F86 ....

2005-05-13-09.33.11.930587-240 I14822G351 LEVEL: Severe
PID : 19010 TID : 558748544 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpOneTimeInit, probe:110 MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFFFF774 : EEFB FFFF ....

2005-05-13-09.33.11.930745-240 I15174G372 LEVEL: Severe
PID : 17764 TID : 606077120 PROC : db2agent (SAMPLE) INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-18 APPID: *LOCAL.db2inst1.050513125959
FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFmpThread, probe:20 RETCODE : ZRC=0xFFFFFBEE=-1042

Database Manager Configuration

Node type = Database Server with local and remote clients

Database manager configuration release level = 0x0a00

CPU speed (millisec/instruction) (CPUSPEED) = 3.621306e-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-141
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) =
/db2/home/db2inst1/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) = DB2IADM1
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) =
/db2/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) = 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) = 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) = 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

Knut Stolze wrote:
Christos Kalantzis wrote:

Hello,

I am trying to get JAVA UDFs working in DB2 8.2.2.
I created a class, then I compiled it using with the IBM JDK includedwith DB2. I put the class in the sqllib folder and created a functionthat references the class and the function within that class.

When I run it, this is the message I get.
db2 "select db2inst1.test(0) FROM sysibm.sysdummy1"

1
----------
SQL4301N Java or .NET interpreter startup or communication failed, reasoncode "2". SQLSTATE=58004
It does not complain about not finding the class, or some other error,from what I understand. It is saying that it cannot even start the
JVM.

How did you configure DB2 with respect to Java? What is the JDK path set to etc.?

Nov 12 '05 #4

Christos Kalantzis

Thank you, it worked.
I had to link 3 other files too, but you gave me the headstart I needed
to understand what was going wrong.

Christos

sh*******@gmail.com wrote:

From the DB2Diag.log,

libjava.so: cannot open shared object file: No such file or directory
You should make a link of libjava.so to the $LIB

Christos Kalantzis wrote:
I reinstalled DB2, and now it is a vanilla install of 8.2 Express,
installed on suse 9.2.

So the defaults are in place (see below for full instance config)

I created the sample DB.

http://users.sdsc.edu/~viswanat/docs/javaudfs.pdf
I used the above document to test the JAVA UDF features, however

instead
of creating the view as described in the document, I ran the

following
query:

select BitAnd(5,9) from sysibm.sysdummy1

and got the folloting message:
SQL1042C An unexpected system error occurred. SQLSTATE=58004
The db2dia.log shows the messages below:

2005-05-13-09.33.11.930128-240 E13845G618 LEVEL: Error (OS)
PID : 19010 TID : 558748544 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:190
CALLED : OS, -, dlopen OSERR: ENOENT (2)
RETCODE : ECF=0x9000001A=-1879048166=ECF_FILE_DOESNT_EXIST
File doesn't exist
DATA #1 : Library name or path, 13 bytes
libdb2jext.so
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
256
DATA #3 : String, 69 bytes
libjava.so: cannot open shared object file: No such file or directory

2005-05-13-09.33.11.930482-240 I14464G357 LEVEL: Error
PID : 19010 TID : 558748544 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejGetBlocks, probe:40
MESSAGE : sqloLoadModule failed. RC:
DATA #1 : Hexdump, 4 bytes
0xBFFFE1A4 : 0A00 0F86 ....

2005-05-13-09.33.11.930587-240 I14822G351 LEVEL: Severe
PID : 19010 TID : 558748544 PROC : db2fmp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpOneTimeInit,

probe:110
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFFFF774 : EEFB FFFF ....

2005-05-13-09.33.11.930745-240 I15174G372 LEVEL: Severe
PID : 17764 TID : 606077120 PROC : db2agent

(SAMPLE)
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-18 APPID: *LOCAL.db2inst1.050513125959
FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFmpThread,

probe:20
RETCODE : ZRC=0xFFFFFBEE=-1042

Database Manager Configuration

Node type = Database Server with local and remote clients

Database manager configuration release level = 0x0a00

CPU speed (millisec/instruction) (CPUSPEED) =

3.621306e-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-141
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) =
/db2/home/db2inst1/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) = DB2IADM1
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) =
/db2/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) = 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) =

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) = 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

Knut Stolze wrote:
Christos Kalantzis wrote:

Hello,

I am trying to get JAVA UDFs working in DB2 8.2.2.
I created a class, then I compiled it using with the IBM JDK
included
with DB2. I put the class in the sqllib folder and created a
function
that references the class and the function within that class.

When I run it, this is the message I get.
db2 "select db2inst1.test(0) FROM sysibm.sysdummy1"

1
----------
SQL4301N Java or .NET interpreter startup or communication failed,
reason
code "2". SQLSTATE=58004
It does not complain about not finding the class, or some other
error,
from what I understand. It is saying that it cannot even start the
JVM.

How did you configure DB2 with respect to Java? What is the JDK
path set to
etc.?

Nov 12 '05 #5

Similar topics