 |
» |
|
|
|
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" SECT of the
ALLBASE/SQL Database Administration Guide for details.)
Do you wish to proceed (y/n)? { Y [es] N [o]} 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:
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" SECT 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.
|
|
