Replication Agent for DB2 UDB requires the following to connect to the primary Replication Server:
To support a TCP/IP connection between the Replication Agent and the primary Replication Server, you must provide the IBM z/OS system with information about the Sybase servers and TCP/IP host addresses in your replication system. You do this by editing the SYGWHOST macro, located in the XCPHPING member in the hlq.JCL data set.
The SYGWHOST macro does the following:
Serves as a directory containing network addresses and other information that controls how the Replication Agent connects to other servers
Configures the Open Client component of LTM for MVS to use the MVS TCP/IP protocol for a connection between the Replication Agent and the primary Replication Server
You must create a SYGWHOST macro
entry for each primary Replication Server that receives transactions
from an IBM DB2 Universal Database subsystem in the IBM z/OS
system, and also for any RSSDs that Replication Agents for DB2 UDB
are configured to use. You can define any number of Replication
Servers in the SYGWHOST macro.
The values of the following LTM for MVS configuration parameters must be set as described so that the Replication Agent for DB2 UDB can connect to the primary Replication Server:
Communications_Protocol – must be set to IBMTCP for connectivity to the Replication Server.
RS – the name of the host machine on which the primary Replication Server resides.
RS_user – the user ID that the Replication Agent uses to log in to the primary Replication Server. This user ID must be defined and granted connect source permission in the Replication Server.
The RS_user should not be
identical to the Maintenance User ID specified in the Replication
Server create connection command for the primary
database.
RS_pw – the password for the user ID that the Replication Agent uses to log in to the primary Replication Server.
RS_source_db – the logical database name of the primary database specified in the Replication Server database connection. Sybase recommends using the IBM DB2 Universal Database subsystem or group name.
RS_source_ds – the MVS system that contains the IBM DB2 Universal Database primary database. This value can be arbitrary, as long as it matches the data_server value specified in the Replication Server create connection command for the primary database.
