Connecting to IBM Db2 Warehouse

You can use command-line interfaces to connect to the database and perform administrative tasks. You can also connect your IBM® or third-party applications to the Db2 Warehouse database.

Connecting to perform administrative tasks

The command-line interfaces for performing administrative tasks on the Db2 Warehouse database include the following ones:

The command line processor (CLP) interface. This interface is preferred because it offers a full function, scriptable environment. For more information, see Connecting to IBM Db2 Warehouse with the command-line processor (CLP) or Call Level Interface (CLI).
The dbsql command. You can use this interface, which is similar to the IBM Netezza® nzsql command, for running queries. For more information, see dbsql command.

Connecting your IBM or third-party application

To connect your application to the database, use one of the following mechanisms, which are listed in priority sequence:

The dashDB connector that comes with the application.
The DB2® connector that comes with the application.
An IBM-supplied driver. The IBM Data Server Driver Package, also known as the Db2 or dashDB driver package, provides a variety of drivers, including JDBC, ODBC, CLI, and .NET. The ODBC and JDBC drivers are preferred because ODBC and JDBC are the most generally supported methods. For information about the driver, see Db2 driver package.