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
660 followers
Post 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 features such as stored procedures, parallelism, and various indexing strategies.
It scales effectively and works well with sufficient knowledge and resources.
IBM Db2 Warehouse can be easily moved to the cloud, supporting on-premise to cloud transitions for growth.
Its analytics engine is efficient in forecasting predictions.
IBM Db2 Warehouse is stable, providing good security and reliability while handling big data.

CONS

Areas needing improvement include separating compute from storage and elasticity, particularly scaling up and retracting.
Backup solutions can fail or slow down, leading to log space depletion.
Documentation and online resources are very limited, including materials in Spanish.
Training resources should be more available and offered for free.
Support ticket response times can be lengthy, ranging from two to four days even for critical issues.
 

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: December 2024.
824,067 professionals have used our research since 2012.
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.
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: December 2024.
824,067 professionals have used our research since 2012.
reviewer1100622 - PeerSpot reviewer
Oct 22, 2021
There should be more material available for training and training should be free.
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.
reviewer1755426 - PeerSpot reviewer
May 22, 2023
Lacks sufficient documentation and particularly in Spanish.