IBM DB2 LOAD Command

This section describes the IBM DB2 LOAD utility, which moves data from files, named pipes, or devices into a DB2 table.

The load utility is capable of efficiently moving large quantities of data into tables. The utility can handle all data types, including large objects (LOBs) and user-defined types (UDTs). The load utility is faster than the import utility, because it writes formatted pages directly into the database, while the import utility performs SQL INSERTs. The load utility does not fire triggers, and does not perform referential or table constraints checking (other than validating the uniqueness of the indexes).

LOAD Command Options