
DB2 DataPropagator supports three main replication configurations: data distribution, data consolidation, and update anywhere.
Data distribution configuration
In a single-source configuration, changes are replicated to one or more read-only target tables, which allows you to share data among several sites without reducing the performance of your applications. Applications can use the target tables, which are local copies, so that they don't overload the network or central server.
Data consolidation configuration
In a single-target configuration, changed data flows in the opposite direction from that of data distribution, which receives replication updates from one or more sources. This configuration is useful for maintaining local decision-support data or data warehouses, where each organization provides only part of the data, or if the enterprise needs more data than one source table can provide. By using a local copy of source data, you can analyze the data without competing for production-database resources.