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
Replication Support
Db2 Warehouse on Cloud with Q Replication enables high-speed data replication for business continuity. This feature allows you to manage downtime with continuous availability (99.999%) and in-place recovery within a cluster. The cloud-native architecture of Db2 features multiple layers of resiliency with managed computation, highly available storage, and cross-cloud replication.
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:
| 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:
| 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.