Use the restore request in an Optim™ interoperability service to restore data. You can also export the request to an Optim directory.
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.
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.