About
IBM® Db2® Warehouse as a Service 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
IBM Db2 Warehouse SaaS is a column-organized, in-memory data warehouse designed for complex analytics and extreme concurrency. IBM Db2 Warehouse SaaS 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
IBM Db2 Warehouse SaaS is an elastic service, and allows you to independently scale compute and storage through an intuitive UI or REST API.
Native object storage support
IBM Db2 Warehouse SaaS 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
IBM Db2 Warehouse SaaS 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
IBM Db2 Warehouse SaaS 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 IBM Db2 Warehouse SaaS, 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
IBM Db2 Warehouse SaaS provides double protection for your data with built-in snapshot backups and geo-replicated disaster recovery backups.
Compatible with on-premises data warehouses
IBM Db2 Warehouse SaaS can be configured with Oracle compatibility, so applications that were written for an Oracle database can run against IBM Db2 Warehouse SaaS without having to be rewritten. IBM Db2 Warehouse SaaS 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 IBM Db2 Warehouse SaaS engine, using SQL, Python, or R. IBM Db2 Warehouse SaaS 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 IBM Db2 Warehouse SaaS. 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
IBM Db2 Warehouse SaaS 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 IBM Db2 Warehouse SaaS plans by IBM Cloud data centers that are located in geographical regions:
IBM Db2 Warehouse SaaS 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 IBM Db2 Warehouse SaaS 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:
IBM Db2 Warehouse SaaS 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 IBM Db2 Warehouse SaaS service in a network-isolated environment on AWS.