Part III Using Oracle GoldenGate with IBM DB2 for i

This part describes tasks for configuring and running Oracle GoldenGateon a DB2 for i database. 

With Oracle GoldenGate for DB2 for i, you can:

  • Map, filter, and transform transactional data changes between similar or dissimilar supported DB2 for i versions, and between supported DB2 for i versions and other supported types of databases.

  • Perform initial loads from DB2 for i to target tables in DB2 for i or other databases to instantiate a synchronized replication environment.

Topics:

  • Understanding What's Supported for IBM DB2 for i
    With Oracle GoldenGate on DB2 for i, you can replicate data to and from similar or dissimilar supported DB2 for i versions, or you can replicate data between a DB2 for i database and a database of another type.
  • Preparing the System for Oracle GoldenGate
    This chapter contains guidelines for preparing the DB2 for i system to support Oracle GoldenGate.
  • Configuring Oracle GoldenGate for DB2 for i
    This chapter contains instructions for configuring Oracle GoldenGate to capture source DB2 for i data and apply it to a supported target database.
  • Instantiating and Starting Oracle GoldenGate Replication
    This chapter contains instructions for configuring an initial load of target data, adding the required processes to instantiate replication, and perform the instantiation. The expected outcome of these steps is that source-target data is made consistent (known as the initial synchronization), and that Oracle GoldenGate captures and delivers ongoing transactional changes so that consistency is maintained going forward.
  • Using Remote Journal
    This chapter contains instructions for remote journal preparation and adding a remote journal. Remote Journal support in the IBM DB2 for i operating system provides the ability for a system to replicate, in its entirety, a sequence of journal entries from one DB2 for i system to another. Once setup, this replication is handled automatically and transparently by the operating system. The entries that are replicated are placed in a journal on the target system that is available to be read by an application in the same way as on the source system.