IBM Cloud Docs
About

About

IBM® Db2® Warehouse on Cloud is a fully-managed, elastic cloud data warehouse that delivers independent scaling of storage and compute. It delivers a highly optimized columnar data store, actionable compression, and in-memory processing to supercharge your analytics and machine learning workloads.

Key features

Blazingly-fast engine

Db2 Warehouse on Cloud is a column-organized, in-memory data warehouse designed for complex analytics and extreme concurrency. Db2 Warehouse on Cloud delivers high performance on complex analytics workloads by using IBM BLU Acceleration, a collection of technologies pioneered by IBM Research that features the following key optimizations:

  • A columnar organized storage model
  • In-memory processing
  • Querying of compressed data sets
  • Data skipping

Scalable and elastic cloud service

Db2 Warehouse on Cloud is an elastic service, and allows you to independently scale compute and storage through an intuitive UI or REST API.

Native object storage support

Db2 Warehouse on Cloud on Amazon Web Services (AWS) introduces native object storage support to Db2. This functionality allows you to store traditional Db2 column-organized tables in Db2's native format on object storage while maintaining the existing SQL support and performance using a tiered storage architecture. Moving data from higher cost block storage to lower cost object storage can significantly reduce your costs and does not require changes to your workload. This feature is available on the current generation of AWS plans. For more information, see Native Cloud Object Storage support

Open data format table support

Db2 Warehouse on Cloud on AWS introduces new DATALAKE table support. This functionality provides Db2 users with the ability to access data that is stored on inexpensive, scalable, and reliable object storage in open data formats such as PARQUET and ORC from within the Db2 Warehouse. This feature is available on the current generation of AWS plans. For more information, see Open data format table support

Expertly managed and highly secure

Day-to-day operations for Db2 Warehouse on Cloud, including database monitoring, uptime checks and failovers, are fully automated. Operations are supplemented by a DevOps team that are on call to handle unexpected system failures. Data is encrypted at rest and in motion by default. Administrators can also restrict access to sensitive data through data masking, row permissions, and role-based security, and can utilize database audit utilities to maintain audit trails for their data warehouse.

Highly resilient and reliable

Db2 Warehouse on Cloud provides double protection for your data with built-in snapshot backups and geo-replicated disaster recovery backups.

Compatible with on-premises data warehouses​

Db2 Warehouse on Cloud can be configured with Oracle compatibility, so applications that were written for an Oracle database can run against Db2 Warehouse on Cloud without having to be rewritten. Db2 Warehouse on Cloud also comes with nearly 100% DDL, DML, and stored procedure compatibility with IBM Netezza®.

Built-in machine learning and geospatial capabilities​

Train and run machine learning models directly in the Db2 Warehouse on Cloud engine, using SQL, Python, or R. Db2 Warehouse on Cloud also supports spatial analytics with Esri compatibility, including Esri data types such as GML, and integration with Jupyter Notebooks.

Plans and configurations

For information about the plans and configurations supported on IBM Cloud and Amazon Web Services (AWS), see here.

This set of documentation covers the detailed commands and reference topics for the Db2 engine that powers Db2 Warehouse on Cloud. To find the IBM Cloud documentation for the offering, see here. The IBM Cloud documentation covers the high-level functionality for the cloud offering, and refers back to this set of documentation where appropriate.

Supported cloud providers and data centers

Db2 Warehouse on Cloud can be deployed on both IBM Cloud and Amazon Web Services.

Availability of plans in IBM Cloud data centers

The following table provides information about the availability of the various Db2 Warehouse on Cloud plans by IBM Cloud data centers that are located in geographical regions:

Table 1. IBM Cloud data centers supporting Db2 Warehouse on Cloud service plans
Db2 Warehouse on Cloud plans Asia/Pacific Europe North/Central America South America
Flex Tokyo Frankfurt Dallas (us-south) *NA
Washington D.C. (us-east)
Flex Performance Tokyo Frankfurt Dallas (us-south) *NA
Washington D.C. (us-east)
Flex One Tokyo Frankfurt Dallas (us-south) *NA
London Toronto
Washington D.C. (us-east)

*NA = Not available at this time

For information on deploying your Db2 Warehouse on Cloud service in a network-isolated environment on the IBM Cloud, open a support case.

Availability of plans in Amazon Web Services data centers

The current generation of plans on AWS is available in the following data centers:

Table 2. Amazon Web Services data centers supporting Db2 Warehouse on Cloud service plans
Db2 Warehouse on Cloud plans Asia/Pacific Europe North/Central America South America
All current generation Tokyo Frankfurt N. Virginia Sao Paulo
Sydney

Support for additional AWS regions is coming soon.

The previous generation of plans on AWS is available in N. Virginia, Oregon, Frankfurt, London, Tokyo, Seoul, Singapore, and Sydney.

If you wish to provision a service instance in an AWS region not listed above, contact your local sales representative or open a support case. You can also open a support case for information on deploying your Db2 Warehouse on Cloud service in a network-isolated environment on AWS.