I have fixed the SQL4300N Java support is not installed... error,

************************************************** *********
But I get another new error SQL4304N .
************************************************** *********
which is the same as that in:
http://dbforums.com/archive/39/2001/09/2/150575

SQL4304N Java stored procedure or user-defined function "<name>",
specific name "<spec-name>" could not load Java class
'COM/ibm/db2/app/sqlejProcs', reason code "<reason-code>".

Cause: The Java class given by the EXTERNAL NAME clause of a CREATE
PROCEDURE or CREATE FUNCTION statement could not be loaded. The reason
codes are:

1
The class was not found on the CLASSPATH.
2
The class did not implement the required interface
("COM.ibm.db2.app.StoredProc" or "COM.ibm.db2.app.UDF") or lacked the
Java "public" access flag.
3
The default constructor failed or was unavailable.

Action: Ensure that the compiled ".class" file is installed in the
CLASSPATH, for example under "sqllib/function". Ensure it implements
the required Java interfaces and is "public".

sqlcode: -4304

sqlstate: 42724

************************************************** *********
Does anyone remember how you solved this problem?
Did you have to modify any configuration parameters? or should
anything be added to the classpath???
************************************************** *********


Thanks,
rajesh


This is how I fixed the sql4300N error

Solution to the problem is:

Before you run Stored Procedure Builder or run Install_Jar, you must
configure DB2 UDB in the following ways:

Set the path for the Java Development Kit (JDK) by entering the
following command from the DB2 Command Window:

DB2 UPDATE DATABASE MANAGER CONFIGURATION USING JDK11_PATH
/opt/java/IBMJava2-13

We recommend that you set the Java heap size to 4096 bytes. From the
DB2 Command Window, enter the following command:

DB2 UPDATE DATABASE MANAGER CONFIGURATION USING JAVA_HEAP_SZ 4096

We recommend that you set the application heap size to 1024 bytes.
From the DB2 Command Window, enter the following command:

DB2 UPDATE DATABASE MANAGER CONFIGURATION FOR database_name USING
APPLEHEAPSZ 1024


Also provide links for libjvm.so, libjava.so and libhpi.so of your JDK
in the /usr/lib directory.

and execute
bash# ldconfig

and then

db2stop
db2start