Warehouse Manager Installation Guide

Preparing your environment

Before you enable the warehouse transformers, you must:

• Install a warehouse agent. See Installing warehouse agents for more information.
• Install the JDK for your operating system.
• Update the environment variables.
• Update the database manager configuration for the target DB2 instance.
• Update the database configuration for the target database.

Obtaining the JDK

The DB2 Application Development Client includes the JDK for AIX, OS/2, and Windows NT.

• When you install the DB2 Application Development Client on AIX, the JDK is installed if an earlier version of the JDK is not detected.
• When you install the DB2 Application Development Client on OS/2, the JDK is not installed. See the Installation and Configuration Supplement for information about installing the JDK.
• When you install the DB2 Application Development Client on Windows NT, the JDK is always installed.

For more information, see the Installation and Configuration Supplement.

To obtain and install the JDK for the Solaris Operating Environment, go to http://www.sun.com/java/products/platform.html and follow the instructions provided.

Updating the environment variables

This section contains steps for updating environment variables on Windows NT, AIX, and the Solaris Operating Environment.

Updating environment variables on Windows NT

To update the Path and CLASSPATH environment variables:

1. Open the Windows NT Control Panel.
2. Double-click System.
3. Click the Environment tab to view the variables.
4. Click the Path system variable and add the path of the JDK bin subdirectory to the end of the path. The default path is c:\sqllib\java\jdk.
5. Click Set.
6. Click the CLASSPATH system variable. Add the path where the transformers are installed, and the path of the directory that contains the DB2 Java support classes. Separate the path names with a semicolon. If the CLASSPATH variable does not exist, you must define it.

   For example, you might add C:\SQLLIB\FUNCTION;C:\SQLLIB\JAVA\DB2JAVA.ZIP; to your CLASSPATH variable.

7. Click Set.
8. Click OK to close the window.

Updating environment variables on AIX

Make sure that the current directory is in the CLASSPATH variable by entering the following command:

$ echo $CLASSPATH

For example:

 .:/INSTHOME/sqllib/java/db2java.zip

where /INSTHOME is the home directory of the instance owner.

Enter the following commands to change the CLASSPATH variable:

CLASSPATH=.:$CLASSPATH
export CLASSPATH

Make sure that the PATH variable includes /sqllib/bin. For example:

/INSTHOME/sqllib/bin

where /INSTHOME is the home directory of the instance owner.

Make sure that the LIBPATH variable includes /sqllib/lib. For example:

/INSTHOME/sqllib/lib

where /INSTHOME is the home directory of the instance owner.

Updating environment variables on the Solaris Operating Environment

Update the db2profile file, located in the sqllib subdirectory (for example, /home/db2inst1/sqllib), to include jdk11_path/lib/sparc/native_threads in the LD_LIBRARY_PATH variable, where jdk11_path is the subdirectory where the JDK is installed.

Make sure that the current directory is in the CLASSPATH variable by entering the following command:

$ echo $CLASSPATH

For example:

 .:/INSTHOME/sqllib/java/db2java.zip

where /INSTHOME is the home directory of the instance owner.

Enter the following commands to change the CLASSPATH variable:

CLASSPATH=.:$CLASSPATH
export CLASSPATH

Make sure that the PATH variable includes sqllib/bin. For example:

/INSTHOME/sqllib/bin

where /INSTHOME is the home directory of the instance owner.

Updating the database manager configuration

To update the database manager configuration, use the DB2 Command Line Processor to change the following database settings:

• Set the JDK path parameter (JDK11_PATH) to the subdirectory where the JDK is installed:

  UPDATE DATABASE MANAGER CONFIGURATION USING JDK11_PATH path
  

  where path is the subdirectory where the JDK is installed.

• Set the Java Virtual Machine heap size parameter (JAVA_HEAP_SZ) to 4096:

  UPDATE DATABASE MANAGER CONFIGURATION USING JAVA_HEAP_SZ 4096
  

Updating the database configuration

To update the database configuration for the target database, use the DB2 Command Line Processor to set the default application heap parameter (APPLHEAPSZ) for this database to 1024:

UPDATE DATABASE CONFIGURATION FOR warehouse_database_name USING APPLHEAPSZ 1024