If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > AIX ( SQL4301N ) : Error while building ora8. external Stored procedures.

View Poll Results: Will Db2 hav callable stored procedures in triggers
Yes 0 0%
No 0 0%
Voters: 0. You may not vote on this poll

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-13-03, 08:17
synap1974 synap1974 is offline
Registered User
 
Join Date: Oct 2003
Posts: 6
Unhappy AIX ( SQL4301N ) : Error while building ora8. external Stored procedures.

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 solutions

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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On