IBM Db2 Warehouse Overview

IBM Db2 Warehouse is the #16 ranked solution in our list of top Data Warehouse tools. It is most often compared to Oracle Exadata: IBM Db2 Warehouse vs Oracle Exadata

What is IBM Db2 Warehouse?
InfoSphere Warehouse is a suite of products that combines the strength of DB2 with a data warehousing infrastructure from IBM. You can use InfoSphere Warehouse to build a complete data warehousing solution that includes a highly scalable relational database, data access capabilities, and front-end analysis tools.

IBM Db2 Warehouse is also known as InfoSphere Warehouse, IBM InfoSphere Warehouse.

Buyer's Guide

Download the Data Warehouse Buyer's Guide including reviews and more. Updated: June 2021

IBM Db2 Warehouse Customers
Alameda County Social Services Agency, Sui Southern Gas Company Limited
IBM Db2 Warehouse Video

Pricing Advice

What users are saying about IBM Db2 Warehouse pricing:
  • "In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."

Filter Reviews

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
KD
Data Governance at a manufacturing company with 10,001+ employees
Real User
Top 20
If you have good people designing how the data is stored, this is a marvelous tool

What is our primary use case?

We called our primary use case for this solution a data warehouse. It was data tapped from many, many different applications and mostly put into star schemas for historical reporting.

Pros and Cons

  • "I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well."
  • "The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years."

What other advice do I have?

For any database project, I really like to see good thought going into design upfront and use the standards so that people know what things mean about having to rediscover it when you go from one application to the next. So I believe in at least a place to share the vocabulary, if not a controlled vocabulary defining things, which is pretty old-fashioned I'm afraid. I also believes that companies need to pick a direction and stick with it and support it. And if they're going to go with this solution for a couple of years or if you had to have several solutions happening in parallel, you need…
BB
Principal Information Architect at a insurance company with 5,001-10,000 employees
Real User
Top 5
Abundant features, scalable, straightforward install, but stability needs improvement

What is our primary use case?

We use the solution for general data warehouse purposes, high volume data, and large selection queries.

What is most valuable?

Some of the best features are stored procedures, parallelism, and different indexing strategies.

What needs improvement?

The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting.

For how long have I used the solution?

I have been using the solution since version 1.3.

What do I think about the stability of the solution?

The solution has been fairly stable, though we did have some issues. I would rate the stability an eight out of ten. We had to bring in the DB2 support to help us resolve some issues in the system.

What

Product Categories
Data Warehouse
Buyer's Guide
Download our free Data Warehouse Report and find out what your peers are saying about IBM, Microsoft, Oracle, and more!