Setting up your system to use the DB2 command line processor

The command line processor on DB2® for z/OS® is a Java application that runs under UNIX System Services.

Before you begin

Before you begin setting up the DB2 command line processor, ensure that your system meets the command line processor prerequisites.

Procedure

To set up your system to use the DB2 command line processor:

  1. Modify the CLASSPATH variable in your .profile file to include the clp.jar file. If you install the command line processor into the /usr/lpp/db2a10_base directory, you can issue the following command to modify your CLASSPATH variable: 
    export CLASSPATH=$CLASSPATH:/usr/lpp/db2a10_base/lib/clp.jar
  2. Optional: Define the CLPPROPERTIESFILE environment variable in your .profile file to include the full path name where the properties file is located. You can create your own properties file with any name. A sample properties file is in the directory where the command line processor is installed. If you install the command line processor into the /usr/lpp/db2a10_base directory, you can issue the following command to define the CLPPROPERTIESFILE environment variable in your .profile file: 
    export CLPPROPERTIESFILE=/usr/lpp/db2a10_base/samples/clp.properties
    If the CLPPROPERTIESFILE environment variable is undefined, the command line processor uses default values for all options when it is invoked.
  3. Optional: Define an alias for starting the command line processor in your .profile file:

    For example:

    alias db2="java com.ibm.db2.clp.db2"

Results

Additional instructions for setting up the DB2 command line processor are available in the DB2 command line processor readme file. By default, the DB2 command line processor readme file (README_CLP) is installed into the /usr/lpp/db2a10_base directory.