Db2 Warehouse, now part of IBM Hybrid Data Management Platform

Db2 Warehouse, now part of IBM Hybrid Data Management Platform Learn more

Use the full power of an on-premise appliance

Get elasticity combined with simplicity. The IBM Db2® Warehouse is a software-defined data warehouse for private and virtual clouds that support Docker container technology. This data warehousing approach is client-managed and optimized for fast and flexible deployment. Expect automated scaling to meet agile analytic workloads. Fuse IBM Db2 BLU Acceleration® and Netezza technologies; this warehouse is supported on variety of platforms such as Intel x86, Power and Linux on IBM z Systems®. Db2 Warehouse can also be deployed on IBM Cloud™ Private platform, IBM Bluemix®, or any virtual private cloud, such as AWS or Microsoft Azure.

→ Take the product tour

→ Read the Aberdeen report

Product benefits

Icon for ave time and resources to meet your SLAs

Save time and resources to meet your SLAs

Deploy a pre-configured data warehouse in minutes on your Docker container-supported infrastructure of choice. Get elastic scaling and ease of updates and upgrades.

Icon for gain fresh insight with in-database analytics

Gain fresh insight with in-database analytics

Apply in-database analytics where the data resides. Netezza-like in-database analytics tools, Spark and R open source provide predictive modeling algorithms built directly into the database.

Icon for lightning-fast query processing

Lightning-fast query processing

Use Spark and IBM BLU Acceleration in-memory SQL columnar processing with a MPP cluster architecture to speed up complex queries and predictive model building, testing, and deployment.

Icon for automatic schema generation and data loading

Automatic schema generation and data loading

With just a few clicks, you can automatically transform unstructured data sources into a structured format for analysis – for Twitter data, Open Data, geospatial data and more.

Icon for More-easily move workloads to meet SLAs

More-easily move workloads to meet SLAs

Move workloads to the right location with ease. With Db2 Warehouse, you get a common SQL analytics engine across public and private clouds – one that’s compatible with on-premises data warehouses.

Icon for unique in-memory data processing

Unique in-memory data processing

IBM Db2 Warehouse uses BLU Acceleration, IBM’s in-memory columnar processing technology. Entire data sets and decompression are not needed in-memory. Expect pre-fetching of data and data skipping.

Icon for load geospatial data into Db2 Warehouse

Load geospatial data into Db2 Warehouse

IBM Netezza analytics are built directly into IBM Db2 Warehouse, with multiple algorithms. This provides linear regression, decision tree clustering and more.

Icon for embedded Apache Spark Engine

Embedded Apache Spark Engine

IBM Db2 Warehouse combined with Spark delivers higher performance than standalone Spark, providing a better data science experience for data exploration.

Icon for integrated R development and deployment

Integrated R development and deployment

IBM Db2 Warehouse includes integrated RStudio for development and R in-database functions, operating directly on data in a database. Load data and perform analytics within minutes.

Icon for make data migration easier

Make data migration easier

IBM Db2 Warehouse works with supported Db2 drivers, and is compatible with Db2, PDA, and Oracle. Deploy as a standalone cloud data warehouse, or integrate with your on-premises data warehouse.

Icon for integrated Spark analytics

Integrated Spark analytics

Minimize the latency of access to data and speed up calculations. With IBM Db2 Warehouse, each node contains its own data and is overlaid with a local Apache Spark executor process.

Icon for delivered for SDEs that support Docker container technology

Delivered for SDEs that support Docker container technology

Deploy on any Docker supporting operating system of choice- X86, Windows, Mac or IBM Power hardware. Db2 Warehouse can auto-provision resources to handle changing workload needs.

Product images

Which option is right for you?

Db2 Warehouse Developer Edition


Install on your laptop, virtual machine or virtual private cloud.

Db2 Warehouse Enterprise Edition


Install on enterprise grade servers or virtual private cloud for production use.

Testimonials

How customers use it

Immediate access to relevant data

Problem

Broad-based demands for self service data access and analytics

Solution

Watch this video to see how the flexibility of a hybrid data warehouse lets IT gain back control of the data. Enable your users to gain self-service access to all relevant data sources. Real-life customer case studies will also be discussed in this overview of data warehousing concepts.

Flexible scaling and simplified deployment

Problem

You’re finding it difficult to easily scale your fast-growing data marts.

Solution

Db2 Warehouse provides an easier way to “scale out and scale back in” to match your workload demands. Take action to save on licensing costs. You pay for what you use on a monthly basis. Watch this short video to learn more.

Next Steps

Download free Developer Edition

Purchase with HDM platform