Symantec Backup Exec

Before you back up DB2 resources, review the following:

• You must run the Remote Agent Utility on the DB2 server and add information about the instances before you can perform any backup or restore operations.

  When DB2 instance information changes, you must update the Remote Agent Utility. After you enter these changes, the Backup Exec media server discovers them.

  See Requirements for the DB2 Agent.

• If you run database backups and archive logging, you must have at least two storage devices that are available for the jobs.

• If you use multiple data streams for the backup job, the number of backup devices that are available for the job must at least equal the number of data streams. If archive logging is enabled for the database, an additional backup device must be available.

To back up DB2 resources

1. On the navigation bar, click the arrow next to Backup.

2. Click New Backup Job.

3. In the backup selection list, under Favorite Resources, expand Windows Systems.

4. Expand the DB2 server that you want to back up.

   If the DB2 server is not listed under Favorite Resources, then you can add it.

   See About the Favorite Resources node in the backup selections list.

5. Select the following objects that you want to back up:

   
   

   Instance	Specifies a database instance to back up. All databases within the instance are backed up.
   Database	Specifies a database to back up. All partitions within the database are also backed up. During a file system backup, online DB2 database files that are included in the selecton list are not automatically excluded. You must manually exclude the datafiles of an online DB2 database from the selection list.
   Partition	Specifies a partition to back up. All partition tablespaces and log folders are backed up.
   Tablespace	Specifies all of the tablespaces or individual tablespaces that you want to back up.

6. On the Properties pane, under Settings, click DB2.

7. Complete the appropriate options.

   See DB2 backup options.

8. To configure multiple data streams for backup, under Destination, click Device and Media.

9. Complete the appropriate options as follows:

   
   

   Maximum number of devices to use for resources that support multiple data streams

   Specifies the maximum number of devices that the backup job can use. When you run a DB2 database backup job, Symantec recommends that the number of backup devices that are available for the job is at least equal to the number of streams. If archive logging is enabled for the database, an additional backup device must be available. If you specify more than one device, you must choose one of the following items as a destination device for the backup job: A device pool. A backup-to-disk folder that has at least two concurrent operations enabled. See Creating a backup-to-disk folder by setting properties. This feature is not available for DBA-initiated jobs.

   Minimum number of devices, terminate job if fewer devices are available

   Specifies the minimum number of devices that the job can use. If the job cannot acquire the minimum number of devices, the job fails. This feature is not available for DBA-initiated jobs.

10. Complete the remaining backup job properties as necessary.