Loading...

Live Sync Replication of DB2 Databases

The Live Sync feature enables replication from 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 keeps the replicated target database in sync with the source database, up to the time when the last Live Sync operation completes.

The Live Sync feature includes the following capabilities:

  • Initiates a replication restore automatically after a Live Sync schedule is created. The whole database is restored to the destination and includes the data, log, and history files.
  • Initiates a replication restore automatically after any backup job is completed on the source database. The backed up logs are replicated to the destination.
  • Initiates a replication restore automatically 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 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 been run since the last Live Sync, 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 GUI, 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 will fail.

Last modified: 4/26/2019 5:51:43 PM