DB2 Universal Database™ version 8.2 provides different solutions that you can use to replicate data from and to relational databases. Committed source changes are staged in relational tables before being replicated to target systems.
SQL replication captures changes to sources and uses staging tables to store committed transactional data. The changes are then read from the staging tables and replicated to corresponding target tables. With staging tables, data can be captured and staged once for delivery to multiple targets, in different formats, and at different delivery intervals.
You can replicate continuously, at intervals, or for one time only. Replicating continuously can be useful if your applications need data in near-real-time, such as applications for making airline reservations. Replicating at intervals can be useful for replicating large batches of data during off-peak hours.