Data Movement Utilities Guide and Reference

Chapter 3. Load

This section describes the DB2 UDB load utility, which moves data from files, named pipes, or devices into a DB2 table. These data sources must reside on the node where the database resides, and the table must exist. If the table receiving the new data already contains data, you can replace or append to the existing data.

The following topics are covered:

• Load Overview

• Parallelism and Loading

• Privileges, Authorities, and Authorization Required to Use Load

• Using Load

• Checking for Constraints Violations

• Restarting an Interrupted Load Operation

• Using the Load Copy Location File

• LOAD Command

• LOAD QUERY Command

• Load API

• Data Structure: SQLULOAD-IN

• Data Structure: SQLULOAD-OUT

• db2LoadQuery - Load Query API

• File Type Modifiers (Load)

• Exception Table

• Dump File

• Load Temporary Files

• Load Utility Log Records

• Character Set and NLS Considerations

• Example Load Sessions

• Pending States After a Load Operation

• Optimizing Load Performance

• Restrictions and Limitations

• Troubleshooting.

For information about loading DB2 Data Links Manager data, see Using Load to Move DB2 Data Links Manager Data.

[ DB2 List of Books | Search the DB2 Books ]