Backup examples

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 BACKUP statement in Chapter 1, “SQL Statements,” in Reference: Statements and Options.