Q Replication and SQL Replication

Q Replication and SQL Replication are technologies within IBM® Data Replication that move large volumes of data at high speeds to help businesses connect globally distributed operations, respond quickly to customers, and rapidly recover from problems that affect critical database systems.

Event Publishing captures changed-data events and publishes them as IBM MQ messages that can be used by other applications to drive subsequent processing.


The replication server is a collection of smaller programs that track changes to source databases and copy (or "replicate") some or all of the changes to target databases. To detect these changes, a capture process continuously reads the database recovery log, and another process incorporates (or "applies") the changes at the target database.

Two different types of replication are available: Q Replication and SQL Replication.

Event publishing

Data Event Publishing is a form of change-data capture that takes data from a database log and makes it available to consuming applications. Events are published in delimited or Extensible Markup Language (XML) format, or to a database table that can be accessed by applications. This process is ideally suited to data-driven enterprise application integration (EAI) and change-only updating for business intelligence and master-data management.

Events can contain an entire transaction or only a row-level change. Events that are published as messages are put on MQ queues and read by a message broker or other applications such as InfoSphere® DataStage®. You can publish subsets of columns and rows from source tables so that you publish only the data that you need.

You can use Event Publishing for a variety of purposes that require published data, including feeding central information brokers and Web applications and triggering actions based on insert, update, or delete operations at the source tables. Source tables can be relational tables in Db2® for z/OS®, Db2 for Linux®, UNIX, and Windows, and Oracle.

© Copyright IBM Corporation 1993, 2017

ibm.com® and related resources

Training and certification