Based on client requirements, data replication might be an option to implement high availability or disaster recovery environments. The IBM InfoSphere Replication Server provides two approaches for data replication:
•The first approach is called SQL replication because it is based on DB2 tables. Changes are captured in staging tables with SQL and then shipped to a target database and applied to the target table.
•The second approach is Q replication. It is based on a messaging infrastructure instead of staging tables. Changes are ...