День добрый!

Мучает проблема запуска хранимой процедуры java в DB2.

Пытаюсь сделать
SELECT ADM.JVMVERS('java.version') FROM SYSIBM.SYSDUMMY1
Получаю
Java or .NET interpreter startup or communication failed, reason code "0".. SQLCODE=-4301, SQLSTATE=58004, DRIVER=4.11.69


Трассировка

2011-08-18-14.23.43.949166+240 I1128028G369 LEVEL: Info
PID : 8935 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000


FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:36
MESSAGE : Attempting to load JNI DLL Name:
DATA #1 : Hexdump, 9 bytes
0xF6B1A0BC : 6C69 626A 766D 2E73 6F libjvm.so

2011-08-18-14.23.43.950050+240 I1128398G360 LEVEL: Error
PID : 8935 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:30
MESSAGE : sqloloadmodule failed. RC:
DATA #1 : Hexdump, 4 bytes
0xFEFFF354 : 0A00 0F86 ....

2011-08-18-14.23.43.950248+240 I1128759G355 LEVEL: Error
PID : 8935 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJAttach, probe:5
MESSAGE : JVM startup failed. RC:
DATA #1 : Hexdump, 4 bytes
0xFEFFF3A4 : 34EF FFFF 4...




Знающие люди помогите, как можно понять причину ошибки?

Mark Barinstein,

>db2
DB2 SDK 8.2.9

>uname -a
Linux ssim 2.6.9-89.33.1.ELhugemem #2 SMP Fri Jan 7 14:57:08 IST 2011 i686 i686 i386 GNU/Linux

>/usr/Symantec/sesa-jdk-1.6.0_17/jre/bin/java -version
java version "1.6.0_22"
Java(TM) SE Runtime Environment (build 1.6.0_22-b04)
Java HotSpot(TM) Client VM (build 17.1-b03, mixed mode)

java version "1.6.0_22"
Java(TM) SE Runtime Environment (build 1.6.0_22-b04)
Java HotSpot(TM) Client VM (build 17.1-b03, mixed mode)

переменные накатил так
cd /usr/lib
ln -fs /usr/Symantec/sesa-jdk-1.6.0_17/jre/bin/libjava.so .
ln -fs /usr/Symantec/sesa-jdk-1.6.0_17/jre/bin/classic/libjvm.so .
ln -fs /usr/Symantec/sesa-jdk-1.6.0_17/jre/bin/libhpi.so .

db2 update admin cfg using jdk_path /usr/Symantec/sesa-jdk-1.6.0_17

PATH=/usr/Symantec/sesa-jdk-1.6.0_17/bin:$PATH
PATH=/usr/Symantec/sesa-jdk-1.6.0_17/bin:$PATH
export PATH
LIBPATH=/usr/Symantec/sesa-jdk-1.6.0_17/lib:$LIBPATH
export LIBPATH
LD_LIBPATH_PATH=/usr/Symantec/sesa-jdk-1.6.0_17/lib:
export LD_LIBPATH_PATH
STEPLIB=STEPLIB=DSN820.SDSNLOAD:DSN820.SDSNLOD2:$STEPLIB
STEPLIB=CEE.SCEERUN:$STEPLIB
export STEPLIB
CLASSPATH=/usr/Symantec/sesa-jdk-1.6.0_17/lib/db2jcc.jar:$CLASSPATH
CLASSPATH=/usr/Symantec/sesa-jdk-1.6.0_17/lib/db2jcc_javax.jar:$CLASSP
CLASSPATH=/usr/Symantec/sesa-jdk-1.6.0_17/lib/sqlj.zip:$CLASSPATH
CLASSPATH=/usr/Symantec/sesa-jdk-1.6.0_17/lib/db2jcc_license_cisuz.jar
export CLASSPATH

$ ls -l /usr/Symantec/sesa-jdk-1.6.0_17/lib
total 33520
-rw-r--r-- 1 root root 15644658 Aug 15 13:38 ct.sym
-r--r--r-- 1 root root 1257312 Aug 18 13:57 db2jcc.jar
-r--r--r-- 1 root root 23709 Aug 18 13:58 db2jcc_javax.jar
-rw-r--r-- 1 root root 2068 Aug 18 14:01 db2jcc_license_cisuz.jar
-rw-r--r-- 1 root root 145442 Aug 15 13:38 dt.jar
-rw-r--r-- 1 root root 218066 Aug 15 13:38 htmlconverter.jar
-rw-r--r-- 1 root root 18380 Aug 15 13:38 ir.idl
-rw-r--r-- 1 root root 388075 Aug 15 13:38 jconsole.jar
-rwxr-xr-x 1 root root 4344 Aug 15 13:38 jexec
-rw-r--r-- 1 root root 429 Aug 15 13:38 orb.idl
-rw-r--r-- 1 root root 2393305 Aug 15 13:38 sa-jdi.jar
-rw-r--r-- 1 root root 1515813 Aug 18 13:59 sqlj.zip
-rw-r--r-- 1 root root 12618713 Aug 15 13:38 tools.jar
drwxr-xr-x 6 root root 4096 Aug 15 13:38 visualvm

Переключил на /opt/IBMJava2-142
Проблема таже. Непонятно в какую строну копать. Подскажите с идеями.

Судя по дебагу libjvm.so тянет не оттуда. Как изменить папку для Attempting to load JNI Path?

2011-08-19-14.27.39.841758+240 I4185834G518 LEVEL: Info
PID : 8076 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:35
MESSAGE : Attempting to load JNI Path:
DATA #1 : Hexdump, 47 bytes
0xFEFFC5FC : 2F75 7372 2F53 796D 616E 7465 632F 7365 /usr/Symantec/se
0xFEFFC60C : 7361 2D6A 646B 2D31 2E36 2E30 5F32 322F sa-jdk-1.6.0_22/
0xFEFFC61C : 6A72 652F 6269 6E2F 636C 6173 7369 63 jre/bin/classic

2011-08-19-14.27.39.842007+240 I4186353G369 LEVEL: Info
PID : 8076 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:36
MESSAGE : Attempting to load JNI DLL Name:
DATA #1 : Hexdump, 9 bytes
0xF6B1A0BC : 6C69 626A 766D 2E73 6F libjvm.so

Сразу не обратил внимания
[db2admin@ssim ~]$ db2 update admin cfg using jdk_path /opt/IBMJava2-142
DB20000I The UPDATE ADMIN CONFIGURATION command completed successfully.
[db2admin@ssim ~]$reboot -n
[db2admin@ssim ~]$ db2 get dbm cfg | grep JDK
Java Development Kit installation path (JDK_PATH) = /usr/Symantec/sesa-jdk-1.6.0_22

А что не меняет?

Спасибо за советы, две недели не мог прогрузить библиотеки.
Теперь библиотеки прогрузились. Не могу понять, что еще мешает


2011-08-19-15.49.30.486572+240 I5048199G401 LEVEL: Info
PID : 5130 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:400
MESSAGE : JVM startup structure. Arguments follow incrementally:
DATA #1 : Hexdump, 16 bytes
0xFEFFF28C : 0200 0100 0700 0000 602D 43F5 0100 0000 ........`-C.....

2011-08-19-15.49.30.486819+240 I5048601G345 LEVEL: Info
PID : 5130 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:401
MESSAGE : -Xmx16777216
DATA #1 : Hexdump, 4 bytes
0xF5432D64 : 0000 0000 ....

2011-08-19-15.49.30.487000+240 I5048947G341 LEVEL: Info
PID : 5130 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:402
MESSAGE : vfprintf
DATA #1 : Hexdump, 4 bytes
0xF5432D6C : E828 86F6 .(..

2011-08-19-15.49.30.487179+240 I5049289G337 LEVEL: Info
PID : 5130 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:403
MESSAGE : exit
DATA #1 : Hexdump, 4 bytes
0xF5432D74 : EC27 86F6 .'..

2011-08-19-15.49.30.487356+240 I5049627G338 LEVEL: Info
PID : 5130 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:404
MESSAGE : abort
DATA #1 : Hexdump, 4 bytes
0xF5432D7C : 1827 86F6 .'..

2011-08-19-15.49.30.487535+240 I5049966G691 LEVEL: Info
PID : 5130 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:405
MESSAGE : -Djava.class.path=/dbsesa/db2admin/sqllib/java/db2java.zip:/dbsesa/db2
admin/sqllib/java/db2jcc.jar:/dbsesa/db2admin/sqllib/java/db2jcc_licen
se_cu.jar:/dbsesa/db2admin/sqllib/java/sqlj.zip:/opt/IBMJava2-142/jre/
lib:/opt/IBMJava2-142/jre/lib/rt.jar:/opt/IBMJava2-142/jre/lib/i18n.ja
r:/opt/IBMJava2-142/lib/tools.jar:
lib:/opt/IBMJava2-142/jre/lib/rt.jar:/opt/IBMJava2-142/jre/lib/i18n.ja
r:/opt/IBMJava2-142/lib/tools.jar:
DATA #1 : Hexdump, 4 bytes
0xF5432D84 : 0000 0000 ....

2011-08-19-15.49.30.487790+240 I5050658G366 LEVEL: Info
PID : 5130 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:406
MESSAGE : -Djava.home=/opt/IBMJava2-142/jre
DATA #1 : Hexdump, 4 bytes
0xF5432D8C : 0000 0000 ....

2011-08-19-15.49.30.487970+240 I5051025G380 LEVEL: Info
PID : 5130 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:407
MESSAGE : -Dibm.db2.instance.path=/dbsesa/db2admin/sqllib
DATA #1 : Hexdump, 4 bytes
0xF5432D94 : 0000 0000 ....

2011-08-19-15.49.30.492005+240 I5051406G366 LEVEL: Error
PID : 5130 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJVMstart, probe:35
MESSAGE : Error from JNI_CreateJavaVM. RC:
DATA #1 : Hexdump, 4 bytes
0xFEFFF2F4 : FFFF FFFF ....

2011-08-19-15.49.30.492219+240 I5051773G355 LEVEL: Error
PID : 5130 TID : 4123650592 PROC : db2fmpr
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloJAttach, probe:5
MESSAGE : JVM startup failed. RC: