Utilities

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.