 |
» |
|
|
|
Makes a static backup of part of a DBEnvironment on
tape or disk. Scope | |
SQLUtil only. SQLUtil Syntax - STORE PARTIAL | |
>> STORE PARTIAL 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.
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 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
primarily when nonarchive logging is in use.
If you are logging in archive mode,
you normally use STOREONLINE PARTIAL to perform a partial backup.
When using the STORE PARTIAL command you should be in the
directory
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
directory
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.
The DBEnvironment cannot be in use while this command is executed.
Authorization | |
You must be the DBECreator, superuser, or supply the correct
maintenance word to use this command. Example | |
Invoke SQLUtil
>> store partial
Do you wish to proceed (y/n)?: Y
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.
|
|
