STORE PARTIAL [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
STORE PARTIAL
Makes a static backup of part of a DBEnvironment on tape.
Scope
SQLUtil only.
SQLUtil Syntax - STORE PARTIAL
>> STORE PARTIAL 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. (See the "Backup and
Recovery" chapter of the ALLBASE/SQL Database Administration Guide for
details.) Do you wish to proceed (y/n)?: {y[es]} DBEnvironment Name:
{n[o] }
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: Start backup (y/n)?
{y[es]}
{n[o] }
Parameters
DBEnvironmentName is the name of the DBEnvironment containing the
subset to be stored.
MaintenanceWord is the maintenance word.
StoreFileName is the device name for the tape device that will
receive the backup file.
DBEFilesetName is the name of the DBEFileset to store. You may
enter a list of DBEFileSets one name per line,
followed with 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 with a blank line with a carriage
return to terminate the list.
Description
* STORE performs a static backup of a subset 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 PARTIAL to perform a partial backup.
* When using the STORE PARTIAL command you should be in the group
and account which contains the DBECon file and the SYSTEM
DBEFileSet. If you must later do a partial recovery of the
DBEnvironment you must be in the same group and account from which
the STORE PARTIAL was made.
* 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 a
specified subset of the DBEFiles of a DBEnvironment. Note that
the DBECon file and log files are not stored. If more than one
volume is required to store the DBEnvironment files, a request
will be displayed on the console. The next tape can then be
mounted.
* If a DBEFileSet is specified in a PARTIAL backup, all the DBEFiles
in the DBEFileset will be 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 STORE 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. 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
If you are doing a static STORE PARTIAL in conjunction with archive
logging, for later use in rollforward recovery, be sure you issue the
BEGIN ARCHIVE and COMMIT ARCHIVE statements in ISQL before doing the
STORE PARTIAL.
Do not issue these two statements if you are using the STOREONLINE
PARTIAL statement to store your DBEnvironment. Do not issue these two
statements if you are using nonarchive logging and want to continue in
nonarchive mode (these statements automatically turn on archive logging).
isql=>BEGIN ARCHIVE;
isql=>END ARCHIVE;
Exit ISQL and invoke SQLUtil
>> store partial
Do you wish to proceed (y/n)?: Y
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.
MPE/iX 5.5 Documentation