Java interpreter not starting after update to FP10 (testet with JDK 1.4.1. / 1.4.2)

Janick Bernet

After updating to FP10, everytime i want to execute a stored procedure
it gives me an error "Java or .NET interpreter startup or communication
failed". In the db2diag.log there is an info just bevore the error
saing that it attempts loading "libjvm.so" and also there is something
about an SQL08023 which I could not find any information about.

Anyone had similar problems?

Would appreciate any help/tips which could lead to a solution.

Regards,
Janick

Nov 12 '05 #1

Subscribe Post Reply

2222

Janick Bernet

I just found out that SQL08023, which seems to be SQL8023N, is a
licencing issue (to many connections for the specific licence) which
may or may not have anything to do with the problem. There should not
be any restrictions to the number of connections in our licence; I had
only one connection open at the time anyway.

Nov 12 '05 #2

Knut Stolze

Janick Bernet wrote:

After updating to FP10, everytime i want to execute a stored procedure
it gives me an error "Java or .NET interpreter startup or communication
failed". In the db2diag.log there is an info just bevore the error
saing that it attempts loading "libjvm.so" and also there is something
about an SQL08023 which I could not find any information about.

Anyone had similar problems?

Would appreciate any help/tips which could lead to a solution.

Which platform are you using?

I run into a very similar issue in Linux recently: DB2 couldn't find the
library libjvm.so on my system. The lib is located
under /opt/IBMJava2-141/jre/bin/classic/ . So I created a link in /usr/lib
that points to the install directory. I did the same for libjava.so,
libjsig.so and libhpi.so, which are all to be found
in /opt/IBMJava2-141/jre/bin/ . (I found that hint in some newsgroup.)

An alternative might be to add /opt/IBMJava2-141/jre/bin/
and /opt/IBMJava2-141/jre/bin/classic/ to /etc/ld.so.conf.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Nov 12 '05 #3

Janick Bernet

Hi Knut

that is what normally works, and worked before the update.
Unfortunately, this time the problem seems to be different, as the
error message is always the same wheter you create the symlinks or not
(imo that problem, that you have to create symlinks should be fixed in
recent fixpaks).

Thanks for your help anyway.

Janick

Nov 12 '05 #4

Janick Bernet

Btw, here is the output from dbdiag.log on diaglevel 4 which I think is
related to the problem:
2005-10-18-11.30.39.928621+120 I113552G370 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejSuffixEnv, probe:20
MESSAGE : Setting environment variable:
DATA #1 : Hexdump, 15 bytes
0x109F67A8 : 4C44 5F4C 4942 5241 5259 5F50 4154 48 LD_LIBRARY_PATH

2005-10-18-11.30.39.929218+120 I113923G713 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejSuffixEnv, probe:21
MESSAGE : New value:
DATA #1 : Hexdump, 92 bytes
0x11D4A950 : 2F68 6F6D 652F 6462 3273 7973 7465 6D2F
/home/db2system/
0x11D4A960 : 7371 6C6C 6962 2F6C 6962 3A2F 686F 6D65
sqllib/lib:/home
0x11D4A970 : 2F64 6232 7379 7374 656D 2F73 716C 6C69
/db2system/sqlli
0x11D4A980 : 622F 6675 6E63 7469 6F6E 3A2F 6F70 742F
b/function:/opt/
0x11D4A990 : 4942 4D4A 6176 6132 2D31 3432 2F6A 7265
IBMJava2-142/jre
0x11D4A9A0 : 2F62 696E 2F63 6C61 7373 6963 /bin/classic

2005-10-18-11.30.39.929501+120 I114637G444 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejGetBlocks, probe:22
MESSAGE : Attempting to load JEXT DLL Path:
DATA #1 : Hexdump, 28 bytes
0xBFFED1B0 : 2F68 6F6D 652F 6462 3273 7973 7465 6D2F
/home/db2system/
0xBFFED1C0 : 7371 6C6C 6962 2F6C 6962 3332 sqllib/lib32

2005-10-18-11.30.39.929763+120 I115082G372 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlejGetBlocks, probe:27
MESSAGE : Attempting to load JEXT DLL Name:
DATA #1 : Hexdump, 13 bytes
0x108AF0AC : 6C69 6264 6232 6A65 7874 2E73 6F libdb2jext.so

