Examples
These examples display common BACKUP procedures for SQL files. Each example is followed by
the command syntax for the procedure:
•
To back up only SQL shorthand views on volume $A, subvolume A:
1> BACKUP $TAPE, $A.A.* WHERE VIEW, AUDITED, LISTALL
•
To back up only SQL programs from volume $A and catalog $C.C:
2> BACKUP $TAPE, $A.*.* WHERE SQLPROGRAM
2> &FROM CATALOG $C.C, AUDITED, LISTALL
•
To explicitly back up index table $B.B.INDX:
3> BACKUP $TAPE, $B.B.INDX, AUDITED, LISTALL, &
3> &INDEXES EXPLICIT
•
To explicitly back up the secondary partition $D.D.PART:
4> BACKUP $TAPE, $D.D.PART, AUDITED, LISTALL &
4> &PARTONLY ON
Backing Up or Converting DP1 and DP2 Files
You can use BACKUP to back up DP1 files, DP2 files, or a mix of DP1 and DP2 files. You can also
use BACKUP to convert files from DP1 to DP2 (or the opposite).
The B40 RVU of the operating system was the last to support DP1 files on disk; the DP1 disk process
does not exist in any C-series, D-series, or G-series RVUs. C-series versions of BACKUP and RESTORE
support DP1 files on tape and can be used to convert files between DP1 and DP2 formats. This is
useful only for transferring files between a C-series system and an A-series or a B-series system or
for restoring an old BACKUP tape containing DP1 files made from an A-series or B-series RVU.
•
When converting files from one disk-process type to another, BACKUP with the PARTONLY
ON option skips all relative files and any DP1 entry-sequenced files that do not have DP2
block sizes. For example, blocks of 1536, 2560, 3072, or 3584 bytes are not compatible
with DP2. An error message gives the names of the skipped files. You must back up these files
without the PARTONLY option.
•
If you specify the PARTONLY ON option, BACKUP backs up entire partitioned files that have
some secondary partitions on remote nodes if you include the DP2FORMAT option. BACKUP
creates the tape in format 2 and converts any DP1 files it encounters to DP2 format.
•
When you include the DP1FORMAT or DP2FORMAT option in the BACKUP command (and
the
backup-files
contain files of multiple types):
1.
BACKUP creates temporary files on the default volume while performing the conversions.
If the file being converted is a partitioned file, BACKUP creates the temporary files on the
volume where the source (primary) file resides.
2.
BACKUP converts the files listed in the
backup-files
on a file-to-file basis. That is, as
it converts each file, BACKUP copies the converted (temporary) disk file onto the specified
tape.
•
If file conversion occurs during a BACKUP procedure, the resulting BACKUP tape always
contains files of all one disk-process type. A BACKUP tape produced without file-conversion
options can contain both DP1 and DP2 files. The BACKUP procedure produces such a tape
if you back up files from disk volumes controlled by each of the two disk processes.
•
Both BACKUP and RESTORE try to adjust extent sizes of individual partitions when converting
partitioned files from one disk-process type to another. If all the records of a relative or
76
BACKUP
