Restart/Retry

Use the Restart/Retry Utility to restart a process that terminated abnormally or to retry a process when all rows are not successfully processed. These incomplete processes are referred to as “pending” processes. You can use this utility to restart or retry a Delete, Insert, or Insert/Update Process.

Restart

If a process ends abnormally, either by user request or because of system limitations, you can restart the process from the last commit point. A process can end abnormally when:

Retry

If one or more rows did not process successfully, you can use information in the Control File to correct the problem and retry the process for those rows that did not process successfully. For example, a row may not process successfully when a request conflicts with referential integrity rules (such as when a parent row cannot be deleted because child rows exist for that row).

Contents

This section explains how to use the Restart/Retry Utility to: