dbload command

The dbload command is an SQL CLI client application that you can use to load data from the local host or a remote client, on all supported client platforms, into IBM® Db2® Warehouse. This command is available only in the Db2 support tools from the Db2 Warehouse client container and Db2 Warehouse image container.

The dbload command processes command-line load options to send queries to the host to create an external table definition, run the insert or select query to load data, and when the load is complete, drop the external table.

The dbload command connects to a database with a database user name and password, like any other Db2 Warehouse application. The user name specifies an account with a particular set of privileges, and the system uses this account to verify access.

The dbload command can load compressed data files which are in gzip format. Any data file that is in gzip format will be automatically decompressed at the Db2 server during the load processing.