In DB2 11.1, the log record increases the sequence numbers from 6 bytes to 10 bytes. To support this change, Oracle GoldenGate provides a version specific build for DB2 11.1. Starting with Oracle GoldenGate 12.1.2.1.4, two builds are provided to support DB2 z/OS:
- GoldenGate for DB2 10 and earlier versions
- GoldenGate for DB2 11
Make sure you are not using the data sharing group name i.e. ADDO in the extract connection parameter. For example if the data sharing group name is ADDO, and the subsystem SSIDs of the group are ADD1 and ADD2..., please use the SSID name instead. When you use the data sharing group name, GoldenGate will connect to any of the subsystems to access log files from all of the subsystems in the data sharing group. However, during the upgrade process, we need to make sure the GoldenGate extract is connected to a specific subsystem of the group that will not be upgraded to DB2 v11.1 initially. For example,
SOURCEDB ADD1 userid uuuuuu, password ppppppp
To 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:
INCLUDE extract-conn.inc
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.
As soon as you upgrade one member of the data sharing group to DB2 11.1, you can choose to use the new GoldenGate for DB2 z/OS 11 build and connect the extract to that subsystem and capture log records from all the other subsystems in the data sharing group as illustrated below:
The DB2 IFI allows a GoldenGate extract to access log files for all DB2 subsystems that are a part of the DB2 data sharing group no matter which LPAR these subsystems are running in. GoldenGate can capture from all members of a data sharing group even if there are different DB2 subsystem versions. To clarify this further:
Thanks my colleague Mark Geisler, Richard Johnson and Greg Wood for reviewing this doc.This blog is also published at Oracle Data Integration Blog.
- GoldenGate can connect to a DB2 11.1 subsystem and successfully capture log records from DB2 10.1 subsystem(s) that are also a part of the DB2 data sharing group.
- In like manner, GoldenGate can also connect to a DB2 10.1 subsystem and successfully capture log records from DB2 11.1 subsystem(s) that are a part of the DB2 data sharing group.
Thanks my colleague Mark Geisler, Richard Johnson and Greg Wood for reviewing this doc.This blog is also published at Oracle Data Integration Blog.