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 can reside either on the node where the database resides, or on a remotely connected client. The table being loaded 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
• Using Load with Identity Columns
• Using Load with Generated Columns
• 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 National Language Support
• 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.