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 File > Run to display the Specify Parameters dialog. This dialog contains three tabs for insert and update/insert processes ─ General, Age Function, and Global Aging. For a delete process, only the General tab is displayed. If you select a process that was run on a different machine, the files might be inaccessible from your machine. Also, one or more files on your machine with the same names as those for the pending process, but generated by a different process, might cause unexpected results.

restart process general tab, explained below

General

The General tab displays the server name and location and names of the source and control files 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. Frequent commits keep page locks to a minimum, but might slow the process. To use the default, clear the entry.
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 or 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 as a product option.

Age function

Use date aging to adjust dates in specified columns and to verify application results on critical dates.

Global aging

You can specify options for global aging to adjust any columns that have a date data type.



Feedback