Run mission-critical analytics and AI workloads with all types of data, anywhere
Built to power your operational analytics
IBM Db2® Warehouse unifies data across hybrid clouds, enabling fast, governed access for analytics and AI. It integrates with Db2, data lakes, and watsonx.data™, runs on low-cost cloud object storage, and delivers 4x faster performance with caching.
Marriott International achieves 90% faster performance in its analytics on 140 million+ Marriott Bonvoy members.¹
The business development teams at Active International save hundreds of hours with AI-powered strategic prospecting.2
Active International reports USD 80 million in media spend optimization with an integrated cloud solution and AI-powered prospecting.3
What’s new
IBM announces the general availability of our next-generation, cloud-native Db2 Warehouse SaaS on AWS.
Stand out from the competition and scale analytics and AI workloads by running on cloud, multi-cloud or hybrid cloud solutions. IBM Db2 Warehouse offers 100% workload compatibility between software and SaaS.
Enable workload flexibility when you upgrade your IBM PureData® System for Operational Analytics (PDOA) or IBM Integrated Analytics System (IIAS Sailfsh) appliance to Db2 Warehouse SaaS, software or cloud rack.
Scale AI workloads with Db2 and watsonx.data
Db2 v12.1.2 packed with vector data store, similarity search and much more - now generally available.
Features
With Db2 Warehouse, you can take control of your analytics costs with elastic scale and a cloud-native architecture based on separation of storage and compute and cost-effective object storage. With AI powered workload management, you can automatically distribute resources based on your price-performance needs.
Support for open formats, including Apache Iceberg, Parquet, ORC and CSV, allow secure data sharing across the enterprise. Share data in Iceberg with IBM watsonx.data lakehouse and use multiple query engines, such as Presto and Apache Spark to augment your workloads for price and performance.
Build real-time dashboards and reports with a combination of in-memory and column-store data retrieval, maximized CPU processing and data skipping that allows for faster input and output for your mixed analytical and operational workloads in the cloud.
Manage downtime with continuous availability (99.9%) 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.
Built to manage HIPAA and GDPR compliance, Db2 provides end-to-end security that protects data in motion and at rest, monitors and detects unknown behaviors and ensures the privacy of your data. Natively integrate with IBM Knowledge Catalog for central data governance and policy enforcement.
From decision trees to K-means clustering, choose from various in-database algorithms or seamlessly build and deploy open-source Python and R models on the database. Ingest, store and query different data types for ML including XML, JSON, text, Graph and spatial data in a single database.
With Db2 Warehouse, you can take control of your analytics costs with elastic scale and a cloud-native architecture based on separation of storage and compute and cost-effective object storage. With AI powered workload management, you can automatically distribute resources based on your price-performance needs.
Support for open formats, including Apache Iceberg, Parquet, ORC and CSV, allow secure data sharing across the enterprise. Share data in Iceberg with IBM watsonx.data lakehouse and use multiple query engines, such as Presto and Apache Spark to augment your workloads for price and performance.
Build real-time dashboards and reports with a combination of in-memory and column-store data retrieval, maximized CPU processing and data skipping that allows for faster input and output for your mixed analytical and operational workloads in the cloud.
Manage downtime with continuous availability (99.9%) 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.
Built to manage HIPAA and GDPR compliance, Db2 provides end-to-end security that protects data in motion and at rest, monitors and detects unknown behaviors and ensures the privacy of your data. Natively integrate with IBM Knowledge Catalog for central data governance and policy enforcement.
From decision trees to K-means clustering, choose from various in-database algorithms or seamlessly build and deploy open-source Python and R models on the database. Ingest, store and query different data types for ML including XML, JSON, text, Graph and spatial data in a single database.
Use cases
Empower users who demand low-latency querying and real-time insights across operational, analytical and transactional data.
Grant access and distribute data among users and third parties without data duplication. Enable centralized governance, quality and better compliance through integration with IBM Knowledge Catalog.
Create and predict with high-performance ML models inside your data warehouse. Integrate governed data with watsonx.data for additional ML and foundation model capabilities for trusted AI.
Build reports and dashboards quickly by seamlessly integrating Db2 with various BI tools including IBM Cognos® Analytics, Tableau, Microsoft PowerBI, Google Looker and more.
Empower users who demand low-latency querying and real-time insights across operational, analytical and transactional data.
Grant access and distribute data among users and third parties without data duplication. Enable centralized governance, quality and better compliance through integration with IBM Knowledge Catalog.
Create and predict with high-performance ML models inside your data warehouse. Integrate governed data with watsonx.data for additional ML and foundation model capabilities for trusted AI.
Build reports and dashboards quickly by seamlessly integrating Db2 with various BI tools including IBM Cognos® Analytics, Tableau, Microsoft PowerBI, Google Looker and more.
Run a fully managed version of Db2 Warehouse on AWS or IBM Cloud®.
Deploy Db2 Warehouse as an extension on the IBM Cloud Pak for Data platform.
Run Db2 Warehouse on these common operating systems.
The hybrid, open data lakehouse to power AI and analytics with all your data, anywhere.
An enterprise SQL-on-Hadoop engine for advanced big data queries.
Awards and reviews
IBM Db2 is a leader in the 2024 G2 Spring Report for data warehousing and top rated on TrustRadius for relational databases, DBaaS, data warehousing and cloud data warehousing.
Footnotes
1Statistic provided by Marriott International to IBM, referenced faster performance for Marriott International's analytics on more than 140 million Marriott Bonvoy members.
2Statistic provided by Active International to IBM, referenced 100s of hours of time saved by automating key aspects of the media management lifecycle.
3Statistic provided by Active International to IBM stating USD 80 million in year-one estimated billing opportunities unlocked by enabling media optimization after implementing Db2 Warehouse SaaS and other IBM cloud native solutions.