STORE [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
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]} DBEnvironment Name:
{N[o] }
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" 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. 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
[REV BEG]
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.[REV END]
>> 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.
MPE/iX 5.5 Documentation