Try our new research platform with insights from 80,000+ expert users
IBM Db2 Warehouse Logo

IBM Db2 Warehouse pros and cons

Vendor: IBM
3.9 out of 5
652 followers
Start review

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

IBM Db2 Warehouse offers powerful stored procedures, parallelism, and flexible indexing strategies.
It can efficiently scale with available resources in both on-premise and cloud environments.
The solution provides robust security and reliability, suitable for large enterprises handling big data.
IBM Db2 Warehouse offers excellent integration capabilities and performance without delays.
It shows strong resilience in business intelligence applications.

CONS

IBM Db2 Warehouse needs improvement in separating compute from storage and elasticity in scaling.
There are issues with backup solutions failing or being slow, leading to running out of log space occasionally.
More training material should be available for free, and documentation, especially in Spanish, is lacking.
Responding to support tickets can take up to four days, even for critical issues.
IBM Db2 Warehouse is complex to use, requiring highly skilled professionals and challenging training and support.
 

IBM Db2 Warehouse Pros review quotes

reviewer1505592 - PeerSpot reviewer
Mar 20, 2021
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.
FM
Apr 29, 2024
The solution is stable.
reviewer1963998 - PeerSpot reviewer
Nov 11, 2022
The analytics engine is not bad at forecasting predictions.
Learn what your peers think about IBM Db2 Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: June 2025.
860,168 professionals have used our research since 2012.
Sherpard  Muzuva - PeerSpot reviewer
Jun 24, 2025
IBM Db2 Warehouse is more resilient when dealing with business intelligence applications.
reviewer1100622 - PeerSpot reviewer
Oct 22, 2021
It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily.
Ismail Aboulezz - PeerSpot reviewer
Apr 1, 2025
The most valuable features of IBM Db2 Warehouse include its availability, easy integration, ability to deal with a large size of data, excellent performance with no delays, powerful security mechanisms, and effective support.
reviewer1963998 - PeerSpot reviewer
Sep 23, 2024
It can scale effectively as long as resources are available.
reviewer1388766 - PeerSpot reviewer
Jan 31, 2021
Some of the best features are stored procedures, parallelism, and different indexing strategies.
Douglas Clarke - PeerSpot reviewer
Oct 6, 2023
The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.
reviewer1755426 - PeerSpot reviewer
May 22, 2023
Provides good security and reliability.
 

IBM Db2 Warehouse Cons review quotes

reviewer1505592 - PeerSpot reviewer
Mar 20, 2021
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.
FM
Apr 29, 2024
There were some initial challenges with IBM Db2 Warehouse about eight months ago when I worked in this environment. When I coordinated with IBM support, they mentioned that the memory was insufficient for our needs. Our business environment required significantly more memory than the previous cluster could provide. Consequently, we have worked closely with on-site IBM technical personnel to address this issue.
reviewer1963998 - PeerSpot reviewer
Nov 11, 2022
The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web.
Learn what your peers think about IBM Db2 Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: June 2025.
860,168 professionals have used our research since 2012.
Sherpard  Muzuva - PeerSpot reviewer
Jun 24, 2025
The primary challenges customers face with IBM Db2 Warehouse are related to its complexity in usage. It requires highly skilled professionals who understand Db2, and both training and support are challenging to obtain.
reviewer1100622 - PeerSpot reviewer
Oct 22, 2021
There should be more material available for training and training should be free.
Ismail Aboulezz - PeerSpot reviewer
Apr 1, 2025
It takes a long time to have a new version or release, similar to Oracle.
reviewer1963998 - PeerSpot reviewer
Sep 23, 2024
Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues.
reviewer1388766 - PeerSpot reviewer
Jan 31, 2021
The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting.
Douglas Clarke - PeerSpot reviewer
Oct 6, 2023
In terms of improvement, IBM Db2 Warehouse should be more scalable.
Josef Kraus - PeerSpot reviewer
Mar 27, 2024
IBM Db2 Warehouse needs to improve its interface.