RESTORE

Copies an entire DBEnvironment to disk from tape files created by using the SQLUtil STORE or STOREONLINE command.

Scope

SQLUtil Only

SQLUtil Syntax

>> RESTORE DBEnvironment Name: DBEnvironmentName From File Name: StoreFileName Restore DBEnvironment (y/n)? { Y [es] N [o]}

Parameters

DBEnvironmentName: is the name of the DBEnvironment to be restored.
StoreFileName: is the formal file designator of the tape device or disk.

Description

This command allows you to restore the DBECon file and all DBEFiles of a DBEnvironment that was saved with the SQLUtil STOREONLINE or STORE command.
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.
The DBEnvironment is restored to its original group and account, and the DBECreator remains the same as when the DBEnvironment was originally created. If there is not an appropriate user, group, or account on the target system, an error will result.
If the user is not logged on to the target group and account, an error will occur.
If a DBEnvironment with the same name already exists in the same group and account, the user must use the PURGEDBE command to purge it before RESTORE will successfully execute.

Authorization

Anyone can restore a DBEnvironment.

Example

   >> restore

   DBEnvironment Name:  PartsDBE.SomeGrp.SomeAcct

   From File Name:  TAPE

   Restore DBEnvironment (y/n)? y



   DBEnvironment restored.