A DB2 data sharing environment is composed of a collection of DB2 subsystems, called a
data sharing group
, that operate from the same DB2 catalog.
Subsystem members of a data sharing group can directly access any table in the DB2 catalog and change the same data while maintaining data integrity. DB2 controls access through grants, plans, and other usual methods.
Before implementing the DB2 ECCR in a data sharing environment, review the following configuration considerations:
In the DB2 bind JCL for the DB2 ECCR in the RUNLIB(XIDDB225) member, you can use either the DB2 group attachment name or the SSID when specifying the SYSTEM operand of the DSN command.
The DB2 ECCR captures changes for tables that are registered under the name that is specified in the RN parameter in the PLAN statement of the REPL2OPT DD data set. The RN parameter can specify the SSID of a data sharing group member or the group attachment name. All tables must be registered under a single DB2 SSID or group attachment name. Informatica recommends that you use a group attachment name for greater flexibility.
The DB2 ECCR uses the CN parameter in the PLAN statement in the REPL2OPT DD data set to attach to DB2. You can specify either a SSID or group attachment name for the CN parameter. The CN parameter is optional unless you need to attach to a specific DB2 subsystem. If the CN parameter is not specified, the ECCR uses the RN parameter value to attach to the subsystem.
To have the flexibility to move the ECCR to another z/OS system that has active members in the same DB2 data sharing group without changing parameters, use the DB2 group attachment name in the CN parameter or default to the RN parameter value. The ECCR must still have access to the PowerExchange Agent and Logger.