STOREONLINE PARTIAL

Backs up part of a DBEnvironment to tape or serial disk 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. 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.
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

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.
When you execute STOREONLINE PARTIAL you should be in the same directory which contains the DBECon file and SYSTEM DBEFileSet. If you must later restore the DBEnvironment, you must be in the same directory 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.

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, superuser, or you must supply the correct maintenance word to use this command.

Example

   >> storeonline partial

   DBEnvironment Name:  PartsDBE

   Maintenance Word:  MaintenanceWord

   To File Name:  /dev/rmt/0h

   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