Data Movement Utilities Guide and Reference
This book provides information about, and shows you how to use, the
following IBM DB2 Universal Database (UDB) data movement utilities:
- 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. 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.
- The Load utility moves data into tables, extends existing indexes, and
generates statistics. Load moves 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.
- DataPropagator (DPROP) is a component of DB2 Universal Database that
allows automatic copying of table updates to other tables in other DB2
relational databases.
Other vendor's products that move data in and out of databases are
also available, but are not discussed in this book.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]