Data Mover imp commands

Data Mover commands

IMPORT

Creates database spaces, create nonexistent records and indexes, and appends non-duplicate rows to records

REPLACE_DATA

Variation of the IMPORT command

Use it to delete data in existing tables and insert the corresponding data from the export file

Data Mover command modifiers

IGNORE_DUPS

Ignores duplicate row error from database and continues with the Import

Bulk loading is turned off, so slow in performance

Valid only in bootstrap mode

This is usually followed by Import command

UPDATE_DUPS

Imports a new row and updates an existing row

Valid for both bootstrap mode and regular mode