STOREONLINE PARTIAL

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

Scope

SQLUtil

SQLUtil Syntax - STOREONLINE PARTIAL

>> STOREONLINE PARTIAL DBEnvironment Name: DBEnvironmentName Maintenance Word: MaintenanceWord To File Name: StoreFileName Enter DBEFileset name or Carriage Return to Finish: DBEFilesetName Enter DBEFileset name or Carriage Return to Finish: Enter DBEFile name or Carriage Return to Finish: SystemFileName Enter DBEFile name or Carriage Return to Finish:

Parameters

DBEnvironmentName: is the name of the DBEnvironment containing the subset to be stored.
MaintenanceWord: is the Maintenance Word.
StoreFileName: is always the device name for the tape that will receive the backup (backups cannot go to disk).
DBEFilesetName: is name of the DBEFileset to store. You may enter a list of DBEFileSets one name per line, followed by a blank line with a carriage return to terminate the list.
SystemFileName: is the physical name of the DBEFile to store. You may enter a list of DBEFiles one name per line, followed by a blank line with a carriage return to terminate the list.

Description

You must have TurboSTORE software on your system to use STOREONLINE PARTIAL. If you do not have TurboSTORE, you must use the STORE PARTIAL command.
STOREONLINE PARTIAL allows you to create a backup copy of a subset of the DBEFiles of a DBEnvironment. Note that DBECon file and the 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 PARTIAL you should be in the same group and account which contains the DBECon file and SYSTEM DBEFileSet. If you must later restore the DBEnvironment, you must be in the same group and account from which it was stored.
If a DBEFileset name is specified in STOREONLINE PARTIAL, all the DBEFiles in the DBEFileset are stored.
To obtain the SystemFileName of a DBEFile, you can execute a statement that specifies the logical file name. Suppose a DBEFile was created with the following statement:
CREATE DBEFILE OrderDataF1 WITH PAGES = 50, NAME = 'OrderDF1', TYPE = TABLE;
The STOREONLINE PARTIAL command requests the physical file name (SystemFileName), but if it is not remembered, the following statement using the logical file name will display the physical file name:
SELECT FILEID FROM SYSTEM.DBEFILE WHERE DBEFNAME = 'OrderDataF1';
The FILEID column gives the SystemFileName for the DBEFile.
Issue the STOREONLINE PARTIAL command when the DBEnvironment is in normal use. If archive logging has not previously been in effect, this command enables it.
STOREONLINE PARTIAL cannot be used if there are any pseudo-mapped files configured in your system which will take part in the store. Before using STOREONLINE PARTIAL, convert all pseudo-mapped files acted upon by STOREONLINE PARTIAL back to ordinary mapped files using the MOVEFILE command.

The following message appears after the STOREONLINE PARTIAL is complete:

   DBEnvironment stored.



   Begin Archive Log Sequence Number       Number

   End Archive Log Sequence Number         Number




	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 PARTIAL command must be available at recovery time. Without all the logs, the backup is worthless. This means that after the STOREONLINE PARTIAL command completes, you should do a STORELOG as soon as possible on any log files that contained transactions active during the time you did the STOREONLINE. The range of sequence numbers of the log files containing transactions active during the STOREONLINE PARTIAL process is indicated at the completion of STOREONLINE PARTIAL. Both 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, 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 partial

   DBEnvironment Name:  PartsDBE

   Maintenance Word:  MaintenanceWord

   To File Name:  TAPE

   Enter DBEFileset name or Carriage Return to Finish: WarehFS

   Enter DBEFileset name or Carriage Return to Finish: 

   Enter DBEFile name or Carriage Return to Finish: OrderDF1

   Enter DBEFile name or Carriage Return to Finish: 



   DBEnvironment Stored



   Begin Archive Log Sequence Number           2

   End Archive Log Sequence Number             3