RESTORE PARTIAL [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
RESTORE PARTIAL
Copies a subset of a DBEnvironment to disk from tape files that were
created using the SQLUtil STORE, STOREONLINE, STORE PARTIAL, or
STOREONLINE PARTIAL commands.
Scope
SQLUtil Only
SQLUtil Syntax - RESTORE PARTIAL
>> RESTORE PARTIAL DBEnvironment Name: DBEnvironmentName From File
Name: StoreFileName Enter File to Restore or Carriage Return to Finish:
SystemFileName Enter File to Restore or Carriage Return to Finish:
Parameters
DBEnvironmentName is the name of the DBEnvironment to be restored.
StoreFileName is the name of the file or tape device where the
stored DBEnvironment files reside.
SystemFileName is the physical name of the DBEFile to be
restored. You may enter a list of file names,
one name per line, with a null line to terminate
the list. Use the STOREINFO command to get the
names of the files stored.
Description
* This command allows you to restore all, or a subset of, the
DBEFiles previously stored with the SQLUtil STORE, STOREONLINE,
STORE PARTIAL or STOREONLINE PARTIAL command.
* DBEFiles must be restored individually, on a file by file basis;
you cannot specify a DBEFileSET name to be restored.
* If you are not logged on to the target group and account, an error
will occur.
* When using RESTORE PARTIAL, if a DBEFile with the same name
already exists in the target group and account, use the PURGEFILE
command to purge it before restoring it.
When using RESTORE PARTIAL you must be in the same group and
account from which the DBEFiles were stored. This is usually the
group and account containing the DBECon file and the SYSTEM
DBEFileSet.
Authorization
Anyone can execute the RESTORE PARTIAL command.
Example
>> restore partial
DBEnvironmentName: PartsDBE.SomeGrp.SomeAcct
From File Name: TAPE
Enter File to Restore or Carriage Return to Finish: OrderDF1
Enter File to Restore or Carriage Return to Finish: OrderXF1
Enter File to Restore or Carriage Return to Finish:
DBEnvironment restored.
MPE/iX 5.5 Documentation