Optimizing database backup operations to cloud object storage

You can back up an IBM Storage Protect database to cloud object storage. By having a database backup, you can simplify the recovery process in case of a disaster and help to ensure high availability of your system. Ensure that you take steps to optimize the backup operation.

Procedure

  1. Determine the maximum read throughput of the database disk. Complete the steps in Calculating throughput for IBM Storage Protect database disks.
  2. Determine the maximum achievable throughput for data transfer to the object storage system. Complete the steps in Calculating throughput for object storage.
  3. Configure the database backup operation with the optimal number of data streams to ensure that the database backup operation can be completed within the specified time window.
  4. Schedule a full database backup to cloud daily. The starting number of streams that you use depends on the size of the IBM Storage Protect server.

What to do next

Monitor the throughput of daily database backup operations to cloud object storage. Incrementally use more or fewer streams until you achieve the optimal daily throughput or when the disk or object storage maximum throughput is reached. Increase or decrease the streams incrementally, for example, by 5 streams, and record data points for multiple days at a particular setting for precise estimates.