Data Movement Utilities Guide and Reference

Restrictions and Limitations

The following restrictions apply to the load utility:

• This utility does not support the use of nicknames.
• Loading data into typed tables, or tables with structured type columns, is not supported.
• Loading data into declared temporary tables is not supported.
• Attempts to create or to drop tables in a table space that is in load pending state will fail.
• You cannot load data into a database accessed through DB2 Connect or a down-level server prior to DB2 Version 2. Options that are only available with this release of DB2 cannot be used with a server from the previous release.
• If an error occurs during a LOAD REPLACE operation, the original data in the table is lost. Retain a copy of the input data to allow the load operation to be restarted.
• Triggers are not activated on newly loaded rows. Business rules associated with triggers are not enforced by the load utility.