IBM Support

Tech Tip: DB2's new CLP Plus utility

Technical Blog Post


Abstract

Tech Tip: DB2's new CLP Plus utility

Body

Starting with version 9.7 DB2 has a new Command Line utility called CLPPlus. This utility can be used to run both commands and scripts and unlike the CLP is included with the Data Server Driver for ODBC and CLI and the Data Server Driver Package. The command to start the utility “clpplus” by default starts a Java Window which on Linux and Unix platforms requires a X Windows server and the DISPLAY environment variable to be set. It is possible to enable the CLPPlus environment without utilizing X Windows by issuing the command “clpplus -nw”. This command will cause CLPPlus to use the current shell for its environment.

Additional information on CLPPlus can be found at the following URLs.

 

A Basic Description of the Utility.

http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.swg.im.dbclient.clpplus.doc%2Fdoc%2Fc0053823.html


CLPPlus command line options.

http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ib…


CLPPlus Commands

http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.swg.im.dbclient.clpplus.doc%2Fdoc%2Fr0053830.html


Running a script file with CLPPlus

http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.swg.im.dbclient.clpplus.doc%2Fdoc%2Ft0053829.html


[{"Business Unit":{"code":"BU029","label":"Data and AI"}, "Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11141690