Oracle GoldenGate Best Practices: Instantiation from a DB2 Source Database

April 9, 2013 | 1 minute read
Text Size 100%:

Introduction

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

Tracy West


Previous Post

Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database

Tracy West | 1 min read

Next Post


Oracle GoldenGate Best Practices: Instantiation from a SQL Server Source Database

Tracy West | 1 min read