Live Sync Replication of DB2 Databases

The Live Sync operation replicates backups of a DB2 database to a synced copy of the database. A Live Sync operation is automatically triggered when any kind of backup of the source (primary) DB2 database is made. This automatic operation keeps the replicated target database in sync with the source database, up to the time when the most recent Live Sync operation completes.

The Live Sync operation performs the following tasks:

  • Initiates a replication restore automatically in the following cases:
    • After a Live Sync schedule is created. The whole database is restored to the destination and includes the data, log, and history files.
    • After any backup job is completed on the source database. The backed-up logs are replicated to the destination.
    • After an auxiliary copy is completed, when you use a copy precedence for Live Sync.
  • Minimizes the impact on production systems' CPU and I/O by using the backup data for replications. This approach avoids the need to read the source database again for replication.

DB2 Live Sync supports cross-machine live sync operations or cross-instance live sync operations. In addition, you can set up parallel live sync operations from one backup set to multiple target databases. A cross-machine live sync operation is one in which the destination is a different host than the source machine. A cross-instance live sync operation is one to a different instance on the same source machine.

If no new backups have run since the last Live Sync operation, then the scheduled Live Sync does not run.

Use the following backup types to replicate source DB2 databases. The backups can be initiated by using the CommCell Browser, the command line interface (CLI), or by making a SNAP request.

  • Traditional backups
  • Auxiliary copies
  • SNAP backups

Note: Live Sync sets the replicated destination database with the Roll-forward Pending State turned on. If the Roll-forward Pending State is turned off, subsequent Live Sync operations fail.

Last modified: 2/14/2020 9:15:09 PM