DB2 Version 9.7 for Linux, UNIX, and Windows

Backing up data using the Backup wizard

Use the Backup wizard to back up the objects in a database or database partition. First you specify if you want to back up the entire database or database partition, or if you want to back up only selected table spaces or table space partitions, then you make more advanced choices.

Before you begin

To back up a database or a database partition, you must have SYSADM, SYSCTRL, or SYSMAINT authority. Before you create a backup plan: If you change a database configuration file to enable rollforward recovery (using either LOGRETAIN or USEREXIT), you must take an offline backup of the database before it is usable.

Procedure

  1. Open the Backup wizard: From the Control Center, expand the object tree until you find the database or table space object that you want to back up.
    Note: You can select one or more table space objects to back up.
    Right-click the object and select Backup from the pop-up
    Note: The Backup wizard opens. To back up a database partition, open the Backup wizard from the database object. To back up a table space partition, open the Backup wizard from the table space object.
  2. Complete each of the applicable wizard pages. Click the wizard overview link on the first page for more information. The Finish push button is available when you complete enough information for the wizard to back up the objects in your database.