Setting up a Java environment to run the ASNCLP program (Linux, UNIX, Windows)

The ASNCLP program runs in a Java™ environment. On Linux, UNIX, and Windows, your PATH environment variable must contain a path to a Java runtime environment in order to run the ASNCLP program.

Starting with Version 9.7 Fix Pack 2, the ASNCLP program automatically sets the path to a Java runtime environment (JVM) that was installed along with Db2 before it processes commands.

For all Db2® products except the IBM® Data Server Runtime Client, the Db2 Database for Linux®, UNIX, and Windows installation process automatically installs the SDK for Java. If you need to install the SDK, go to the "IBM developer kits" page on IBM developerWorks®: http://www.ibm.com/developerworks/java/jdk/index.html. The IBM SDK for Java must support the code page under which you plan to run the ASNCLP program. When a code set is not supported by the IBM SDK for an operating system, you must run the ASNCLP on another operating system whose SDK supports the code page. For example, character set 5026(Cp290) is not supported by the IBM JDK for HP-UX and Solaris, so you must run the ASNCLP from Linux, AIX®, or Windows.

Use the following procedure if the PATH environment variable does not contain a path to a Java runtime environment.

Procedure

Add the following path to your PATH environment variable:

INSTDIR\java\jdk

Where INSTDIR is the Db2 instance directory. On Linux and UNIX, the instance directory is the INSTDIR/sqllib directory, where INSTDIR is the home directory of the instance owner. On Windows, the instance directory is the \sqllib directory where Db2 was installed.

Examples

To set the PATH environment variable from a UNIX command prompt:

export 
PATH=$PATH
:/u/INSTDIR/sqllib/java/jdk

To set the PATH environment variable from a Windows command prompt:

set PATH=%PATH%;%\INSTDIR\sqllib\java\jdk

Note: On Windows, if the database manager stores the value of the JDK_PATH database configuration parameter as c:\program files\ibm\sqllib\java\jdk, the space in program files can cause a problem for the ASNCLP program. To avoid this problem, change the value of JDK_PATH to c:progra~1\ibm\sqllib\java\jdk. For example:

db2 update dbm cfg using JDK_PATH c:\progra~1\ibm\sqllib\java\jdk