Replace JAR failed in DB2 Development Center on AIX

Joined: Feb 02, 2005 Posts: 1

We moved our DB[V8.1FP7] from one AIX[32bit] to another AIX[64bit] by using backup/restore, ...it's a long story..., then when we buid a java stored procedure in development center, we got following message, and a SQL0444N exception occurred.

##########################################################################
MYDB.EXPORTMSTDATA - Build started.
javac -classpath .:/home/db2inst1/sqllib/java/db2java.zip:/home/db2inst1/sqllib/java/runtime.zip:/home/db2inst1/sqllib/java/sqlj.zip ExportMstData.java
MYDB.EXPORTMSTDATA - Javac completed.
jar cf EXPORTMSTDATA.jar ExportMstData.class
MYDB.EXPORTMSTDATA - Jar file created.
Call SQLJ.DB2_REPLACE_JAR (<</home/db2inst1/.ibm/db2/dc/Projects/bld1107315289621/EXPORTMSTDATA.jar>>,'MYDB.EXPORTMSTDATA')
[IBM][CLI Driver][DB2/AIX64] SQL0444N Routine "SQLJ.DB2_REPLACE_JAR" (specific name "") is implemented with code in library or path "", function "" which cannot be accessed. Reason code: "". SQLSTATE=42724
MYDB.EXPORTMSTDATA - Build failed.
MYDB.EXPORTMSTDATA - Roll back completed successfully.
##########################################################################

We also found a topic with very similar problem but on windows.[http://www.dbforumz.com/DB2-development-center-build-fails-ftopict155415.html]

In this case, we didn't find the temporary Jar file generated by DB2DC. Anybody can help?

regards,
Arthur

External Since: Feb 04, 2005 Posts: 1

Hi,please read the topic: db2 store procedure build failed.(aix 64bit
server)

infact we also move DB[V8.1FP7] from one AIX[32bit] to another
AIX[64bit] by
using backup/restore and same problem happend.

Develop center seems not be able to call the Routine
"SQLJ.DB2_REPLACE_JAR" or "SQLJ.DB2_INSTALL_JAR" etc.

at last , we reinstalled the db2 server to be a Aix[32bit] db , and
restore again,then this issue is gone.
please try it.