Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AIX ( SQL4301N ) : Error while building ora8. external Stored procedur

Status
Not open for further replies.

synap1974

Programmer
Oct 8, 2003
4
IN
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top