Select one radio button to specify where to restart the
load process.
- Number of records to skip
- Specifies that the load operation skips a specified number of records in
the data file and then starts the load at the next record. When you
select this radio button, you can use one of these methods to specify the
number of records that should be skipped:
- Select the up or down arrows to spin through the available choices.
- Type in a value.
You can use this option with the load mode set to Insert,
Replace, or Restart. If you select
Restart, you must use the number of rows at the last successful
consistency point. The default value is 0, meaning the load will start
at the first record.
- Restart at the build phase
- The load is restarted at the build phase. If you select this
option, the load process restarts, no additional rows are loaded, and the
indexes are built for the rows that were already loaded. This radio
button is available only when the load mode is set to
Restart.
- Restart at the delete phase
- The load is restarted at the delete phase. Rows that cause key
violations are deleted from the table.
You can use this option if the message file states that the build phase
completed and all temporary files are unmodified. This radio button is
available only when the load mode is set to Restart.
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]