Oracle GoldenGate for DB2 z/OS uses the IBM IFI (Instrumentation Facility Interface) API IFCID 306 to acquire change data and use ODBC API to deliver data. Oracle GoldenGate Extract and Replicat processes will use ODBC (Open Database Connectivity) to connect to the DB2 subsystem. For delivery, you can optionally install Oracle GoldenGate DB2Remote on a Linux, UNIX, or Windows system to deliver replicated data to the DB2 target on the z/OS system.
Oracle GoldenGate (OGG) for DB2 z/OS performs non-intrusive data capture from DB2 z/OS, and has been widely used for the following use cases:
- Zero Downtime Migration
- Query Offloading
- Operational Reporting
- Real-time Data Warehouse
- Activate Unix System Services (USS) in full function mode.
- Install Recoverable Resource Manager Services (RRS) for the best performance.
- Install ODBC Driver