Example topics demonstrate backup options.
Example 1 — Full Backup
This example makes a full, attended backup of the database iquser to
two tape devices on UNIX. Before running this backup you must position
the tapes to the start of where the backup files will be written,
and connect to iquser. Then issue the following
command:
BACKUP DATABASE
TO '/dev/rmt/0n'
TO '/dev/rmt/1n'
WITH COMMENT 'Jan 18 full backup of iquser'
The catalog store is backed up first, to /dev/rmt/0n.
The IQ store is backed up next, to both tapes.
Example 2 — Incremental Backup
To make an incremental backup of the same database, this time
using only one tape device, issue the command as follows:
BACKUP DATABASE
INCREMENTAL
TO '/dev/rmt/0n' SIZE 150
WITH COMMENT 'Jan 30 incremental backup of iquser'
Other Examples
An example of how to restore this database from these two
backups is provided later in this chapter.
For examples of backups that specify read-only files and dbspaces,
see the BACKUP
statement in Reference: Statements and Options.