【IBM DB2 10.5】Data Movement Utilities Guide and Reference

About this book
This book provides information about and shows you how to use the following
DB2® for Linux, UNIX, and Windows data movement utilities:
v Export and Import
The export and import 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™. The export utility moves
data from a database into operating system files; you can then use those files to
import or load that data into another database.
v Load
The load utility moves data into tables, extends existing indexes, and generates
statistics. The load utility moves data much faster than the import utility when
large amounts of data are involved. Data exported using the export utility can
be loaded using the load utility.
When the load utility is used in a partitioned database environment, large
amounts of data can be distributed and loaded into different database partitions.
For a complete listing of data movement options, see “Data movement options” on
page 1.