HP 3000 Manuals

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