HPlogo ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX Computer Systems > Appendix F SQLUtil

RESTORE PARTIAL

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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.


Feedback to webmaster