Understanding DB2®: Learning Visually with Examples

12.5. The DB2 LOAD Utility

The load utility is another tool you can use to insert data into a table. Note that you cannot run the load tool against a view; the target must be a table that already exists. The major difference between a load and an import is that a load is much faster. Unlike the import tool, data is not written to the database using normal insert operations. Instead, the load utility reads the input data, formats data pages, and writes directly to the database. Database changes are not logged and constraint validations are not performed during a load operation.

12.5.1. The Load Process

Basically, a complete load process consists of four phases.

1.	During the load phase, the load utility scans the input file for any invalid data ...