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

1. 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.
2. 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
3. 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"