Home > Articles > Data > DB2

  • Print
  • + Share This
This chapter is from the book

1.8 Replication Support

Replication lets you propagate data to different servers to keep multiple databases synchronized. This can be useful in situations where a single server is used for day-to-day transaction operations, and where issuing reporting queries at the same time would be costly for performance. By replicating the data to another server, this second server could be used for reporting without disturbing the first server. Figure 1.14 illustrates how the data changes captured at one server are later applied to another (target) server. 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.14

Figure 1.14 DB2 replication environment

DB2 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 WebSphere Replication Server software is required.

  • + Share This
  • 🔖 Save To Your Account