1.8. Replication Support

Replication lets you propagate data to different servers to keep different databases synchronized. Data changes captured at one server are later applied to another (target) server, as illustrated in Figure 1.11. In the figure, the first box shows the source server and the fourth box shows the target server. The second and third boxes contain the “capture” and “apply” components, respectively.

Figure 1.11. DB2 replication environment

[View full size image]

DB2 UDB has built-in support for replication when source and target databases are part of the IBM family, which includes Informix. For databases from other vendors, such as Oracle or SQL Server, the IBM DB2 Information Integrator software is required.