IBM is unveiling a major upgrade to Db2 Warehouse on IBM Cloud, introducing several new capabilities that make Db2 Warehouse even more performant, capable, and cost-effective.
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.
IBM’s 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, according to IBM.
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.
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, according to IBM.
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.
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. comprehensive list of improvements, read here.
Other new features include:
- 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.
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.
For more information about this news, visit www.ibm.com.