Backing up DB2 databases

Edit online

To protect data against the possibility of loss, ensure that you back up the DB2® database. Back up single partition, and multi-partition databases with DB2 backup commands.

About this task

For volume group snapshot, refer Configuring Storwize family and SAN Volume Controller dynamic target allocation (SVCDTA).

Procedure

  1. Use the db2 backup commands when you are backing up DB2 databases with IBM® Storage Protect Snapshot.
  2. Log on to one of the production hosts and use the DB2 instance owner ID.
  3. Depending on the database you are backing up, type in one of the following commands:
    • Single partition database: db2 backup db dbname use snapshot
    • Multi-partition database: db2 backup db dbname on all dbpartitionnums use snapshot
    • DB2 pureScale® database: db2 backup db dbname use snapshot
  4. (Optional) To specify a different profile when you back up the database, enter the following command:
    db2 backup db dbname on all dbpartitionnums use snapshot options PROFILE=path to new profile or name of new profile
    Note: Using some storage systems, the snapshot backup requires a certain amount of available space on the target storage pool, so that it can create the snapshot. If there is not enough storage space available, you can increase the capacity on the requested storage pool, or free up some items that are using existing capacity. Check the message for the exact amount of storage space that is required.