DB2 SQL Replication

Firms can use DB2 SQL replication to replicate changed data from an operational system to a server used for reporting and analytics, update a remote backup system for disaster recovery purposes, or distribute changed data among multiple databases to support data localization and load balancing. DB2 SQL replication may also be employed to consolidate and load data changes from multiple DB2 databases or DB2 mainframe systems into a data warehouse, or to track changes made to a DB2 database for auditing purposes.

IBM's DB2 SQL replication software technology is included with all editions of DB2 LUW and continues to be used extensively with DB2 z/OS. In recent years, however, IBM has shifted to a newer replication architecture to overcome some of the disadvantages of DB2 SQL replication, namely its high latency and tendency to impose overhead on production systems. IBM's Q Replication solution leverages IBM WebSphere MQ queues to enable real-time, high-performance data replication for use cases in which low-latency and high throughput are a must. The downsides of Q Replication are its cost and its limited support for different source and target systems.

Qlik Replicate is a cost-effective, high-performance data replication platform that leverages low-impact, non-intrusive CDC for database technology to enable real-time data integration and offers support for the widest range of sources and target systems, including all major relational databases, data warehouses, Hadoop distributions and cloud platforms, as well as Kafka message brokers.

Equipped with our non-invasive DB2 CDC technology, which uses DB2 journals to minimize impact on your source systems, Replicate lets you copy, migrate, distribute, and synchronize data from your DB2 systems to your data warehouse—on premises or in the cloud—for real-time data warehousing and analytics. There's no need to install software on your source or target databases, and our intuitive graphical UI makes it easy to set up and execute replication tasks.