Starting a CLPPlus client session

Before you issue a CLPPlus command, you must first start a CLPPlus session and establish a connection to the database.

Procedure

To start a CLPPlus session and establish a connection to the database:

  • Issue the CLPPLUS command in the command line processor (CLP) or the Db2® Command Window: When prompted, enter your password.
    For example, issue the following CLPPlus command to start the CLPPlus session and use the user ID db2admin to connect to a local SAMPLE database that is listening on port 50000:
    clpplus db2admin@localhost:50000/sample
    
  • On Windows operating system, you can use the menu option:
    1. Click Start > IBM Db2 > CLPPlus.
    2. Specify your user ID and connection information.
    The menu option is not available for the following IBM® data server client installations:
    • IBM Data Server Client
    • IBM Data Server Runtime Client
    • IBM Data Server Driver Package
  • On Linux® operating system, you can use the menu option:
    1. Click Main Menu > IBM Db2 > Db2 Command Line Processor Plus.
    2. Specify your user ID and connection information.
    The menu option is not available for the following IBM data server client installations:
    • IBM Data Server Client
    • IBM Data Server Runtime Client
    • IBM Data Server Driver Package

Results

The CLPPlus prompt (SQL>) is available, and you are connected to the specified database.

What to do next

You can now use CLPPlus commands and related features. Specify the commands at the CLPPlus prompt.

To end the CLPPLus session, issue the EXIT or QUIT CLPPlus command.