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
- 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.
- 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.
DB2 Version 9.7 for Linux, UNIX, and Windows