Use the Restore Request Editor to
describe a precise set of archived data and easily restore it to a
database or to create a subset of an archive file. You can define
criteria to list archive files that are likely to contain the data
to restore, and define additional criteria to select specific data.
In addition to providing processing instructions, a restore request
lists archive files that serve as templates for categories of archive
files or contain archived data to restore. The restore request also
lists insert or load requests that can be used to restore selected
data. You can browse the archive files to confirm and review the archived
data before you begin the restore process. You can save a set of parameters
as a named request to be reused, or to use as a model for future requests.
Restore requests are stored in the Optim™ directory.

- Description
- Text that describes the purpose of the request (up to 40 characters).
This information can help identify a restore request in a selection
list.
- Global Selection Criteria Defined
- Indicator for global selection criteria. This check box is available
and selected when you click and
define criteria on the Global Selection Criteria dialog.
Clear this check box to remove global selection criteria and disable
the check box. See Define search or selection criteria.
- Automatically Generate Subset Files at Runtime
When you restore
part of an archive file (that is, a selective restore), the subset
of data to restore is extracted from the archive file and stored in
a subset file. Select this check box to generate a name for each subset
file, as needed. Generated file names are in the form pstnnn,
where nnn is a number that is not used in the name
of an existing subset file. The type of subset file that is created
depends on the configuration entry for the default subset file type. A subset
archive file has an .af extension and an .xf extension is used for
a subset extract file. The files are stored in the default data directory
or in the temporary work directory, according to the option selected
on the Archive tab in Personal Options.
If you clear this check box, you must provide a subset
file name for each archive file to which you have applied selection
criteria. If the name you provide is not fully qualified, the subset
file is stored in the default data directory.
- Compress Subset Files
- Select this check box to compress subset files automatically.
- Delete Subset File after successful Restore
Select this check box to delete any subset files
created during a successful restore process automatically. Subset
files saved on secondary media (for example, a drive for removable
media) are not deleted. You can choose to retain a subset file and
reuse it.
- Continue Processing if Errors
- Select this check box to continue processing any unprocessed archive
files after an error condition. (No prompt is displayed.)
- Archive Files List
A list of the archive files that are referenced by the restore
request.
For a detailed description of the items in this list
see Archive files list.
- Restore Process
Options allow you to choose the method used to
restore data. Select one of the following options:
- Insert
- Use the insert process to restore data. The database is available
to other users during insert processing. Also, an insert process can
provide one-step update/insert processing. See Insert.
- Load
- Use a load process to transform the data into a format appropriate
for a DBMS loader and start the database load utility. For a large
volume of data or because of referential integrity cycles, a load
process might be preferred over an insert process. See Load.
- Insert Request Selection Mode (or Load Request Selection Mode)
Because the data model of your production
database might change over time, you can list several insert or load
requests in the restore request and provide criteria needed during
processing to match an archive file with the appropriate insert or
load request. Use these options to specify the type of criteria used.
During processing, an archive file is matched with listed insert or
load requests based on the Request Selection Mode and
the criteria provided. The first request that matches the archive
file is used to restore data in that archive file. If no match is
found, data from the file is not restored, and an error occurs.
To be used to restore data from an archive file, an
insert or load Request must be compatible with the file. In general,
an insert or load request is compatible if the data model for the Source
File, specified in the request is the same as the data
model for the archive file.
The heading on the
list reflects the Restore Process option you
select. For example, if you select Insert as
the Restore Process, the title is Insert
Request Selection Mode. If Load is
the Restore Process, the title is Load
Request Selection Mode.
The options
are:
- Data Model
- Use the first listed
insert or load request that matches the data model of the archive
file. To match the archive file, the source file in an insert or load
request must contain the same number of tables with the same names.
Also, if the table map used with the insert or load
request references a column map, the column map must apply to the
same columns as in the corresponding table in the archive file, with
compatible data types.
- Date
- Use the first listed insert or load request for
which the specified date range includes the creation date of the archive
file to be restored.
- Description
- Use the first listed insert or load request for
which the specified description matches the description for the archive
file to be restored.
- Group
- Use the first listed insert or load request for
which the specified group matches the group designation for the archive
file to be restored.
- Insert Requests list (or Load Requests list)
Lists the insert requests or the load requests that you can
use to restore data.
The heading on the list reflects the Restore
Process option you select. For example, if you select Insert as
the Restore Process, the title is Insert
Requests List. If Load is the Restore
Process, the title is Load Requests List.
For
a detailed description of the items in this list see Insert or load requests list.
Archive files list
Lists
the archive files that are referenced by the restore request. The
list contains:
- Archive File
- The names of archive files referenced by the restore
request. Archive files are processed in the order in which they are
listed. The order in which files are processed might inadvertently
cause old data to supersede new data. You can change the order by
dragging a grid row number to the wanted position. To remove, add,
or replace archive file names, right-click, and select a command from
the shortcut menu. To browse a listed file, click Browse in
the shortcut menu.
- Status
- The status of each listed archive file.
- (blank)
- The file is valid and accessible.
- Not Found
- The file cannot be found and no archive directory
information is available.
- Inaccessible
- The file is not available to the workstation.
- Invalid
- The listed file is not an archive file.
- Unregistered
- The file is not registered in the archive directory.
- Server
- The name of the server on which the file resides
or (Local) if the file was created on a workstation.
- Group
- Group information from the archive directory. If
a listed file is not registered, the information is obtained directly
from the file and the grid cell is crosshatched. If a file is stored
on a drive that is not accessible directly, the grid cell is blank.
- Created Date
- The date the file was created. This information
is taken from the archive directory. If a listed file is not registered,
the information is obtained directly from the file and the grid cell
is crosshatched. If a file is stored on a drive that is not accessible
directly, the grid cell is blank.
- Description
- Description information from the archive directory.
If a listed file is not registered, the information is obtained directly
from the file and the grid cell is crosshatched. If a file is stored
on a drive that is not accessible directly, the grid cell is blank.
- Modified AD
- A
modified access definition, saved with the restore request, is used
to select archived data to restore. (For example, a modified access
definition may be needed to restore data that uses a start table different
from that used to archive the data.) The Modified AD check
box is selected automatically if you alter the access definition in
the archive file and save the modified version with the restore request.
To edit the original or a modified access definition,
right-click the archive file name and click or .
The access definition is displayed in the Access Definition
Editor. You can then change the start table and the traversal
path, or specify reference tables for restoring data from the archive
file.
Clear the check box to revert to the original
access definition.
- Sel Crit
- The type of selection criteria applied to the archive
file. You must specify selection criteria to selectively restore archived
data.
- Local
- Criteria specific to this file applies.
- To copy global criteria as local, right-click a
grid cell for the file and click Copy Global Selection
Criteria.
- To set all listed archive files to local selection
criteria, right-click a grid cell for a file and click .
- To define or edit local criteria, right-click a
grid cell for the file and click Apply Local Selection
Criteria to open the Local Selection Criteria dialog.
- To use no criteria for a file, right-click a grid
cell for the file and click Remove Selection Criteria.
- Global
- Global criteria apply to this archive file.
- To replace global criteria with local criteria,
right-click a grid cell for the file and click Replace
Global Selection Criteria.
- To use global criteria for this file, right-click
a grid cell for the file and click Use Global Selection
Criteria.
- To set all listed files to global selection criteria,
right-click a grid cell for a file and click .
- To define or edit global criteria, click to open the Global Selection Criteria dialog.
- To use no criteria for an archive file, right-click
a grid cell for the file and click Remove Selection Criteria.
- None
- No selection criteria apply to this archive file.
- To use no criteria for a file, right-click a grid
cell for the file and click Remove Selection Criteria.
- To use no selection criteria for all listed files,
right-click a grid cell for a file and click .
- Restore Row Limit
- Specify the maximum number of rows to restore.
To set no limit to the number of rows to restore, specify zero (0)
or leave blank. The process is terminated if the number of restored
rows exceeds this limit.
- Subset File
- When you restore a subset of data, it is extracted
from the archive file and stored in a subset file. You must provide
a name for the subset file, unless you select Automatically
Generate Subset Files at Runtime. When naming a subset
file, you cannot specify a path to the same drive for removable media
on which the archive file resides.
Right-click the archive files list in the
Restore
Request Editor to display shortcut menu commands. These
commands help you accomplish many tasks needed to define a restore
request. In addition to typical
Cut,
Copy,
Paste ,
Clear,
and
Select All commands, you can select commands
to:
- Remove
- Remove a file name from the list.
- Remove All Archive Files
- Remove all file names from the list.
- Add Archive Files
- Add file names based on information in the archive
directory index or by browsing the file system.
- Replace Archive File
- Replace the selected file name with one from the
archive directory or the file system.
- Browse
- Browse the original or a modified version of the
access definition, or the contents of the archive file. If the restore
request has run, you can also browse the control file generated during
the restore, any subset file, or the restore results that pertain
to that archive file.
When browsing an access definition, you can:
- Change the start table used to begin the restore
process.
- Redefine the relationship traversal path.
- Create new or modify existing substitution variables
to be used in local selection criteria for an archive file.
- Designate a table as a reference table, or remove
the reference table designation for any table.
If you make changes, the modified access definition is saved
with the restore request, without modifying the original.
- Apply Local Selection Criteria
- Display the Local Selection Criteria dialog.
Use this dialog to define, modify, and apply local selection criteria
to the selected archive file.
- Copy Global Selection Criteria
- Copy global selection criteria to replace any local
selection criteria for the selected file. You can open the Local
Selection Criteria dialog and modify the copied criteria,
as necessary. The criteria applies only to the selected file.
- Use Global Selection Criteria
- Apply global selection criteria to the selected
file.
- Remove Selection Criteria
- Remove selection criteria for the selected file.
- Replace Global Selection Criteria
- Copy local selection criteria for the selected
file to replace global selection criteria. You can open the Global
Selection Criteria dialog and modify the copied criteria,
as necessary. The criteria is used with all archive files to which
global selection criteria apply.
- Set All
- Click from the shortcut menu to
remove selection criteria settings for all files listed in the restore
request. Click or from the shortcut menu to apply that setting to all
files listed in the restore request. Local selection criteria must
be defined in order to apply.
- Clear All Modified ADs
- Drop any modified access definitions for listed
files.
- Create Insert (or Load) Request
- Open the Insert Request Editor or Load
Request Editor to create an insert or load request with
the archive file as the Source File. The type
of editor that opens depends on the restore process selection in the Restore
Request Editor. You can create a new, named request or
a local request.
- Determine Insert (or Load) Request Selection
- Evaluate the compatibility of a listed insert or
load request with the selected archive file. If a listed insert or
load request contains a set of parameters suitable for the archive
file, the row that contains the request name flashes briefly. If not,
a message is displayed.
Insert or load requests list
The heading on the Requests list
reflects the Restore Process option you select.
For example, if Insert is selected as the Restore
Process, the heading is Insert Requests.
If Load is the Restore Process,
the heading is Load Requests.
Archived
data is restored using the first insert or load request in the list
that matches the archive file. A match is determined based on criteria
provided to the right of the insert or load request name. You can
change the order of the requests by dragging a grid row number to
the wanted position.
- Request Name
- The insert or load requests that can be used in
the restore process. If a listed request is stored in the directory,
the name is displayed. If an insert or load request is embedded in
the restore request, it is listed as (Local).
Using the shortcut menu, you can add an existing, or
create and add a new insert or load request to the list.
- To add an insert request, right-click the insert requests grid
and click , ,
or .
- To add a load request, right-click the load requests grid and
click , , or .
- To edit a listed request, right‑click the grid and click Edit
Request.
See
Insert for information needed to create
or edit an insert request or
Load for
information needed to create or edit a load request.
Note: If
the Request Selection Mode is Data
Model, you can use the shortcut menu from the archive
files list to create an insert or load request with the selected archive
file as the source file.
- Criteria
- The grid column heading and the criteria used to
match an insert or load request with an archive file varies according
to the selected Request Selection Mode option.
If the Request Selection Mode is Data
Model, the heading is:
- Description
- The data model is the only criteria for this selection
mode. The description for each listed request is displayed for reference.
If the Request Selection Mode is Date,
the headings are: - Start
- Enter the beginning date in a range of archive file creation dates.
- End
- Enter the ending date in a range of archive file creation dates.
If you do not enter a start or end date, any date
is valid. If you enter a start date only, the range includes files
created after the start date but before the current date. If you enter
an end date only, the range includes files created before that date.
If
the Request Selection Mode is Description,
the heading is: - Description
- Enter the case-sensitive archive file description needed for data
to be restored with the insert or load request.
If the Request Selection Mode is Group,
the heading is:- Group
- Enter the case-sensitive group designation needed for data to
be restored with the insert or load request.
Right-click the Requests list
in the Restore Request Editor to display shortcut
menu commands. These commands help you accomplish certain tasks needed
to define a restore request. In addition to typical Cut, Copy, Paste, Clear,
and Select All commands, you can select commands
to:
- Remove
- Remove a request from the list.
- Remove All
- Remove all requests from the list.
- Add Insert Request (or Add Load Request)
- Add a request to the list. Select one of the following commands
from the submenu:
- Existing
- Open the Select an Insert Request dialog
or the Select a Load Request dialog. Use this
dialog to select an existing request from the directory and add it
to the list.
- New Local
- Open the Insert Request Editor or the Load
Request Editor. Use this dialog to create and list a new
local request that is saved with the restore request.
- New Named
- Open the Insert Request Editor or the Load
Request Editor. Use this dialog to create and list a new
named request that is saved in the directory and can be used with
other restore requests.
- Edit Request
- Open the Insert Request Editor or the Load
Request Editor to edit the request selected from the list.
See Insert for information
needed to create or edit an insert request, or Load for information needed
to create or edit a load request.
Menu commands
In
addition to the standard File, Edit,
and Tools commands, you can select the following
commands from the Tools menu.
- Apply Global Selection Criteria
- Open the Global Selection Criteria dialog
and define or edit selection criteria for all files that do not have
local selection criteria. After global selection criteria is defined,
the Global Selection Criteria Defined check
box is available and selected. For information about defining global
selection criteria, see Define search or selection criteria.
- Remove Global Selection Criteria
- Delete global selection criteria specifications.
The Global Selection Criteria Defined check
box is unavailable and cleared. Clearing the Global Selection
Criteria check box has the same effect as selecting this
menu command.