| copyright | lastupdated | keywords | subcollection | ||
|---|---|---|---|---|---|
|
2023-12-11 |
Db2whc |
{:external: target="_blank" .external} {:shortdesc: .shortdesc} {:codeblock: .codeblock} {:screen: .screen} {:tip: .tip} {:important: .important} {:note: .note} {:deprecated: .deprecated} {:pre: .pre}
{: #br}
A snapshot backup of the database is taken daily. Management and configuration of daily snapshot backups are built into the web console.
You can use the web console to restore from a snapshot backup if needed. While the restore is in progress, all writes in the system are queued, and all reads that don’t depend on the queued writes will continue.
{: #ibm_cloud_br}
The last 7 daily snapshots are retained by default. Snapshot backups are encrypted and stored in block storage local to the Db2 Warehouse on Cloud system. Snapshot backups are free of charge.
{: #aws_br}
The last 7 daily snapshots are retained by default. When deployed on Amazon Web Services, you can use the web console to configure a longer retention period for snapshot backups if desired.
Potentially unlimited snapshots can be retained. Snapshot backups are encrypted and stored in Amazon Web services S3. S3 keeps copies of each snapshot backup across 3 availability zones (AZs) in each region by default, so there are 3 copies of each snapshot backup in total.
With the previous generation of plans, the first 7 snapshot backups on Amazon Web Services are free of charge. You will be charged each month for the capacity required for any additional snapshot backups.
With the current generation of plans, you are charged for all backups. The backup process backs up data on both block and object storage. The backup in this case includes snapshots of block storage and AWS S3 backup of object storage data.
| Cloud provider | Backup frequency | Number of retained backups | Retention period |
|---|---|---|---|
| IBM Cloud | 1 / day | Up to 7 | 7 days; FIFO* rollover |
| Amazon Web Services (previous generation) | 1 / day | Up to 7 by default; Can be increased | 7 days; FIFO* rollover |
| Amazon Web Services (current generation) | 1 / day | 7 by default; can be increased or decreased by configuring retention period | 7 days default; can be increased or decreased; FIFO rollover |
| {: caption="Table 1. Snapshot backup frequency and retention period" caption-side="top"} |
*First in, first out
This feature provides the ability to do full, cumulative incremental, or delta incremental backup of a Db2 schema followed by full restore of the schema or table(s) within the schema. Logical schema backup is a flexible and lightweight way to backup and restore table level data. For more information about this feature, see Schema-level and table-level backup and restore.