IBM Db2 Warehouse data loading overview

The Db2 Warehouse product provides various mechanisms for loading various types of data into your Db2 Warehouse database.

Web console

You can use the Load option of the web console to quickly and easily load many types of data:

Data from a local or host file: You can use the Load > Load from File option to load data from an Excel file or a delimited text file, such as a comma-separated value (CSV) file. The file can be on either your client or server. You can load initial data into a table, add data to a table, or replace all the data in a table. For more information, see Loading data from a local or host file.
Data from an object store in the cloud: You can use the Load > Load from Cloud option to run or schedule a load into existing tables from an Amazon Simple Storage Service (S3) container (bucket). You can load Amazon S3 data from either a local file or from public data sets from Amazon S3. For more information, see Loading data from Amazon S3.
Geospatial data: You can load a shapefile set by using the Load > Load Geospatial Data option. For more information, see Loading geospatial data.
Publicly available data: You can find publicly available data sets that are shared by government agencies, scientific organizations, and other groups and load that data by using the Load > Load Open Data option.

You can load data by using the console if you have console access (you have the Administrator or User role). If you have the User role, you must also have the INSERT privilege for the table that you are loading into. By default, the Administrator role has the INSERT privilege for all tables.

LOAD command

The LOAD command efficiently loads large amounts of data. The LOAD command also offers a great deal of flexibility in how data is processed, through its parameters and file type modifiers. Data can be in the form of a file, tape, or named pipe. You can also load data by using a user-written script or application.

You can run the LOAD command in the DB2® command line processor (CLP) interface, such as by including the command in a script. To use the CLP, you must install the IBM Data Server Client (such as by deploying the Db2 Warehouse client container) and connect the CLP to Db2 Warehouse. For more information, see Connecting to IBM Db2 Warehouse with the command-line processor (CLP) or Call Level Interface (CLI).

You can also run the LOAD command in the command line processor plus (CLPPlus) interface. CLPPlus is included in the Db2 Warehouse container. For more information, see Loading data using CLPPlus.

For more information about the LOAD command, see LOAD command for IBM Db2 Warehouse. If possible, use the dbload command instead, which is easier to use.

IBM InfoSphere DataStage

IBM InfoSphere® DataStage® integrates data across multiple systems. You can use an InfoSphere DataStage server to load data into your Db2 Warehouse database. For more information, see Loading data from DataStage.

IBM InfoSphere Data Replication

IBM InfoSphere Data Replication can replicate information between heterogeneous data stores in near real time. You can use InfoSphere Data Replication 11.3.3.3-36 or later to load system of record data into your Db2 Warehouse database. You must define database connections and a subscription in InfoSphere Data Replication. For more information, see Loading data from InfoSphere Data Replication.

dbload command

The dbload command is available for use with external tables. This command is part of the dbtoolkit.