Optim™ includes the
following processing utilities in addition to the available actions:
- Restart
- Use Restart when an Insert Process does not complete
successfully. A process can terminate unexpectedly due to resource
restrictions, such as space allocation or network failure. When you
use Restart, the process restarts from the last commit point. Move
keeps track of the last successfully committed row in the Extract
File, and restarts the process with the next row in the file.
- Retry
- Use Retry when an Insert Process completed, but
could not be performed for one or more rows in the Extract File. When
a process cannot be performed for a specific row, that row is marked
as discarded. The Retry Process will attempt the previous operation
for the rows that were discarded.
- Calendar
- Use the Calendar Utility to create calendars for
date aging. A sample set of international calendars is provided, including
dates and rules, that you can use immediately. Use the Calendar
Editor to define Dates and Rules specific for your site.
- Schedule
- Use the Schedule Utility to schedule processes to
run at a later time. This reduces the impact on production processing
and enables you to automatically re-execute a process at specific
time intervals.
- Browse Extract and Control Files
- Use the Browse Utility to review Extract Files to
ensure that the extracted data is what you expected and to determine
which Extract File is appropriate for a Convert, Insert, or Load Process.
Use Browse to review Control Files to view the status of each row
or to view only those rows that had errors.
- Export / Import
- Use the Export and Import Utilities to migrate definitions
from one Optim Directory to
another.
- Create
- Use the Create Utility to create objects (e.g.,
tables, primary keys and relationships, indexes, and views) using
the object definitions in the Extract File, without actually inserting
the data.
- Reset Object Cache
- Use the Reset Object Cache Utility to refresh current
database objects or configuration parameters, especially when definitions
are subject to frequent change.