March 15, 2021 By Vinayak Agrawal 2 min read

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

In preview now: IBM watsonx BI Assistant is your AI-powered business analyst and advisor

3 min read - The business intelligence (BI) software market is projected to surge to USD 27.9 billion by 2027, yet only 30% of employees use these tools for decision-making. This gap between investment and usage highlights a significant missed opportunity. The primary hurdle in adopting BI tools is their complexity. Traditional BI tools, while powerful, are often too complex and slow for effective decision-making. Business decision-makers need insights tailored to their specific business contexts, not complex dashboards that are difficult to navigate. Organizations…

IBM unveils Data Product Hub to enable organization-wide data sharing and discovery

2 min read - Today, IBM announces Data Product Hub, a data sharing solution which will be generally available in June 2024 to help accelerate enterprises’ data-driven outcomes by streamlining data sharing between internal data producers and data consumers. Often, organizations want to derive value from their data but are hindered by it being inaccessible, sprawled across different sources and tools, and hard to interpret and consume. Current approaches to managing data requests require manual data transformation and delivery, which can be time-consuming and…

A new era in BI: Overcoming low adoption to make smart decisions accessible for all

5 min read - Organizations today are both empowered and overwhelmed by data. This paradox lies at the heart of modern business strategy: while there's an unprecedented amount of data available, unlocking actionable insights requires more than access to numbers. The push to enhance productivity, use resources wisely, and boost sustainability through data-driven decision-making is stronger than ever. Yet, the low adoption rates of business intelligence (BI) tools present a significant hurdle. According to Gartner, although the number of employees that use analytics and…

IBM Newsletters

Get our newsletters and topic updates that deliver the latest thought leadership and insights on emerging trends.
Subscribe now More newsletters