Db2 for i: Supported Data Types, Objects, and Operations

This section contains information on supported data types, objects, and operations for Oracle GoldenGate on TimesTen.

Oracle GoldenGate on Db2 for i supports the filtering, mapping, and transformation of data unless otherwise noted in this documentation.

Oracle GoldenGate for Db2 for i runs remotely from a Linux system on a Db2 for i source system to capture data from the transaction journals for replication to a target system. To apply data to a target Db2 for i database, Oracle GoldenGate can run remotely from a Linux system. Oracle GoldenGate communicates with the IBM i system by means of an ODBC connection, and no Oracle GoldenGate software is installed on the Db2 for i target.

Note:

The Db2 for i platform uses one or more journals to keep a record of transaction change data. For consistency of terminology in the supporting administrative and reference Oracle GoldenGate documentation, the terms "log" or "transaction log" may be used interchangeably with the term "journal" where the use of the term "journal" is not explicitly required.