Data Movement Utilities Guide and Reference

About This Book

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.
• The Data Warehouse Center (DWC) can be used to move data from operational databases to a warehouse database.

Other vendor's products that move data in and out of databases are also available, but are not discussed in this book.