Data Movement Utilities Guide and Reference

How this Book is Structured

The following topics are covered:

Chapter 1, "Export"

Describes the DB2 export utility, used to move data from DB2 tables into files.

Chapter 2, "Import"

Describes the DB2 import utility, used to move data from files into DB2 tables or views.

Chapter 3, "Load"

Describes the DB2 load utility, used to move large volumes of data from files into DB2 tables.

Chapter 4, "AutoLoader"

Describes the AutoLoader utility, which splits large amounts of data and loads the split data into the different partitions of a partitioned database.

Chapter 5, "Moving DB2 Data Links Manager Data"

Describes how to use the DB2 export, import, and load utilities to move DB2 File Manager data.

Chapter 6, "Moving Data Between Systems"

Describes how to use the DB2 export, import, and load utilities to transfer data across platforms, and to and from DRDA host databases. DataPropagator (DPROP), another method for moving data between databases in an enterprise, is also described. Also introduces the Data Warehouse Center (DWC), which can be used to move data from operational databases to a warehouse database.

Appendix A, "How to Read the Syntax Diagrams"

Explains the conventions used in syntax diagrams.

Appendix B, "Differences Between the Import and the Load Utility"

Summarizes the important differences between the DB2 load and import utilities.

Appendix C, "Export/Import/Load Utility File Formats"

Describes external file formats supported by the database manager export, import, and load utilities.

Appendix D, "Warning, Error, and Completion Messages"

Provides information about interpreting messages generated by the database manager when a warning or error condition has been detected.