IBM Cloud Docs
About

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:

Table 1. IBM Cloud data centers supporting IBM Db2 Warehouse SaaS service plans
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:

Table 2. Amazon Web Services data centers supporting IBM Db2 Warehouse SaaS service plans
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.