June 26, 2024 By Aniruddha Joshi 2 min read

We’re thrilled to announce a major upgrade to Db2® Warehouse on IBM Cloud®, which introduces several new capabilities that make Db2 Warehouse even more performant, capable, and cost-effective.

Here’s what’s new

Up to 34 times cheaper storage costs

The next generation of Db2 Warehouse introduces support for Db2 column-organized tables in Cloud Object Storage. Db2 Warehouse on IBM Cloud customers can now store massive datasets on a resilient, highly scalable storage tier, costing up to 34x less.

Up to 4 times better query performance

Our advanced caching technology, which is combined with data in Object Storage, helps customers improve performance by up to 4 times compared to the previous generation of Db2 Warehouse. These are exciting enhancements. For more details, check out the new performance blog for an outline of the various improvements that were made to the engine.

Open-table and open-data formats

Db2 Warehouse on IBM Cloud now natively supports the Iceberg open-table format that is stored on open data formats such as Parquet, AVRO and ORC. This enables Db2 Warehouse to natively ingest, query and export open-format data, facilitating seamless integration with the broader data ecosystem.

Integration with IBM watsonx.data™

Db2 Warehouse integrates seamlessly with watsonx.data, IBM’s flagship lakehouse product. This allows customers to augment existing workloads across hybrid cloud environments and run fit-for-purpose engines that best meet their workload and price-performance needs.

Better scalability, security and resiliency with IBM Cloud VPC Gen2

Db2 Warehouse on IBM Cloud is deployed on the latest IBM Cloud VPC Gen2, a highly resilient and scalable cloud platform. This deployment uses IBM’s cutting-edge hardware, delivering high network performance, ultra-fast NVMe storage, improved block storage performance and enhanced security through VPC Security Groups.

Improvements to the Db2 Engine

This release also brings significant enhancements to the Db2 engine, including improvements to the native Cloud Object Storage (NCOS) caching engine, federation, security and availability. For a comprehensive list of improvements, read here.

There’s even more to Db2 Warehouse:

  • Fully managed cloud data warehouse: Customers can now scale their Db2 Warehouse instance up to 5760 vCPUs per cluster, significantly extending the scale and scope of their deployments.
  • Storage auto-increase for Block Storage: For customers relying on block storage, the new release offers the ability to set auto-increase thresholds, ensuring that you never run out of storage for your workloads.
  • Granular, schema-level backup/restore: Db2 Warehouse now provides comprehensive backup capabilities, including the ability to take granular, schema-level backups. This offers greater control when designing your backup strategy.
  • Integration with IBM AppID: Db2 Warehouse now integrates with IBM AppID for easy integration with Azure Active Directory.
  • New APIs: We are launching new APIs for scaling, updates, backup, restore and logging, further simplifying the administration of your Db2 Warehouse on IBM Cloud instance.

Start your free trial today

Start a Db2 Warehouse free trial and receive $1000 in free credits to test drive a Db2 Warehouse SaaS instance! New to an IBM Cloud account? Sign up today and receive $200 extra credit upon creating an IBM Cloud account.

Customers running Db2 Warehouse on IBM Cloud, software or analytics appliances can seamlessly modernize to the next generation of Db2 Warehouse on IBM Cloud with like-for-like compatibility with their existing deployment. 

Get started today

More from Cloud

IBM Cloud Virtual Servers and Intel launch new custom cloud sandbox

4 min read - A new sandbox that use IBM Cloud Virtual Servers for VPC invites customers into a nonproduction environment to test the performance of 2nd Gen and 4th Gen Intel® Xeon® processors across various applications. Addressing performance concerns in a test environment Performance testing is crucial to understanding the efficiency of complex applications inside your cloud hosting environment. Yes, even in managed enterprise environments like IBM Cloud®. Although we can deliver the latest hardware and software across global data centers designed for…

10 industries that use distributed computing

6 min read - Distributed computing is a process that uses numerous computing resources in different operating locations to mimic the processes of a single computer. Distributed computing assembles different computers, servers and computer networks to accomplish computing tasks of widely varying sizes and purposes. Distributed computing even works in the cloud. And while it’s true that distributed cloud computing and cloud computing are essentially the same in theory, in practice, they differ in their global reach, with distributed cloud computing able to extend…

How a US bank modernized its mainframe applications with IBM Consulting and Microsoft Azure

9 min read - As organizations strive to stay ahead of the curve in today's fast-paced digital landscape, mainframe application modernization has emerged as a critical component of any digital transformation strategy. In this blog, we'll discuss the example of a US bank which embarked on a journey to modernize its mainframe applications. This strategic project has helped it to transform into a more modern, flexible and agile business. In looking at the ways in which it approached the problem, you’ll gain insights into…

IBM Newsletters

Get our newsletters and topic updates that deliver the latest thought leadership and insights on emerging trends.
Subscribe now More newsletters