Best Practices from Oracle Development's A‑Team

Oracle GoldenGate Best Practices: Instantiation from a DB2 Source Database


This document will outline the Best Practice approach for Instantiating a DB2 target database from a DB2 or other database source system.

Main Article

One of the biggest challenges in creating a DB2 target database for replication is to insure that no collisions or data loss will occur when applying the change data after the initial instantiation of the target database. Oracle GoldenGate has addressed this issue by including functionality to apply the change data to the target at the appropriate CSN (Commit Sequence Number) where no collisions will occur. To use this functionality without incurring any data loss, be sure to use a read consistent image of your source database to do the instantiation and keep track of the CSN of your consistent image. This document provides more details and examples on how to use LOGCSN which is stored in the Oracle GoldenGateTrail Files starting with Oracle GoldenGate version 10.

The complete document can be found on the Oracle Support site under the document ID:1310542.1

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha