Backup examples

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

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

To initiate a backup operation to a tape device in a Windows environment, issue:

   db2 backup database sample to \\.\tape0