HPlogo ALLBASE/SQL Database Administration Guide: HP 9000 Computer Systems > Appendix F SQLUtil

STORE

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Makes a static backup of a DBEnvironment on tape or serial disk.

Scope

SQLUtil

SQLUtil Syntax

>> STORE Do you wish to proceed (y/n)?: { Y[es] N[o] } DBEnvironment Name: DBEnvironmentName Maintenance Word: MaintenanceWord To File Name: StoreFileName

Parameters

DBEnvironmentName

is the name of the DBEnvironment to be stored. The DBEnvironment name can be an absolute pathname or a pathname relative to your current working directory; however, the name must be entered exactly the same way when the DBEnvironment is restored.

MaintenanceWord

is the maintenance word.

StoreFileName

is the absolute pathname of the backup file. Relative pathnames are not allowed. The maximum length of a pathname is 44 bytes.

Description

  • STORE performs a static backup of a DBEnvironment. You use it primarily when nonarchive logging is in use. If you are logging in archive mode, you normally use STOREONLINE to perform a backup.

  • When using the STORE command you should be in the directory which contains the DBECon file and the SYSTEM DBEFileSet. If you must later restore the DBEnvironment, you must be in the same directory from which you originated the STORE.

  • If you are using STORE for backups in archive mode, please refer to the section entitled "Static Backup Procedures in Archive Mode" in the "Backup and Recovery" chapter of this guide for a complete description of the procedure.

  • This command allows the user to create a backup copy of the DBECon file and all DBEFiles of a DBEnvironment. Note that log files are not stored. If more than one volume is required to store the DBEnvironment, a request will be displayed on the console. The next tape can then be mounted.

  • The DBEnvironment cannot be in use while this command is executed.

Authorization

You must be the DBECreator or superuser or supply the correct maintenance word to use this command.

Example

Invoke SQLUtil.

   >> store

   Do you wish to proceed (y/n)?:  Y

   DBEnvironment Name:  PartsDBE

   Maintenance Word:  MaintWd

   To File Name:  MyFile



   DBEnvironment stored.

Feedback to webmaster