Backing up Db2 data
Define regular Db2® backup jobs with options to run and create backup copies to protect your data. You can enable continuous backing up of archive logs so that you can restore a point-in-time copy with rollforward options if required.
Before you begin
During the initial backup, IBM Spectrum® Protect Plus creates a new vSnap volume and NFS share. During incremental backups, the previously created volume is reused. The IBM Spectrum Protect Plus Db2 agent mounts the share on the Db2 server where the backup is to be completed.
Review the following procedures and considerations before you create a backup job definition:- Add the application servers that you want to back up. For the procedure, see Adding a Db2 application server.
- Configure a Service Level Agreement (SLA) Policy. For the procedure, see Defining a Service Level Agreement backup job.
- Before an IBM Spectrum Protect Plus user can implement backup and restore operations, roles and resource groups must be assigned to the user. Grant users access to resources and backup and restore operations through the Accounts pane. For more information, see Managing user access.
- Inventory jobs should not be scheduled to run at the same time as backup jobs.
- Avoid configuring log backups for a single Db2 database with many backup jobs. If a single Db2 database is added to multiple job definitions with log backup enabled, a log backup from one job can truncate a log before it is backed up by the next job. This might cause point-in-time restore jobs to fail.
About this task
The following steps describe how to back up resources that are assigned to an SLA policy. To run an on-demand backup job for one or more resources regardless of whether those resources are already associated with an SLA policy, click Create job, select Ad hoc backup, and follow the instructions in Running an ad hoc backup job.
Procedure
What to do next
When the SLA policy is saved, you choose to run an on-demand backup any time by clicking
Actions for that policy, and selecting Start. The
status in the log changes to show that the backup is Running
.