f



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

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

0
Janick
10/17/2005 12:58:15 AM
comp.databases.ibm-db2 12448 articles. 3 followers. arunrocks (9) is leader. Post Follow

4 Replies
805 Views

Similar Articles

[PageSpeed] 53

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.

0
Janick
10/17/2005 1:05:35 AM
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
0
Knut
10/17/2005 1:34:31 PM
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

0
Janick
10/18/2005 9:33:21 AM
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......

0
Janick
10/18/2005 9:37:09 AM
Reply: