IBM Db2 Warehouse Review

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 do I think about the scalability of the solution?

It is scalable, we run it on their hardware too for best optimization. There are hundreds of people using the solution. We do both ad hoc queries, plus we do services workload against it.

How are customer service and technical support?

When we did have to use technical support It took longer than it should have to resolve the issues, but once they got the right people, they were fairly well informed.

How was the initial setup?

The setup was straightforward.

What about the implementation team?

We did the full deployment of the solution which took several months to get the first project out.

What's my experience with pricing, setup cost, and licensing?

In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side.

What other advice do I have?

It would be beneficial to make sure you have trained skillsets.

I rate IBM Db2 Warehouse a seven out of ten.

Which deployment model are you using for this solution?

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
Find out what your peers are saying about IBM, Microsoft, Oracle and others in Data Warehouse. Updated: July 2021.
522,946 professionals have used our research since 2012.
Add a Comment
ITCS user