Online Documentation for SQL Manager for DB2

Backup a database


A database backup is created by means of the Backup Database Wizard. To launch it choose Services | iconServices_BackupDatabase Backup Database main menu item.

 

  1. On the first step define the location for a backup: Local device, Tivoli Storage Manager, Vendor library or XBSA.
  2. On the second step set buffer options and define whether to perform an online or offline backup.

You can set

  • number of buffers - number of memory buffers DB2 will use to store backup data prior to sending it off to the target;
  • buffer-size - the size of each of these member buffers;
  • parallelism - the number of table spaces to be backed up in parallel.

Here you can set a backup level. If you do not want to backup the full database you can backup a set of tablespaces if you like (or even a single tablespace). In this case select the Tablespace item from the Backup level drop-down list.

If you want to backup only the data pages that have changed then check the CheckBox Incremental option.

  1. On the third step set additional parameters for backup operation.
  2. If you have selected Tablespaces as the Backup level on the second step then on the fourth step select table spaces to back up.