STOREONLINE PARTIAL [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
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
MPE/iX 5.5 Documentation