Stelo Blog

IBM DB2 LUW Data Replication With SQDR

IBM DB2 LUW Data Replication With SQDR


IBM DB2 LUW data replication with SQDR replicates data in real-time from iSeries and AS400 databases to other relational databases, the cloud, and Big Data stores. SQDR utilizes log-based change data capture to minimize latency, maximize scalability, ensure accuracy, and optimize performance, making it one of the most powerful data integration tools available today. In addition to DB2 LUW, SQDR supports DB2 for i and popular data stores including Oracle, Microsoft SQL Server, MySQL, Informix, Big Data platforms, and more.

Why Replicate?

The short answer is simple: data availability. Information is the lifeblood of modern business and replication ensures that accurate, current data flows freely across an organization. Efficiently sharing data optimizes reporting, analysis, app development, high availability, and other mission-critical functions.

SQDR excels in heterogenous environments, seamlessly replicating DB2 LUW-originated data into other data stores at latencies of less than one second. As such, IT professionals can utilize the unique characteristics of non-DB2 LUW data stores with up-to-date DB2 LUW data.

Here are the most common ways that StarQuest clients leverage SQDR to improve performance, reduce costs, and minimize risk:

  1. Reducing Load on Legacy Systems
    Reporting on legacy DB2 LUW databases tends to either reduce performance or require expensive hardware upgrades to offset those performance reductions. As such, many organizations offload their reporting to a data store that scales more cost-effectively such as Microsoft SQL Server.
  2. Zero Downtime Cloud Migrations
    Companies are increasingly migrating to Azure, Amazon Web Services, and private clouds. However, maintaining data integrity and preventing interruption of mission-critical functions during the migration can be a major obstacle.  Real-time data replication solves this by creating a parallel environment so that an IT professional can test the migration thoroughly before permanently shifting to the cloud.
  3. Big Data & Business Intelligence
    Big Data platforms such as Cloudera or Hortonworks offer powerful new business intelligence capabilities that DB2 LUW does not. SQDR replicates DB2 LUW to Kafka to make accurate, up-to-date data available to Big Data platforms, unlocking the potential of these powerful new data stores.
  4. Application Development & Application Refactoring
    Many organizations find developing applications using DB2 LUW to be challenging. SQDR customers often use replication to move data to a more desirable application development environment or to refactor existing applications.
  5. High Availability & Warm Backups
    High availability and warm backups minimize or eliminate downtime in a disaster scenario. Data replication with SQDR is ideal for either technique as it:

    1. stores a unified copy of data on the intermediate server where replication is performed
    2. enables the real-time mirroring necessary for creating warm and hot backup servers
    3. automatically detects loss of connectivity and restores data replication as soon as the source and destination servers come back online

More Information     
Want to know more about IBM DB2 LUW data replication with SQDR? Please contact StarQuest at

You can also learn more via the following links:
Data Replication Buying Guide
SQDR Product Page