The LOAD utility moves data into tables, extends existing indexes, and generates statistics. LOAD moves the data much faster than the IMPORT utility when large amounts of data are involved. Data, unloaded using the EXPORT utility, can be loaded with the LOAD utility.
The AutoLoader utility splits large amounts of data and loads the split data into the different partitions of a partitioned database.
The IMPORT and EXPORT utilities move data between a table or view and another database or spreadsheet program; between DB2 databases; and between DB2 databases and host databases using DB2 Connect.
DataPropagator Relational (DPROPR) is a component of DB2 Universal Database that allows automatic copying of table updates to other tables in other DB2 relational databases.
| Note: | All of the information on these topics, and the comparable topics from the
Command Reference and the Administrative API Reference, have be consolidated into the Data Movement Utilities Guide and Reference.
The Data Movement Utilities Guide and Reference is your primary, single source of information for these topics. |