Restart or Retry a Pending Process

In the grid list, select the entry for the pending process you want to Restart or Retry, and select Run from the File menu or the shortcut menu.

Note: If you select a process that was run on a different machine, the files may be inaccessible from your machine. One or more files on your machine with the same names as those for the pending process, but generated by a different process, may cause unexpected results.

The Specify Parameters dialog is displayed. This dialog contains three tabs for Insert and Update/Insert processes ─ General, Age Function, and Global Aging. For the Delete Process, only the General tab is displayed.

restart process general tab, explained below

General

The General tab displays the Server name and location and names of the Source File and Control File for the selected pending process. Process Options for the new processing attempt can be specified, as follows:

Process Options

Commit Frequency
Number of rows to process before committing the changes to the database. The Commit Frequency is a number from 1 to the maximum limit set as the default in Product Options (refer to the Installation and Configuration Guide ). To use the default, clear the entry.
Note: Frequent commits keep page locks to a minimum, but may slow the process.
Discard Row Limit
Enter 0 or leave blank to impose no limit or enter a number from 1 to 999999999 to stop processing after the specified number of rows are discarded and all rows in the array processed.
Lock Tables
Select to lock database tables when you restart/retry a process. You can lock tables to ensure that other database activity does not interfere with the process attempt and prevent other users from accessing tables involved in the process. The default for locking tables is set by using Product Options (see the Installation and Configuration Guide ).

Age Function

The date aging options allow you to adjust dates in specified columns and to verify application results on critical dates. See the Move User Manual for information on how to specify parameters on the Age Function tab.

Global Aging

You can specify options for Global Aging to adjust any columns that have a date data type. See the Move User Manual for information on how to specify parameters on the Global Aging tab.