We hav set up a new databse set up on AIX . this externale procedure ora8.. is giveing us a trouble.
since we are new to this ... we need help....
CALL SQLJ.INSTALL_JAR('file:/home/tmsadmin/ora8UDFs.jar','ora8.OBDEV9II')
I get the error
db2 => CALL SQLJ.INSTALL_JAR('file:/home/tmsadmin/ora8UDFs.jar','ora8.OBDEV9II')
SQL4301N Java interpreter startup or communication failed, reason code "0".
SQLSTATE=58004
MY configuration details as follows
$ which java
/usr/java13_64/bin/java
$ java -version
java version "1.3.1"
/home/tmsadmin/sqllib/java
$ ls -l
total 11008
-r--r--r-- 1 bin bin 1796089 Oct 29 2002 Common.jar
-r--r--r-- 1 bin bin 140562 Oct 29 2002 db2fs.jar
-r--r--r-- 1 bin bin 1533694 Oct 29 2002 db2java.zip
-r--r--r-- 1 bin bin 663346 Oct 29 2002 db2jcc.jar
-r--r--r-- 1 bin bin 1493338 Oct 29 2002 sqlj.zip
$ $PATH
ksh: /usr/bin:/etc:/usr/sbin:/usr/ucb:/home/tmsadmin/bin:/usr/bin/X11:/sbin:/usr
/java13_64/bin:.:/home/tmsadmin/sqllib/bin:/home/tmsadmin/sqllib/adm:/home/tmsad
min/sqllib/misc: not found
$ $CLASSPATH
ksh: /home/tmsadmin/sqllib/java/db2java.zip:/home/tmsadmin/sqllib/java/db2jcc.ja
r:/home/tmsadmin/sqllib/java/sqlj.zip:/home/tmsadmin/sqllib/function:.: not fou
nd.
>>dbm get cfg
Monitor health of instance and databases (HEALTH_MON) = OFF
SYSADM group name (SYSADM_GROUP) = TMSADMIN
SYSCTRL group name (SYSCTRL_GROUP) = TMSADMIN
SYSMAINT group name (SYSMAINT_GROUP) =
Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = YES
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Use SNA authentication (USE_SNA_AUTH) = NO
Bypass federated authentication (FED_NOAUTH) = NO
Default database path (DFTDBPATH) = /home/tmsadmin
Default charge-back account (DFT_ACCOUNT_STR) =
Java Development Kit installation path (JDK_PATH) /usr/java13_64
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) /home/tmsadmin/sqllib
/db2dump
since we are new to this ... we need help....
CALL SQLJ.INSTALL_JAR('file:/home/tmsadmin/ora8UDFs.jar','ora8.OBDEV9II')
I get the error
db2 => CALL SQLJ.INSTALL_JAR('file:/home/tmsadmin/ora8UDFs.jar','ora8.OBDEV9II')
SQL4301N Java interpreter startup or communication failed, reason code "0".
SQLSTATE=58004
MY configuration details as follows
$ which java
/usr/java13_64/bin/java
$ java -version
java version "1.3.1"
/home/tmsadmin/sqllib/java
$ ls -l
total 11008
-r--r--r-- 1 bin bin 1796089 Oct 29 2002 Common.jar
-r--r--r-- 1 bin bin 140562 Oct 29 2002 db2fs.jar
-r--r--r-- 1 bin bin 1533694 Oct 29 2002 db2java.zip
-r--r--r-- 1 bin bin 663346 Oct 29 2002 db2jcc.jar
-r--r--r-- 1 bin bin 1493338 Oct 29 2002 sqlj.zip
$ $PATH
ksh: /usr/bin:/etc:/usr/sbin:/usr/ucb:/home/tmsadmin/bin:/usr/bin/X11:/sbin:/usr
/java13_64/bin:.:/home/tmsadmin/sqllib/bin:/home/tmsadmin/sqllib/adm:/home/tmsad
min/sqllib/misc: not found
$ $CLASSPATH
ksh: /home/tmsadmin/sqllib/java/db2java.zip:/home/tmsadmin/sqllib/java/db2jcc.ja
r:/home/tmsadmin/sqllib/java/sqlj.zip:/home/tmsadmin/sqllib/function:.: not fou
nd.
>>dbm get cfg
Monitor health of instance and databases (HEALTH_MON) = OFF
SYSADM group name (SYSADM_GROUP) = TMSADMIN
SYSCTRL group name (SYSCTRL_GROUP) = TMSADMIN
SYSMAINT group name (SYSMAINT_GROUP) =
Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = YES
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Use SNA authentication (USE_SNA_AUTH) = NO
Bypass federated authentication (FED_NOAUTH) = NO
Default database path (DFTDBPATH) = /home/tmsadmin
Default charge-back account (DFT_ACCOUNT_STR) =
Java Development Kit installation path (JDK_PATH) /usr/java13_64
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 3
Diagnostic data directory path (DIAGPATH) /home/tmsadmin/sqllib
/db2dump