IBM Books

Load mode

This box contains the mode of the load. To change this mode, click on the down arrow to display a list of valid modes and select one.

The valid modes are:

Insert
Data rows are loaded into the table after any existing table rows. This is the default.

Replace
All existing table data is deleted and the loaded data is inserted. The table definition and index definitions are not changed.

Restart
When a previous load was interrupted, this mode restarts the load.

Terminate
When a previous load was interrupted, this mode terminates that load and moves the table spaces in which the table resides from load pending state to recovery pending state. The table spaces cannot be used until a backup is restored and the table spaces are rolled forward.

Attention: This option is not recommended for general use; it should be selected only if an unrecoverable error occurred.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]