Data Movement Utilities Guide and Reference

Restrictions and Limitations

The following restrictions apply to the import utility:

• This utility does not support the use of nicknames.

• If the existing table is a parent table containing a primary key that is referenced by a foreign key in a dependent table, its data cannot be replaced, only appended to.

• You cannot perform an import replace operation into an underlying table of a summary table defined in refresh immediate mode.

• You cannot import data into a system table or a summary table.

• Views cannot be created through the import utility.

• Referential constraints and foreign key definitions are not preserved when creating tables from PC/IXF files. (Primary key definitions are preserved if the data was previously exported using SELECT *.)

• Because the import utility generates its own SQL statements, the maximum statement size of 64KB may, in some cases, be exceeded.

The following limitations apply to the import utility:

• If an import operation is run against a remote database, and the output message file is very long (more than 60KB), the message file returned to the user on the client may be missing messages from the middle of the import operation. The first 30KB of message information and the last 30KB of message information are always retained.

[ DB2 List of Books | Search the DB2 Books ]