Introducing G2.ai, the future of software buying.Try now

Compare Amazon Redshift and IBM Db2

Save
    Log in to your account
    to save comparisons,
    products and more.
At a Glance
Amazon Redshift
Amazon Redshift
Star Rating
(397)4.3 out of 5
Market Segments
Mid-Market (39.5% of reviews)
Information
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plans
IBM Db2
IBM Db2
Star Rating
(678)4.1 out of 5
Market Segments
Enterprise (66.0% of reviews)
Information
Entry-Level Pricing
Free Trial 1 License
Browse all 6 pricing plans
AI Generated Summary
AI-generated. Powered by real user reviews.
  • Users report that IBM Db2 excels in data integration with a score of 8.6, while Amazon Redshift slightly outperforms it with a score of 8.8, indicating that Redshift may offer more seamless connections with various data sources.
  • Reviewers mention that IBM Db2 has a robust data quality feature rated at 8.7, which is comparable to Amazon Redshift's score of 8.8, suggesting both products are strong in maintaining high data integrity.
  • G2 users highlight that Amazon Redshift's cloud deployment capabilities are superior, scoring 8.9 compared to IBM Db2's 7.9, making Redshift a more favorable option for organizations looking for cloud-based solutions.
  • Users on G2 report that IBM Db2's advanced data analytics feature is rated at 8.6, while Amazon Redshift's is slightly lower at 8.1, indicating that Db2 may provide more powerful analytical tools for users.
  • Reviewers say that Amazon Redshift shines in scalability with a score of 8.9, compared to IBM Db2's 8.7, which suggests that Redshift may handle larger datasets and user loads more efficiently.
  • Users report that both products have strong security features, but IBM Db2's data security is rated at 9.1, outperforming Amazon Redshift's 8.8, indicating a stronger emphasis on protecting sensitive data in Db2.
