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 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.
When running concurrent load operations, the temporary files path names must be unique. If they are not unique (for example, if the TEMPFILES PATH parameter was not specified on any of the concurrently running load jobs), the load utility does not enforce uniqueness, and inconsistent results will be obtained.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]