Question & Answer
Question
Answer
If you are replicating from Microsoft SQL Server, follow the steps in IBM IIDR in AlwaysOn environment - Source.
If you are replicating to Microsoft SQL Server, follow the steps in IBM IIDR in AlwaysOn environment - Target.
To summarize, in order to be able to deploy IIDR in a Microsoft SQL Server AlwaysOn environment, you need to:
-
Prepare the AlwaysOn availability group environment for replication.
-
Add symmetrical shared storage for IIDR deployment reachable from all AlwaysOn nodes.
-
Define a Microsoft Windows domain user that can be used to run the IIDR service.
-
Identify shared storage to which the transaction logs can be backed up. The storage must be symmetrically accessible from all AlwaysOn nodes.
-
Define maintenance plans to back up the transaction logs to the backup storage on any number of nodes.
-
Create the IIDR user that can connect to the database on all nodes where it can fail over.
-
Deploy IIDR on the shared symmetrical storage.
-
Create the IIDR service on all nodes to which IIDR can fail during planned or unplanned failover.
-
Add the IIDR service as a dependent resource to the AlwaysOn availability group role that was created in the Windows Server Failover Cluster.
-
Configure the new datastore in IBM Management Console.
Related Information
Product Synonym
CDC;Change Data Capture;CDD;Change Data Delivery;IIDR;IBM InfoSphere Data Replication;IDR;IBM Data Replication
Was this topic helpful?
Document Information
Modified date:
10 June 2020
UID
swg21690158