Pricing
Entry-Level Pricing
Amazon Redshift
RA3.4xlarge
$1.22 - $3.26
Per hour
Browse all 6 pricing plans
IBM Db2
Db2 On Cloud - Lite
Free Trial
1 License
Browse all 6 pricing plans
Free Trial
Amazon Redshift
Free Trial is available
IBM Db2
Free Trial is available
Ratings
Meets Requirements
8.7
281
8.5
484
Ease of Use
8.7
281
8.0
493
Ease of Setup
8.6
138
7.7
259
Ease of Admin
8.4
128
7.7
241
Quality of Support
8.5
264
8.1
457
Has the product been a good partner in doing business?
8.7
127
8.3
234
Product Direction (% positive)
8.8
252
6.8
452
Features by Category
8.4
147
8.2
63
Data Management
8.8
133
|
Verified
8.6
52
|
Verified
8.4
125
|
Verified
8.1
48
|
Verified
8.8
131
|
Verified
8.6
49
|
Verified
8.0
127
|
Verified
8.2
48
|
Verified
7.6
102
|
Verified
7.5
34
|
Verified
8.3
118
|
Verified
7.6
34
|
Verified
Integration
7.9
101
|
Verified
7.8
43
|
Verified
8.7
128
|
Verified
8.1
45
|
Verified
8.6
119
|
Verified
8.1
42
|
Verified
Deployment
8.1
102
8.4
50
|
Verified
8.9
130
|
Verified
7.8
41
|
Verified
Performance
8.9
134
|
Verified
8.6
51
|
Verified
Security
8.7
126
|
Verified
8.7
46
|
Verified
8.8
128
|
Verified
9.0
35
|
Verified
Generative AI
7.3
20
8.3
8
7.2
19
8.3
8
Not enough data
8.5
368
Management
Not enough data
8.6
59
Not enough data
8.4
61
Not enough data
8.2
51
Not enough data
8.5
54
Support
Not enough data
8.0
56
Not enough data
8.4
59
Not enough data
7.9
59
Not enough data
8.3
60
Security
Not enough data
8.5
59
Not enough data
8.8
59
Not enough data
8.4
57
Not enough data
8.4
55
Performance
Not enough data
8.6
59
Not enough data
8.6
57
Not enough data
8.5
55
Not enough data
8.4
56
Not enough data
8.4
56
Database Features
Not enough data
8.7
304
Not enough data
8.8
306
Not enough data
8.8
306
Not enough data
8.4
302
Not enough data
8.8
301
Not enough data
8.4
302
Not enough data
8.4
307
8.3
63
Not enough data
Storage
8.4
53
Not enough data
8.4
56
Not enough data
Availability
8.6
47
Not enough data
8.2
50
Not enough data
8.4
48
Not enough data
Performance
8.2
48
Not enough data
Security
8.7
47
Not enough data
8.4
52
Not enough data
8.1
47
Not enough data
8.5
48
Not enough data
Support
7.9
43
Not enough data
8.5
47
Not enough data
Data Warehouse AutomationHide 11 FeaturesShow 11 Features
Not enough data
8.0
11
Automation
Not enough data
8.3
9
Not enough data
8.1
9
Not enough data
8.3
9
Not enough data
8.5
9
Functionality
Not enough data
7.4
9
Not enough data
8.1
9
Not enough data
8.0
9
Administration
Not enough data
8.3
8
Not enough data
7.7
8
Not enough data
7.7
8
Agentic AI - Data Warehouse Automation
Not enough data
Not enough data
Database as a Service (DBaaS)Hide 17 FeaturesShow 17 Features
Not enough data
8.7
77
Configuration
Not enough data
8.5
65
Not enough data
8.1
60
Not enough data
8.5
65
Not enough data
8.3
61
Not enough data
8.6
62
Database Administration
Not enough data
8.6
60
Not enough data
8.8
60
Not enough data
8.8
59
Availability
Not enough data
8.9
62
Not enough data
9.1
62
Not enough data
8.8
63
Not enough data
8.9
63
Security
Not enough data
8.4
41
Not enough data
8.8
42
Not enough data
8.8
40
Data Management
Not enough data
8.7
45
Not enough data
8.6
44
Not enough data
8.7
364
Database Features
Not enough data
8.7
304
Not enough data
8.8
306
Not enough data
8.8
306
Not enough data
8.4
302
Not enough data
8.8
301
Not enough data
8.4
302
Not enough data
8.4
307
Categories
Categories
Shared Categories
Amazon Redshift
Amazon Redshift
IBM Db2
IBM Db2
Amazon Redshift and IBM Db2 are categorized as Data Warehouse
Reviews
Reviewers' Company Size
Amazon Redshift
Amazon Redshift
Small-Business(50 or fewer emp.)
21.0%
Mid-Market(51-1000 emp.)
39.5%
Enterprise(> 1000 emp.)
39.5%
IBM Db2
IBM Db2
Small-Business(50 or fewer emp.)
13.7%
Mid-Market(51-1000 emp.)
20.3%
Enterprise(> 1000 emp.)
66.0%
Reviewers' Industry
Amazon Redshift
Amazon Redshift
Information Technology and Services
15.5%
Computer Software
12.7%
Financial Services
7.7%
Retail
5.2%
Telecommunications
4.7%
Other
54.1%
IBM Db2
IBM Db2
Information Technology and Services
21.6%
Banking
11.6%
Computer Software
10.1%
Financial Services
7.3%
Insurance
5.9%
Other
43.5%
Alternatives
Amazon Redshift
Amazon Redshift Alternatives
Google Cloud BigQuery
Google Cloud BigQuery
Add Google Cloud BigQuery
Snowflake
Snowflake
Add Snowflake
OpenText Vertica
OpenText Vertica
Add OpenText Vertica
Cloudera
Cloudera
Add Cloudera
IBM Db2
IBM Db2 Alternatives
Oracle Database
Oracle Database
Add Oracle Database
Amazon Relational Database Service (RDS)
Amazon Relational Database Service (RDS)
Add Amazon Relational Database Service (RDS)
SAP HANA Cloud
SAP HANA Cloud
Add SAP HANA Cloud
Teradata Vantage
Teradata Vantage
Add Teradata Vantage
Discussions
Amazon Redshift
Amazon Redshift Discussions
Should I use with a data mart for a frontend tool that make request on it ?
3 Comments
NM
Hi Mehdi Can you elaborate your question? AWS Redshift is a DataBase/Data Warehouse service, which is Ideal for Analytical use cases. You can...Read more
When can I use Amazon redshift?
3 Comments
Prakash G.
PG
Redshift is big data warehousing solution to handle petabytes of data and also for real time decisions. If you want highly optimized data warehousing...Read more
What are the characteristics of redshift?
2 Comments
Anil K.
AK
Redshift is mainly used for Big data and analytics to store the data in columner format. Retrieve the data is very fast and parallel processing also most...Read more
IBM Db2
IBM Db2 Discussions
Where can I find answers to other questions I may have?
2 Comments
Official Response from IBM Db2
Please visit: https://developer.ibm.com/answers/questions/436870/common-questions-about-the-db2-on-cloud-free-plan/Read more
I want to replace KDB+ with DB2 BLU, before doing this in my project, i want to know following answers. 1. Is DB2 BLU , capable for this type of achievement which KDB+ do? 2. can you please give me a list comparison between DB2 BLU with KDB+?
1 Comment
Nuno O.
NO
Please check: https://db-engines.com/en/system/IBM+Db2%3BKdb%2B Read more
Which tool do you use for deep monitoring of IBM DB2 databases (instances) ?
1 Comment
Matthias F.
MF
Maxim, we have a dedicated management console that comes free with Db2. It was called Data Server Manager in the past, now we call it the Unified Management...Read more