HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

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.

MPE/iX 5.5 Documentation