Restoring data with Optim Designer

Use the restore request in an Optim™ interoperability service to restore data. You can also export the request to an Optim directory.

Optim interoperability service

Use the New Restore Service wizard to define parameters in a restore request. These parameters include the name of the source archive file, the name of the data access plan to use as a map the target data, criteria for the data to be restored, the method (load or insert) used to restore the data. Typically, the same data access plan used to create the archive file is used.

Considerations that apply when deciding the method used to restore archived data include: the volume of data, the number of rows to be restored, the need for user access during a restore process, and the need to replace rows and insert rows in one step.

Control file

A control file records information about the success or failure of insert or load processing for each selected row in the archive file. You must specify the name of a control file when you create the restore request. Diagnostics identify why any discarded rows were not processed.

Table map

A table map matches tables in the restored archive file to tables in the destination database. The restore request uses a local table map based on the data access plan selected in the request. You must provide a DB alias and creator ID to qualify table names.

Restore process report

A restore process report is generated as part of the restore process. The report contains general information and statistics about each step of the process and provides details about data that have been restored.