insert statements. The

 LOAD

 utility validates the uniqueness of the indexes, but it 

does not fire triggers, and does not perform referential or table constraints 

checking.

DB2 LOAD command

The 

LOAD

 utility is capable of efficiently moving large quantities of data into newly 

created tables, or into tables that already contain data.

The load process contains four phases:

1. Load data.

2. Build indexes.

3. Delete rows with a unique key violation or a datalink violation.

4. Copy index data from the system temporary table space to the original table 

space.

See Example 6 5 for a simplified syntax diagram for the

LOAD

 command. For a 

complete syntax description please visit: 

http://www 306.ibm.com/cgi bin/db2www/data/db2/udb/winos2unix/support/v

8document.d2w/report?fn=r0008305.htm

132 

MySQL to DB2 UDB Conversion Guide