We are excited to release the replication for continuous availability capability for IBM Db2 Warehouse on Cloud.

This feature allows customers to replicate transactions asynchronously between two or more IBM Db2 Warehouse on Cloud (Db2WoC) instances — regardless of location — with low latency for very high-volume workloads.

Data replication for continuous availability and its use-cases

Based on Log-Capture/Transaction Replay replication technology, this feature provides customers the flexibility to selectively replicate tables from a source Db2WoC instance. This flexibility enables customers to implement various business use-cases while also optimizing their costs. Some of the top data-management use-cases that can be addressed include the following: 

  • Active-active configuration: Keeping two or more Db2WoC instances available for load balancing or isolating workloads.
  • High availability: Unidirectional replication will enable customers to maintain two or more instances in sync for unexpected outages.
  • Disaster recovery at unlimited distance: With RPO of seconds or minutes during heavy peaks (but catching up quickly) and RTO that can be near immediate, customers will have the advantage of a DR solution that is active-active, allowing the DR site to be used for workloads — not an idle standby.
  • Compliance/regulatory: For customers who have regulatory requirements to maintain data copies in sync and conduct failover and fallback on a regular schedule for conformance, without the need for an application outage.
  • Test/develop/invent: Customers who want to carry out development, unit testing, or spin up a sandbox for your data science use-cases with selective data requirements.  

Features of continuous data replication for IBM Db2 Warehouse on Cloud

  • Active-active bidirectional or unidirectional data replication
  • Optimized for massive transactions common to Enterprise Data Warehouse Workloads
  • Continuous streaming with latency in seconds to minutes
  • Secure, high-speed transport with parallel apply on target replicas
  • Support for both row and column-organized data
  • Simple UI for activation, enablement and monitoring
  • API support for Restful services

How to set up replication

Release details

  • Pricing: Replication will be charged based on the amount of data replicated.
  • Plan coverage: This feature will be available on Db2WoC – Flex and Flex-Performance plans on both IBM Cloud and AWS.
  • Data centers: This feature will be rolled out in all supported data centers by end of March 2021.

Try IBM Db2 Warehouse on Cloud today.


More from Analytics

Data science vs data analytics: Unpacking the differences

5 min read - Though you may encounter the terms “data science” and “data analytics” being used interchangeably in conversations or online, they refer to two distinctly different concepts. Data science is an area of expertise that combines many disciplines such as mathematics, computer science, software engineering and statistics. It focuses on data collection and management of large-scale structured and unstructured data for various academic and business applications. Meanwhile, data analytics is the act of examining datasets to extract value and find answers to…

Financial planning & budgeting: Navigating the Budgeting Paradox

5 min read - Budgeting, an essential pillar of financial planning for organizations, often presents a unique dilemma known as the “Budgeting Paradox.” Ideally, a budget should give the most accurate and timely idea of anticipated revenues and expenses. However, the traditional budgeting process, in its pursuit of precision and consensus, can take several months. By the time the budget is finalized and approved, it might already be outdated.In today's rapid pace of change and unpredictability, the conventional budgeting process is coming under scrutiny.It's…

How Macmillan Publishers authored success using IBM Cognos Analytics

5 min read - Macmillan Publishers is a global publishing company and one of the “Big Five” English language publishers. If you're a reader, chances are good you've read a book from Macmillan. They published many perennial favorites including Kristin Hannah’s The Nightingale, Bill Martin’s Brown Bear, Brown Bear, what do you see? and some of the more recent bestsellers such as The Silent Patient by Alex Michaelides, Identity by Nora Roberts and Razorblade Tears by S. A. Cosby. It’s no wonder then that Macmillan…

MLOps and the evolution of data science

7 min read - The advancement of computing power over recent decades has led to an explosion of digital data, from traffic cameras monitoring commuter habits to smart refrigerators revealing how and when the average family eats. Both computer scientists and business leaders have taken note of the potential of the data. The information can deepen our understanding of how our world works—and help create better and “smarter” products. Machine learning (ML), a subset of artificial intelligence (AI), is an important piece of data-driven…