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.
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.