IBM Db2 Warehouse command-line interfaces for administrative tasks

The command-line interfaces for performing administrative tasks on the Db2® Warehouse database include the command line processor (CLP) interface and dbsql command.

CLP is the preferred administrative interface because it offers a full function, scriptable environment. To use CLP, you must install the IBM® Data Server Client, which is part of the IBM Data Server Driver Package and the Db2 Warehouse client container. For more information, see Connecting to IBM Db2 Warehouse with the command-line processor (CLP) or Call Level Interface (CLI).

You can use the dbsql interface, which is similar to the IBM Netezza® nzsql command, for running queries. For more information, see The dbsql command.