Data movement utilities and reference

Data movement options
There are various data movement options available in Db2®. This topic provides an overview of the data movement tools, utilities, stored procedures, and commands available to you.
Comparison between the ingest, import, and load utilities
The following tables summarize some of the key similarities and differences between the ingest, import, and load utilities.
File formats and data types
Export utility
Import utility
Load utility
Ingest utility
The ingest utility (sometimes referred to as continuous data ingest, or CDI) is a high-speed client-side Db2 utility that streams data from files and pipes into Db2 target tables. Because the ingest utility can move large amounts of real-time data without locking the target table, you do not need to choose between the data currency and availability.
Other data movement options
Remote storage requirements
Remote storage aliases are supported by a select number of Db2 commands for accessing data on the IBM® Cloud Object Storage or the Amazon Simple Storage Service (S3). In order to use the select Db2 commands, several configurations to the system are required to account for this feature.