STORE

Makes a static backup of a DBEnvironment on tape.

Scope

SQLUtil

SQLUtil Syntax

>> STORE WARNING: If you are using STORE to support RollForward Recovery through archive logging, you must precede this command with the BEGIN ARCHIVE and COMMIT ARCHIVE commands in ISQL. (See the ALLBASE/SQL DBA Guide under Backup and Recovery for details) 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.
MaintenanceWord: is the Maintenance Word.
StoreFileName: is the device name for the tape device that will receive the backup file.

Description

STORE performs a static backup of a DBEnvironment. You use it when nonarchive logging is in use or when you are using archive logging without the TurboSTORE software. If you are logging in archive mode and TurboSTORE software is available, you normally use STOREONLINE to perform a backup.
When using the STORE command you should be in the group and account which contains the DBECon file and the SYSTEM DBEFileSet. If you must later restore the DBEnvironment, you must be in the same group and account 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" SECT 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. No reply is necessary for the continuation of the store on the new mount.
The DBEnvironment cannot be in use while this command is executed.

Authorization

You must be the DBECreator, have SM capability, or supply the correct Maintenance Word to use this command.

Example

If you are doing a static store in conjunction with archive logging for later use in roll forward recovery, be sure to issue the BEGIN ARCHIVE and COMMIT ARCHIVE statements in ISQL immediately before doing the STORE.

Do not issue these two statements if you are using the STOREONLINE statement to store your DBEnvironment. Do not issue these two statements if you are using nonarchive logging and want to continue in nonarchive mode as these statements will automatically turn on archive logging.



   ISQL=> BEGIN ARCHIVE;



   ISQL=> COMMIT ARCHIVE;





   Exit from ISQL and invoke SQLUtil.



   >> store

   WARNING:  If you are using STORE to support RollForward Recovery

             through archive logging, you must precede this command

             with the BEGIN ARCHIVE and COMMIT ARCHIVE  commands in

             ISQL.  (See the ALLBASE/SQL DBA Guide under Backup and

             Recovery for details)

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

   DBEnvironment Name:  PartsDBE

   Maintenance Word:  MaintWd

   To File Name:  TAPE



   DBEnvironment stored.