STOREONLINE

Backs up a DBEnvironment to tape and enables archive logging if it is not already in effect.

Scope

SQLUtil

SQLUtil Syntax

>> STOREONLINE 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.

Description

You must have TurboSTORE software on your system to use STOREONLINE. If you do not have TurboSTORE, you must use the STORE command.
STOREONLINE 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.
When you execute STOREONLINE 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 the DBEnvironment was stored.
You issue the STOREONLINE command when the DBEnvironment is in normal use. If archive logging has not previously been in effect, this command enables it.
STOREONLINE cannot be used if there are any pseudo-mapped files configured in your system. Before using STOREONLINE, convert all pseudo-mapped files back to ordinary mapped files using the MOVEFILE command.
The following message appears after the STOREONLINE is complete:
DBEnvironment stored.




	CAUTION: In order for an online backup to be of use for rollforward recovery, all logs containing transactions that were active during the execution of the STOREONLINE command must be available at recovery time. Without all the logs, the backup is worthless. This means that after the STOREONLINE command completes, you should do a STORELOG as soon as possible on any log files that contained active transactions during the time you did the STOREONLINE. The range of sequence numbers of the log files containing transactions active during the STOREONLINE process is indicated at the completion of STOREONLINE. Both the beginning and ending archive log sequence numbers are displayed. You must store all log files in that range to be able to do roll forward recovery, later. If there is a media failure involving the device containing the log files active during the STOREONLINE, and if the failure occurs before the files have been backed up, the DBEnvironment backup will not be usable. For the greatest protection, use dual logging with the dual files on different disk drives.

Authorization

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

Example

   >> storeonline

   DBEnvironment Name:  PartsDBE

   Maintenance Word:  MaintWd

   To File Name:  TAPE



   DBEnvironment stored.



   Begin Archive Log Sequence Number            2

   End Archive Log Sequence Number              3