By Jinyu Wang-Oracle on Apr 30, 2015
After the announcement of DB2 11.1 support in Oracle GoldenGate for DB2 z/OS ,a lot of questions was received on how to setup Oracle GoldenGate when performing the DB2 11.1 upgrade. This blog provides some instructions and explanations.
DB2 11.1 increases the log record sequence numbers from 6 bytes to 10 bytes. The log reading API changed significantly to support the new log record format. Oracle GoldenGate provides support for DB2 11.1 with a version specific build. In other words, starting with Oracle GoldenGate 220.127.116.11.4, two downloadable builds will be provided to support DB2 z/OS:
The diagram below depicts the GoldenGate and data sharing configuration prior to upgrading the first subsystem to DB2 11.1.
SOURCEDB ADD1 userid uuuuuu, password ppppppp
To quickly modify a GoldenGate extract connection to another subsystem in the data sharing group, it is common practice to use an include file to define the connection parameter. For example, the following “extract-conn.inc” file denoted in the “INCLUDE” parameter would contain the connection parameter above:
In this example, you can keep the extract connected to ADD1 while upgrading the other members of the data sharing group to DB2 11.1. Data from all members in the data sharing group will be captured by GoldenGate.
Please refer to KM 1060540.1 if you need more information about the Oracle GoldenGate support for DB2 z/OS data sharing group.
If you have further question or suggestions, please feel free to reach me at @@jinyu512.
(Thanks my colleague Mark Geisler, Richard Johnson and Greg Wood for reviewing this doc.)