My IBM Log in

     ''

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

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…

Jabil is building reports with IBM Business Analytics Portfolio

3 min read - Jabil isn’t just a manufacturer, they are experts on global supply chain, logistics, automation, product design and engineering solutions. They are also interested and involved in the holistic application of emerging technologies like additive manufacturing, autonomous technologies, and artificial intelligence. They are a technologically motivated enterprise, so it’s no surprise that they would apply this forward-thinking view to their finance reporting as well. Jabil is a sizable operation with over 260,000 employees across 100 locations in 30 countries. The world's…

How a water technology company overcame massive data problems with ActionKPI and IBM

4 min read - Access to clean water is essential for the survival and growth of humans, animals and crops. Water technology companies worldwide provide innovative solutions to supply, conserve and protect water throughout the highly complex and technical water cycle of collection, treatment, distribution, reuse and disposal.  After a series of international acquisitions, a leading water technology company formed an Assessment Services division to provide water infrastructure services to their customers. Through the formation of this group, the Assessment Services division discovered multiple…

IBM Newsletters

Get our newsletters and topic updates that deliver the latest thought leadership and insights on emerging trends.
Subscribe now More newsletters
Overview Annual report Corporate social responsibility Diversity & inclusion Financing Investor Newsroom Security, privacy & trust Senior leadership Careers with IBM Website Blog Publications Automotive Banking Consumer Good Energy Government Healthcare Insurance Life Sciences Manufacturing Retail Telecommunications Travel Our strategic partners Find a partner Become a partner - Partner Plus Partner Plus log in IBM TechXChange Community LinkedIn X Instagram YouTube Subscription Center Participate in user experience research Podcasts United States — English Contact IBM Privacy Terms of use Accessibility