IBM Db2 Warehouse client container
The Db2® Warehouse client container provides a
remote shell environment with multiple tools for migrating to, operating, and maintaining Db2 Warehouse. This container is separate from the one that
contains the Db2 Warehouse product image.
The client container contains the following tools. You must run the tools from inside the
container, from the cli prompt, which you obtain by issuing the following command:
docker exec -it client cli- IBM® Data Server Client
- The IBM Data Server Client includes the command line processor (CLP).
For more information, see Connecting to IBM Db2 Warehouse with the command-line processor (CLP) or Call Level Interface (CLI).
- Db2 support tools
- The IBM
Db2 support tools (also referred to as the
dbtoolkit) are a collection of scripts and utilities that are similar to those that are provided
with IBM PureData® System for Analytics (Netezza®) appliances. These scripts and utilities can help with
many common database administrator tasks. The dbtoolkit includes dbsql, which is
similar to the Netezza
nzsql command and that you can use to connect to a Db2 Warehouse database and run queries from a command-line
interface. The dbtoolkit also includes db_migrate, which is a utility for copying
databases or tables from Netezza to Db2 Warehouse, the dsmtop command for
monitoring, and the dbload command for data loading.
For more information, see Db2 support tools.
- IBM Database Harmony Profiler
- You can use the IBM Database Harmony Profiler to assess
the compatibility of IBM PureData System for
Analytics and Oracle applications with Db2 Warehouse.
You can also use the IBM Database Harmony Profiler to convert
SQL for use with Db2 Warehouse.
For more information, see Introducing Database Harmony Profiler.
If you move large amounts of data between the host on which you deployed the client container and Db2 Warehouse or you move data very frequently between that host and Db2 Warehouse, the network latency can impact the performance of operations.