2005-10-18-11.30.39.931966+120 I115455G373 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSuffixEnv, probe:20
MESSAGE : Setting environment variable:
DATA #1 : Hexdump, 15 bytes
0x109F67A8 : 4C44 5F4C 4942 5241 5259 5F50 4154 48 LD_LIBRARY_PATH

2005-10-18-11.30.39.932260+120 I115829G1006 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSuffixEnv, probe:21
MESSAGE : New value:
DATA #1 : Hexdump, 153 bytes
0x11D4A950 : 2F68 6F6D 652F 6462 3273 7973 7465 6D2F
/home/db2system/
0x11D4A960 : 7371 6C6C 6962 2F6C 6962 3A2F 686F 6D65
sqllib/lib:/home
0x11D4A970 : 2F64 6232 7379 7374 656D 2F73 716C 6C69
/db2system/sqlli
0x11D4A980 : 622F 6675 6E63 7469 6F6E 3A2F 6F70 742F
b/function:/opt/
0x11D4A990 : 4942 4D4A 6176 6132 2D31 3432 2F6A 7265
IBMJava2-142/jre
0x11D4A9A0 : 2F62 696E 2F63 6C61 7373 6963 3A2F 6F70
/bin/classic:/op
0x11D4A9B0 : 742F 4942 4D4A 6176 6132 2D31 3432 2F6A
t/IBMJava2-142/j
0x11D4A9C0 : 7265 2F62 696E 2F63 6C61 7373 6963 3A2F
re/bin/classic:/
0x11D4A9D0 : 6F70 742F 4942 4D4A 6176 6132 2D31 3432
opt/IBMJava2-142
0x11D4A9E0 : 2F6A 7265 2F62 696E 3A /jre/bin:

2005-10-18-11.30.39.932578+120 I116836G373 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSuffixEnv, probe:20
MESSAGE : Setting environment variable:
DATA #1 : Hexdump, 15 bytes
0x109F67A8 : 4C44 5F4C 4942 5241 5259 5F50 4154 48 LD_LIBRARY_PATH

2005-10-18-11.30.39.932746+120 I117210G1149 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSuffixEnv, probe:21
MESSAGE : New value:
DATA #1 : Hexdump, 182 bytes
0x11D4A950 : 2F68 6F6D 652F 6462 3273 7973 7465 6D2F
/home/db2system/
0x11D4A960 : 7371 6C6C 6962 2F6C 6962 3A2F 686F 6D65
sqllib/lib:/home
0x11D4A970 : 2F64 6232 7379 7374 656D 2F73 716C 6C69
/db2system/sqlli
0x11D4A980 : 622F 6675 6E63 7469 6F6E 3A2F 6F70 742F
b/function:/opt/
0x11D4A990 : 4942 4D4A 6176 6132 2D31 3432 2F6A 7265
IBMJava2-142/jre
0x11D4A9A0 : 2F62 696E 2F63 6C61 7373 6963 3A2F 6F70
/bin/classic:/op
0x11D4A9B0 : 742F 4942 4D4A 6176 6132 2D31 3432 2F6A
t/IBMJava2-142/j
0x11D4A9C0 : 7265 2F62 696E 2F63 6C61 7373 6963 3A2F
re/bin/classic:/
0x11D4A9D0 : 6F70 742F 4942 4D4A 6176 6132 2D31 3432
opt/IBMJava2-142
0x11D4A9E0 : 2F6A 7265 2F62 696E 3A3A 2F68 6F6D 652F
/jre/bin::/home/
0x11D4A9F0 : 6462 3273 7973 7465 6D2F 7371 6C6C 6962
db2system/sqllib
0x11D4AA00 : 2F6C 6962 3332 /lib32

2005-10-18-11.30.39.933185+120 I118360G503 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:35
MESSAGE : Attempting to load JNI Path:
DATA #1 : Hexdump, 33 bytes
0xBFFEC9A4 : 2F6F 7074 2F49 424D 4A61 7661 322D 3134
/opt/IBMJava2-14
0xBFFEC9B4 : 322F 6A72 652F 6269 6E2F 636C 6173 7369
2/jre/bin/classi
0xBFFEC9C4 : 63 c

2005-10-18-11.30.39.933434+120 I118864G368 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:36
MESSAGE : Attempting to load JNI DLL Name:
DATA #1 : Hexdump, 9 bytes
0x108AF4BC : 6C69 626A 766D 2E73 6F libjvm.so

