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) (9th)
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 January 2026, in the Data Warehouse category, the mindshare of Amazon Redshift is 4.9%, down from 7.8% compared to the previous year. The mindshare of IBM Db2 Warehouse is 3.2%, 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.2%
Other91.9%
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

"For the on-premises version of Amazon Redshift, we need to start from scratch. However, with the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features."
"The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"I would rate Amazon Redshift a ten on a scale of one to ten."
"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."
"I work in the real estate industry, and the best features I appreciate about Amazon Redshift include its efficiency in managing large datasets."
"Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."
"In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes."
"The ability to reload data multiple times at different times."
"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."
"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."
"IBM Db2 Warehouse is more resilient when dealing with business intelligence applications."
"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."
"It can scale effectively as long as resources are available."
"The solution is stable."
"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."
 

Cons

"The product must become a bit more serverless."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"We are using third-party tools to integrate Amazon Redshift, they should create their own interface on their own for it to be easily connected on the AWS itself."
"Improvement could be made in the area of streaming data."
"I rate their support seven out of ten. It's costly when you enable support. The price is high for technical support."
"What would make Amazon Redshift better is improvising on the pricing structure. For example, Acronis provides backups in cybersecurity, yet the pricing is a bit lesser than Amazon 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."
"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."
"Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues."
"There should be more material available for training and training should be free."
"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."
"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."
"Lacks sufficient documentation and particularly in Spanish."
"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."
"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."
"IBM Db2 Warehouse needs to improve its interface."
 

Pricing and Cost Advice

"The best part about this solution is the cost."
"My customers have implementations that cost about $500 a month for a very small one. I also have a customer with a monthly invoice of about $25,000 USD."
"The pricing is reasonable."
"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."
"It's pay per use. You can have multiple models."
"BI is sold to our customer base as a part of the initial sales bundle. A customer may elect to opt for a white labeled site for an up-charge."
"The cost is comparable to Snowflake."
"Amazon Redshift is an expensive solution. Larger organizations can afford this solution, but smaller businesses would struggle to afford it."
"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,082 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Computer Software Company
11%
Manufacturing Company
10%
Media Company
6%
Financial Services Firm
30%
Manufacturing Company
10%
Government
7%
Educational Organization
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,082 professionals have used our research since 2012.