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: | Other vendor's products that move data in and out of databases are also available, but are not discussed here. |
The following topics are discussed:
Notes: