Administration Guide

Chapter 6. Utilities for Moving Data

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:

• "Using the LOAD Utility"
• "Using the AutoLoader Utility"
• "Using the IMPORT Utility"
• "Using the EXPORT Utility"
• "LOAD, IMPORT, and EXPORT File Formats"
• "Moving Data Between Systems"

Notes:

1. Remember that the instance owner must have read permission to all input data files used in the LOAD process. LOAD is a DB2 server process owned by the instance owner and, as a result, uses the instance owner ID to access all of the files needed in the process. The creators/owners of the data to be loaded must grant the appropriate file permissions to the instance owner.

2. Remember to ensure you have the required file permissions when accessing data from local area networks (LANs).

3. If DB2 for Windows NT has been defined as a Service to the Windows NT operating system, the Service must have a User Account with the required Read/Write file permissions to use LAN resources (drives, directories, and files).

[ DB2 List of Books | Search the DB2 Books ]