Tips for Db2 for Windows
Tip #1: How to setup CLPPlus on Windows
Target audience
Those who have difficulties to start CLPPlus on Windows.
Introduction
I was working on Windows and wanted to work with CLPPlus rather than CLP.
But when I entered "clpplus", nothing happened, I just got a new prompt.
Apparently, when you install Db2 on Windows, the setup for CLPPlus is not complete.
This tip explains the setup for CLPPlus on Windows.
The setup
- When you type "clpplus", the program clpplus.bat is to be invoked.
This file resides in
C:\Program Files\IBM\SQLLIB\BIN (assuming your Db2 is installed on C: )
Make sure the PATH environment variable includes this directory.
- Make sure the CLASSPATH environment variable contains
C:\Program Files\IBM\SQLLIB\TOOLS\clpplus.jar
C:\Program Files\IBM\SQLLIB\TOOLS\jline-0.9.93.jar
- Make sure there is a system environment variable JAVA_HOME that contains Java,
e.g., the following two entries:
C:\Program Files\IBM\SQLLIB\java
C:\Program Files\IBM\SQLLIB\java\jdk\jre\bin
Source
Db2 KnowlegeCenter, article "CLPPlus troubleshooting hints and tips"