Try our new research platform with insights from 80,000+ expert users

Amazon Redshift vs IBM Db2 Warehouse comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Amazon Redshift
Ranking in Data Warehouse
5th
Average Rating
7.8
Reviews Sentiment
6.8
Number of Reviews
72
Ranking in other categories
Cloud Data Warehouse (8th), Database Management Systems (DBMS) (8th)
IBM Db2 Warehouse
Ranking in Data Warehouse
11th
Average Rating
7.8
Reviews Sentiment
6.1
Number of Reviews
12
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of February 2026, in the Data Warehouse category, the mindshare of Amazon Redshift is 4.9%, down from 7.9% compared to the previous year. The mindshare of IBM Db2 Warehouse is 3.4%, up from 1.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse Market Share Distribution
ProductMarket Share (%)
Amazon Redshift4.9%
IBM Db2 Warehouse3.4%
Other91.7%
Data Warehouse
 

Featured Reviews

PJ
Data Analytics, Ai & Automation Lead at a venture capital & private equity firm with 10,001+ employees
Performance optimization and scaling adaptations enable efficient data management
Amazon Redshift does not work alone and requires integration with other AWS tools like S3 and Glue for a complete ecosystem. They should bring the entire ETL data management process into Amazon Redshift. Either they should move Amazon Redshift under Glue, or Glue should be brought under Amazon Redshift. The initial setup could also be improved, particularly in terms of sizing, as it requires trial and error to get right.
Sherpard  Muzuva - PeerSpot reviewer
Senior Technical Manager- IBM Enterprise Systems at SYSTEMS INTEGRATED LTD (SYMPHONY)
Advanced features enhance business intelligence, but complex management calls for improved user guidance
While my experience with IBM Db2 Warehouse is somewhat limited, when compared to other databases such as Oracle, there are areas for improvement. They need to enhance the database to make it more user-friendly and easier to master. They should implement a more comprehensive graphical user interface with additional features. For instance, when users encounter problems, the system should provide better guidelines and troubleshooting directions, except for hardware-related issues. They need to implement tools that would help users perform basic troubleshooting rather than solely relying on support. Other databases have features where users can investigate specific issues using error codes. From my experience, many minor issues could be resolved before escalating to support.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The initial setup is easy."
"Redshift allows you to transform different data formats and consolidate them into one Redshift cluster. This means you can transform various siloed data sources like Excel files and CSV files into Redshift."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"I like it because the usage is very similar to Microsoft SQL server. The structure of the query and the temporary tables are very similar."
"It's scalable because it's on the cloud."
"It allows for the storage of huge amounts of data."
"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 solution is stable."
"Some of the best features are stored procedures, parallelism, and different indexing strategies."
"It can scale effectively as long as resources are available."
"The analytics engine is not bad at forecasting predictions."
"IBM Db2 Warehouse is more resilient when dealing with business intelligence applications."
"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."
"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."
 

Cons

"Infinite storage is available in Snowflake and is not available in Redshift."
"In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"Amazon Redshift could improve the user interface support."
"Pricing needs improvement as the solution is expensive."
"The explain panel in the Redshift database could be better."
"Compatibility with other products, for example, Microsoft and Google, is a bit difficult because each one of them wants to be isolated with their solutions."
"Amazon Redshift is a little more expensive than other products."
"It takes a long time to have a new version or release, similar to Oracle."
"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."
"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."
"IBM Db2 Warehouse needs to improve its interface."
"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."
"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."
"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."
"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."
 

Pricing and Cost Advice

"Pricing for Amazon Redshift is reasonable, though it could be somewhat higher than other solutions, such as Azure. Still, when you base your comparison on the services offered and the pricing, it's the most reasonable versus its competitors, such as RDS."
"The price of the solution is reasonable. According to the RA3 cluster particularly, it provides 128 GB of storage with only four nodes. If you can manage your computations processes with the help of materialized views and proper queries. I think the IP clusters are very useful and overall fair for the price."
"I have heard complaints about the solution’s pricing, and thus I rate it as a five."
"At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."
"It's pay per use. You can have multiple models."
"The best part about this solution is the cost."
"The product is cheap considering what it provides; I rate it five out of five for affordability."
"For Amazon Redshift, we pay around INR 60,000 annually. The cost factor also depends on the number of existing customers."
"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
881,665 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Computer Software Company
11%
Manufacturing Company
10%
Transportation Company
6%
Financial Services Firm
28%
Manufacturing Company
9%
Government
7%
University
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise21
Large Enterprise28
By reviewers
Company SizeCount
Small Business5
Midsize Enterprise3
Large Enterprise5
 

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...
What do you like most about Amazon Redshift?
The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good.
What is your experience regarding pricing and costs for IBM Db2 Warehouse?
The pricing for medium and large environments is almost the same as Oracle. I rate the pricing as six out of ten.
What needs improvement with IBM Db2 Warehouse?
While my experience with IBM Db2 Warehouse is somewhat limited, when compared to other databases such as Oracle, there are areas for improvement. They need to enhance the database to make it more u...
What is your primary use case for IBM Db2 Warehouse?
The main advantages of IBM Db2 Warehouse become apparent when dealing with business intelligence applications. I worked with it when it was installed for one of our customers, a utilities company, ...
 

Also Known As

No data available
InfoSphere Warehouse, IBM InfoSphere Warehouse
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
Alameda County Social Services Agency, Sui Southern Gas Company Limited
Find out what your peers are saying about Amazon Redshift vs. IBM Db2 Warehouse and other solutions. Updated: January 2026.
881,665 professionals have used our research since 2012.