Example 1
In the following example database SAMPLE is backed up to a TSM
server using 2 concurrent TSM client sessions. The backup utility
will compute the optimal number of buffers. The optimal size of the
buffers, in 4 KB pages, is automatically calculated based on the amount
of memory and the number of target devices that are available. The
parallelism setting is also automatically calculated and is based
on the number or processors available and the number of table spaces
to be backed up.
db2 backup database sample use tsm open 2 sessions with 4 buffers
db2 backup database payroll tablespace (syscatspace, userspace1) to
/dev/rmt0, /dev/rmt1 with 8 buffers without prompting
Example 2
Following is a sample weekly incremental backup strategy for a
recoverable database. It includes a weekly full database backup operation,
a daily non-cumulative (delta) backup operation, and a mid-week cumulative
(incremental) backup operation:
(Sun) db2 backup db kdr use tsm
(Mon) db2 backup db kdr online incremental delta use tsm
(Tue) db2 backup db kdr online incremental delta use tsm
(Wed) db2 backup db kdr online incremental use tsm
(Thu) db2 backup db kdr online incremental delta use tsm
(Fri) db2 backup db kdr online incremental delta use tsm
(Sat) db2 backup db kdr online incremental use tsm
Example 3
To initiate a backup operation to a tape device in a Windows environment, issue:
db2 backup database sample to \\.\tape0