*************************UPDATED ***********************************
Hello ,
I think there is a possible cause for the error .. The java files seem to have been copied into a directory called
/lpp/db2d10_D10A/base/base/
instead of
/lpp/db2d10_D10A/base/
/lpp/db2d10_D10A/base/base/
Select one or more files with /
. Type Filename
_ Dir .
_ Dir ..
_ Dir bin
_ Dir classes
_ Dir IBM
_ Dir lib
_ File README_CLP
_ Dir samples
/lpp/db2d10_D10A/base/
Select one or more files with
. Type Filename
_ Dir .
_ Dir ..
_ Dir awi
_ Dir base
_ Dir jdbc
_ Dir mql
_ Dir worf
*******************************************************************************
Hello,
Kindly forgive my ignorance about Java.. Please see attached TXT file for full details.
After an upgrade from V12 to V13 and when running the DSNTIJRV job , I see this error with one of our WLM environments DB2XWLM4.
I can see in the output //JSPDEBUG DD SYSOUT=* of DB2XWLM4 that it is searching for the class in the correct directory .
The Java class is available in the JAR file in the below directory and the higher level of the directory is specified in the DB2_BASE parameter of the file db2xenvfile.txt.
I am unable to debug this issue. I would be grateful for your guidance.
Regards
Ram
Menu Utilities Compilers Help
BROWSE SYS3.DBDC.JAVAENVS
Command ===>
********************************* Top of Data *****
XPLINK(ON),
MSGFILE(JSPDEBUG,,,,ENQ),
ENVAR(
"_CEE_ENVFILE=/u/al/public/db/db2xenvfile.txt",
"JVMPROPS=/u/al/public/db/jvmsp")
******************************** Bottom of Data ***
Entered PM28100 version of DSNX9JVM at time: Fri Jul 18 11:03:27 2025
opening stdin, stdout, and stderr files in directory /tmp/java
JVM classpath option string before translate for JVM:
'-Djava.class.path=/usr/include/java_classes/gxljapi.jar:/lpp/db2d10/base/classes/db2javasp.jar:/usr/lpp/db2d10/jdbc/
classes/db2jcc_javax.jar:/usr/lpp/db2d10/jdbc/classes/db2jcc.jar:/usr/lpp/db2d10/jdbc/classes/sqlj.zip:/usr/lpp/db2d10/j
dbc/classes/db2
jcc_license_cisuz.jar:/lpp/db2d10/base/classes/dsntrvfj.jar'
libpath after setenv/getenv: /usr/lpp/db2d10/jdbc/lib:/lpp/db2d10/base/lib:/usr/lpp/java/latest_31/bin:/usr/lpp/java/lat
est_31/bin/classic:/usr/lpp/java/latest_31/bin/j9vm:/usr/lib/java_runtime
JVM properties file string before translate for JVM:
'-Xoptionsfile=/u/al/public/db/jvmsp'
Class com/ibm/db2/dsnx9/JARLoader not found
toString string from error is: java.lang.NoClassDefFoundError: com.ibm.db2.dsnx9.JARLoader
Return Status: Execution=-15, Debug=0
/lpp/db2d10_D10A/base/base/classes/
Select one or more files with / or action codes.
. Type Filename . . . . ::::::
_ Dir .
_ Dir ..
_ File db2javasp.jar
_ File db2provision.jar
_ File db2restudf.jar
_ File DSNNVBCT.jar
_ File dsntrvfj.jar
_ Dir IBM
. . . . . . . . . . . . . . . . . . . . . . . . . . .
File Edit Edit_Settings Menu Utilities Compilers Test Help
EDIT /ALA0/u/al/public/db/db2xenvfile.txt Columns 00001 00072
Command ===> Scroll ===> CSR
****** ***************************** Top of Data ******************************
000001 # 12.07.2025 DB2 V13 -- AL77235 Ram Subramanian
000002 #DB2_BASE=/usr/lpp/db2c10/base --> DB2V12
000003 #JCC_HOME=/usr/lpp/db2c10/jdbc --> DB2V12
000004 DB2_BASE=/usr/lpp/db2d10/base
000005 JCC_HOME=/usr/lpp/db2d10/jdbc
000006 JAVA_HOME=/usr/lpp/java/latest_31
000007 CLASSPATH=/usr/include/java_classes/gxljapi.jar
000008 LIBPATH=/usr/lib/java_runtime
000009 STEPLIB=SYS3.DB2X.SDSNLOAD
****** **************************** Bottom of Data ****************************
jar -tvf /lpp/db2d10_D10A/base/base/classes/db2javasp.jar
. . . . . . . . . . . . . . . . . . . . . . . . . . .
Menu Utilities Compilers Help
BROWSE /tmp/AL77235.09:12:46.427127.ishell Li CHARS 'dsnx9' found
Command ===> Scroll ===> CSR
********************************* Top of Data **********************************
XSLT directory is /usr/lpp/ixm/IBM/xslt4c-1_11.
XML directory is /usr/lpp/ixm/IBM/xml4c-5_7.
Setting DB2 config
#SYSDCS ohne entw/profile, na ist das nix ??
0 Wed Jan 31 21:50:20 CET 2007 META-INF/
62 Wed Jan 31 21:50:20 CET 2007 META-INF/MANIFEST.MF
4328 Mon Mar 20 16:59:16 CET 2006 com/ibm/db2/dsnx9/BlobStream.class
8586 Fri Aug 26 00:31:32 CEST 2011 com/ibm/db2/dsnx9/JARLoader.class