Setting up Java on Windows

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:

  1. Set up the environment variables for the Java Runtime Environment (JRE).
  2. Set the JVMMODULELOCATION parameter in the essbase.cfg file to that you can designate a specific installation of the JRE for use with DB2 OLAP Server. This setting is particularly useful if you have multiple versions of Java installed on the computer running the DB2 OLAP Server component.

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.

Setting Java environment variables on Windows

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:

On Windows 2000 and Windows XP, add this variable to your PATH statement:
%JREHOME%\bin
For example, you can set your PATH to the following value:
PATH=%JREHOME%\bin;%PATH%
On Windows NT, add this variable to your PATH statement:
C:\ibm\db2olap\java\jre\bin
For 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.

Setting JVMMODULELOCATION on Windows

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:

  1. On the computer that runs the DB2 OLAP Server component, change to the ARBORPATH\bin directory.
  2. Locate the essbase.cfg file in this directory and open the file in a text editor. If the file does not exist, create and open a new text file named essbase.cfg.
  3. In the essbase.cfg file, add a new line to the end of the file and type JVMMODULELOCATION, followed by the full path and file name of the JVM library file. In the following example, the statement should be all on one line:
    JVMMODULELOCATION c:\ibm\db2olap\
    java\jre\bin\hotspot\jvm.dll
  4. Save the changed text file as essbase.cfg.
  5. Close the file and exit the text editor.