On Windows, both DB2 OLAP Server and DB2 OLAP Integration Server require JRE 1.3. To enable Java to work with both DB2 OLAP Server and DB2 OLAP Integration Server, you must:
After the Java components are installed on your system, you can use a Java Development Kit (JDK) of your choosing to create your own custom-defined macros and custom-defined functions. A JDK is not supplied with DB2 OLAP Server or DB2 OLAP Integration Server.
The Java Runtime Environment (JRE) is required by DB2 OLAP Server to enable Java-based features, such as custom-defined macros and custom-defined functions. The JRE must be installed on the computer running the DB2 OLAP Server component.
The DB2 OLAP Server installation program copies the files to your workstation. To complete the installation of Java, you need to update your PATH statement:
%JREHOME%\binFor example, you can set your PATH to the following value:
PATH=%JREHOME%\bin;%PATH%
C:\ibm\db2olap\java\jre\binFor example, you can set your PATH to one of the the following values:
PATH= C:\ibm\db2olap\java\jre\bin;%PATH% PATH= %ARBORPATH%\java\jre\bin;%PATH%
If you have already installed a supported version of the Java Runtime Environment, you do not have to reinstall it. However, you must verify that the JAXP component is installed. You must also set the JVMMODULELOCATION parameter to enable DB2 OLAP Server to find and load Java.
To set the JVMMODULELOCATION parameters, you must specify the full path and filename of the Java Virtual Machine (JVM) library. On Windows systems (JRE 1.3), the default location and name of the JVM Library File is:
c:\ibm\db2olap\java\jre\bin\hotspot\jvm.dll
where
c:\ibm\db2olap\
is %ARBORPATH% in this example.
To set the JVMMODULELOCATION:
JVMMODULELOCATION c:\ibm\db2olap\ java\jre\bin\hotspot\jvm.dll