2005-10-18-11.30.39.972479+120 I119233G400 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:400
MESSAGE : JVM startup structure. Arguments follow incrementally:
DATA #1 : Hexdump, 16 bytes
0xBFFECCC0 : 0200 0100 0700 0000 50BD D411 0100 0000
.........P.......

2005-10-18-11.30.39.972819+120 I119634G343 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:401
MESSAGE : -Xmx8388608
DATA #1 : Hexdump, 4 bytes
0x11D4BD54 : 0000 0000 ....

2005-10-18-11.30.39.972980+120 I119978G340 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:402
MESSAGE : vfprintf
DATA #1 : Hexdump, 4 bytes
0x11D4BD5C : F2FA 6710 ..g.

2005-10-18-11.30.39.973137+120 I120319G336 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:403
MESSAGE : exit
DATA #1 : Hexdump, 4 bytes
0x11D4BD64 : FCF9 6710 ..g.

2005-10-18-11.30.39.973294+120 I120656G337 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:404
MESSAGE : abort
DATA #1 : Hexdump, 4 bytes
0x11D4BD6C : 28F9 6710 (.g.

2005-10-18-11.30.39.973452+120 I120994G686 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:405
MESSAGE :
-Djava.class.path=/home/db2system/sqllib/java/db2java.zip:/home/db2sys

tem/sqllib/java/db2jcc.jar:/home/db2system/sqllib/java/db2jcc_license_

cu.jar:/home/db2system/sqllib/java/sqlj.zip:/opt/IBMJava2-142/jre/lib:

/opt/IBMJava2-142/jre/lib/rt.jar:/opt/IBMJava2-142/jre/lib/i18n.jar:/o
pt/IBMJava2-142/lib/tools.jar:
DATA #1 : Hexdump, 4 bytes
0x11D4BD74 : 0000 0000 ....

2005-10-18-11.30.39.973651+120 I121681G365 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:406
MESSAGE : -Djava.home=/opt/IBMJava2-142/jre
DATA #1 : Hexdump, 4 bytes
0x11D4BD7C : 0000 0000 ....

2005-10-18-11.30.39.973809+120 I122047G378 LEVEL: Info
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:407
MESSAGE : -Dibm.db2.instance.path=/home/db2system/sqllib
DATA #1 : Hexdump, 4 bytes
0x11D4BD84 : 0000 0000 ....

2005-10-18-11.30.39.978578+120 I122426G365 LEVEL: Error
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:35
MESSAGE : Error from JNI_CreateJavaVM. RC:
DATA #1 : Hexdump, 4 bytes
0xBFFE9D90 : FFFF FFFF ....

2005-10-18-11.30.39.978924+120 I122792G354 LEVEL: Error
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJAttach, probe:5
MESSAGE : JVM startup failed. RC:
DATA #1 : Hexdump, 4 bytes
0xBFFECFAC : 33EF FFFF 3...

2005-10-18-11.30.39.979145+120 I123147G355 LEVEL: Error
PID : 20042 TID : 1024 PROC : db2fmp
INSTANCE: utsystem NODE : 000
FUNCTION: DB2 UDB, BSU Java support, sqlejAttach, probe:10
MESSAGE : Error from sqloJAttach. RC:
DATA #1 : Hexdump, 4 bytes
0xBFFECFD0 : 33EF FFFF 3...

2005-10-18-11.30.39.979444+120 I123503G1004 LEVEL: Error
PID : 20012 TID : 1024 PROC : db2agent
(VVVDEVEL)
INSTANCE: utsystem NODE : 000 DB : VVV
APPHDL : 0-9 APPID: C0A81090.H90D.05D188093033
FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : Hexdump, 136 bytes
0xBFFDDF1C : 5351 4C43 4120 2020 8800 0000 33EF FFFF SQLCA
.....3...
0xBFFDDF2C : 0100 3200 2020 2020 2020 2020 2020 2020 ..2.

0xBFFDDF3C : 2020 2020 2020 2020 2020 2020 2020 2020

0xBFFDDF4C : 2020 2020 2020 2020 2020 2020 2020 2020

0xBFFDDF5C : 2020 2020 2020 2020 2020 2020 2020 2020

0xBFFDDF6C : 2020 2020 2020 2020 5351 4C30 3830 3233
SQL08023
0xBFFDDF7C : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0xBFFDDF8C : 0000 0000 0000 0000 2020 2020 2020 2020 ........

0xBFFDDF9C : 2020 2035 3830 3034 58004

2005-10-18-11.30.39.979964+120 I124508G369 LEVEL: Severe
PID : 20012 TID : 1024 PROC : db2agent
(VVVDEVEL)
INSTANCE: utsystem NODE : 000 DB : VVV
APPHDL : 0-9 APPID: C0A81090.H90D.05D188093033
FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFmpThread, probe:20
RETCODE : ZRC=0xFFFFFBEE=-1042

2005-10-18-11.30.39.980553+120 I124878G1004 LEVEL: Error
PID : 20012 TID : 1024 PROC : db2agent
(VVVDEVEL)
INSTANCE: utsystem NODE : 000 DB : VVV
APPHDL : 0-9 APPID: C0A81090.H90D.05D188093033
FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : Hexdump, 136 bytes
0x1433ECE4 : 5351 4C43 4120 2020 8800 0000 33EF FFFF SQLCA
.....3...
0x1433ECF4 : 0100 3200 2020 2020 2020 2020 2020 2020 ..2.

0x1433ED04 : 2020 2020 2020 2020 2020 2020 2020 2020

0x1433ED14 : 2020 2020 2020 2020 2020 2020 2020 2020

0x1433ED24 : 2020 2020 2020 2020 2020 2020 2020 2020

0x1433ED34 : 2020 2020 2020 2020 5351 4C30 3830 3233
SQL08023
0x1433ED44 : 0000 0000 0000 0000 0000 0000 0000 0000
.................
0x1433ED54 : 0000 0000 0000 0000 2020 2020 2020 2020 ........

0x1433ED64 : 2020 2035 3830 3034 58004

2005-10-18-11.30.49.841266+120 I125883G302 LEVEL: Warning
PID : 19991 TID : 1024 PROC : db2sysc
INSTANCE: utsystem NODE : 000
MESSAGE : Removing FMP from pool
DATA #1 : Hexdump, 12 bytes
0xBFFEA908 : 0000 0000 4A4E 0000 1CA9 FEBF ....JN......

Nov 12 '05 #5

by: John Doe | last post by:

Hello, I'm currently working on a little tool that would benefit from having a little embedded script language. Although I have C++ source code available for such a script language, I have 2...

Java

Does jython depend on java class.

by: angel | last post by:

A java runtime environment includes jvm and java class (for example classes.zip in sun jre). Of course jython need jvm,but does it need java class. Thanx

Python

.NET competes with java-script

by: #pragma once | last post by:

That's all we are expecting from programs written in the managed code; Though a MVP advised not to say that, because after JIT compilation the code runs in the native! Funny, isn't? That means...

.NET Framework

Java Stored procedures cannot get updated class file recognised

by: Alex | last post by:

Hi all, Just been dabbling with java stored procedures and I'm having problems replacing System: db2 8.1.4 on RH 7.1 linux system 1). Look at java jdbc samples as supplied with db2 and run...

DB2 Database

Java Stored procedure

by: Uma | last post by:

DB2I.PROCEDURE1 - Build started. C:\SQLLIB\java\jdk\bin\javac -classpath ".;C:\SQLLIB\java\db2java.zip;C:\SQLLIB\java\runtime.zip;C:\SQLLIB\java\sqlj.zip" "PROCEDURE1.java" DB2I.PROCEDURE1 -...

DB2 Database

Starting University COSC and learning JAVA, advice please :D

by: David Van D | last post by:

Hi there, A few weeks until I begin my journey towards a degree in Computer Science at Canterbury University in New Zealand, Anyway the course tutors are going to be teaching us JAVA wth bluej...

Java

Trying to choose between python and java

by: Anthony Irwin | last post by:

Hi All, I am currently trying to decide between using python or java and have a few quick questions about python that you may be able to help with. #1 Does python have something like javas...

Python

Updating Java routines UDF on db2 UDB V8 FP10

by: zgh1970 | last post by:

Hi, All, I have problem on updating JAVA UDF on db2 UDB V8 FP10 on aix. I just updated a JAVA code used by the JAVA UDF. I deployed this change to our three region (DB2 UDB v8 FP12 and DB2 v8...

DB2 Database

A quick introduction to Java concepts 1

by: r035198x | last post by:

Setting up. Getting started To get started with java, one must download and install a version of Sun's JDK (Java Development Kit). The newest release at the time of writting this article is...

Java

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Java interpreter not starting after update to FP10 (testet with JDK 1.4.1. / 1.4.2)

Similar topics