What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
137 Ratings
186 Ratings

Db2

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
137 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.5 out of 100
186 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.3 out of 100

Attribute Ratings

  • Amazon Redshift is rated higher in 3 areas: Likelihood to Recommend, Usability, Support Rating

Likelihood to Recommend

8.6

Db2

86%
41 Ratings
9.3

Amazon Redshift

93%
34 Ratings

Likelihood to Renew

9.0

Db2

90%
3 Ratings

Amazon Redshift

N/A
0 Ratings

Usability

8.0

Db2

80%
3 Ratings
10.0

Amazon Redshift

100%
9 Ratings

Availability

9.5

Db2

95%
24 Ratings

Amazon Redshift

N/A
0 Ratings

Performance

9.9

Db2

99%
18 Ratings

Amazon Redshift

N/A
0 Ratings

Support Rating

8.5

Db2

85%
4 Ratings
9.1

Amazon Redshift

91%
12 Ratings

Contract Terms and Pricing Model

Db2

N/A
0 Ratings
10.0

Amazon Redshift

100%
1 Rating

Product Scalability

9.5

Db2

95%
15 Ratings

Amazon Redshift

N/A
0 Ratings

Likelihood to Recommend

IBM

Excellent product, very manageable across multiple platforms, paramount in recovery and backups. It has an automated system with great features that allow data to be stored easily. We have this software that is the best base for the data for a load of a quantity of data. With this relational database tool, we obtain excellent service in the company with excellent achievements. It has a quality technical service that makes what seems complicated easy.
Read full review

Amazon AWS

If the number of connections is expected to be low, but the amounts of data are large or projected to grow it is a good solutions especially if there is previous exposure to PostgreSQL. Speaking of Postgres, Redshift is based on several versions old releases of PostgreSQL so the developers would not be able to take advantage of some of the newer SQL language features. The queries need some fine-tuning still, indexing is not provided, but playing with sorting keys becomes necessary. Lastly, there is no notion of the Primary Key in Redshift so the business must be prepared to explain why duplication occurred (must be vigilant for)
Read full review

Pros

IBM

  • DB2 maintains itself very well. The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs.
  • Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery ) models gives you a range of options for maintaining a very high uptime ratio. Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click.
  • Task Scheduler ( DB2 9.7 and earlier ) allows for jobs to be run within other jobs, and exit and error codes can define what other jobs are run. This allows for ease of maintenance without third party softwares.
  • Tablespace usage and automatic storage help keep your data segmented while at rest, making partitioning easier.
  • Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio ( DB2 10.x+) makes administration a breeze.
Read full review

Amazon AWS

  • [Amazon] Redshift has Distribution Keys. If you correctly define them on your tables, it improves Query performance. For instance, we can define Mapping/Meta-data tables with Distribution-All Key, so that it gets replicated across all the nodes, for fast joins and fast query results.
  • [Amazon] Redshift has Sort Keys. If you correctly define them on your tables along with above Distribution Keys, it further improves your Query performance. It also has Composite Sort Keys and Interleaved Sort Keys, to support various use cases
  • [Amazon] Redshift is forked out of PostgreSQL DB, and then AWS added "MPP" (Massively Parallel Processing) and "Column Oriented" concepts to it, to make it a powerful data store.
  • [Amazon] Redshift has "Analyze" operation that could be performed on tables, which will update the stats of the table in leader node. This is sort of a ledger about which data is stored in which node and which partition with in a node. Up to date stats improves Query performance.
Read full review

Cons

IBM

  • everything about Db2 is 'heavy', even the Community edition and some of the clients
  • difficult to configure for beginners /option overload
  • LUW and z platforms have minor inconsistencies that really should be a non-issue
  • support seems to be declining in terms of quality/quickness of responses
Read full review

Amazon AWS

  • We've experienced some problems with hanging queries on Redshift Spectrum/external tables. We've had to roll back to and old version of Redshift while we wait for AWS to provide a patch.
  • Redshift's dialect is most similar to that of PostgreSQL 8. It lacks many modern features and data types.
  • Constraints are not enforced. We must rely on other means to verify the integrity of transformed tables.
Read full review

Pricing Details

Db2

Starting Price

$0

Editions & Modules

Db2 editions and modules pricing
EditionModules
Db2 Standard EditionContact us1
Db2 Advanced EditionContact us2
Db2 on Cloud Standard993
Db2 on Cloud Enterprise9464
Db2 Warehouse on Cloud Flex One8985
Db2 Warehouse on Cloud Flex34516
Db2 Warehouse on Cloud Flex Performance13,6517
Db2 Warehouse on Cloud Flex for AWS2,9578
Db2 Warehouse on Cloud Flex Performance for AWS13,6519
Db2 on Cloud Lite010

Offerings

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services

Entry-level set up fee?

Optional

Additional Details

Try for free

Amazon Redshift

Starting Price

$0 per hour

Editions & Modules

Amazon Redshift editions and modules pricing
EditionModules
Current Generation$0.25 - $13.041
Previous Generation$0.25 - $4.082
Redshift Spectrum$5.003
Redshift Managed Storage$0.244

Footnotes

  1. per hour
  2. per hour
  3. per terabyte of data scanned
  4. per GB per month

Offerings

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services

Entry-level set up fee?

No setup fee

Additional Details

Likelihood to Renew

IBM

Since our services are running in IBM Kubernetes, using IBM Cloud Databases seem to be the best option. It may provide better performance than other vendors as everything is running in the same cloud. The overall experience so far is good as well.
Read full review

Amazon AWS

No answers on this topic

Usability

IBM

You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.
Read full review

Amazon AWS

Just very happy with the product, it fits our needs perfectly. Amazon pioneered the cloud and we have had a positive experience using RedShift. Really cool to be able to see your data housed and to be able to query and perform administrative tasks with ease.
Read full review

Reliability and Availability

IBM

To maximize availability, just provide backup data sharing files with each other. The DB2 self-protects itself from interruptions and there are many error messages to intercept to avoid the crash. OOTB, the guarantee of reliability is very high. Undoubtedly, the true enterprise solution that guarantees the business. No doubt at all.
Read full review

Amazon AWS

No answers on this topic

Performance

IBM

DB2 for i has very good performance and great tools to monitor and tune that performance as well. IBM Navigator for i, an integrated management interface, allows for real-time monitoring of user-defined parameters. Index Advisor, SQL Plan Cache and other ACS tools allow the DBE to further tune the performance and even change those settings depending on the time of day or workload running.
Read full review

Amazon AWS

No answers on this topic

Support Rating

IBM

Easily the best product support team. :) Whenever we have questions, they have answered those in a timely manner and we like how they go above and beyond to help.
Read full review

Amazon AWS

The support was great and helped us in a timely fashion. We did use a lot of online forums as well, but the official documentation was an ongoing one, and it did take more time for us to look through it. We would have probably chosen a competitor product had it not been for the great support
Read full review

Alternatives Considered

IBM

Microsoft SQL Server and IBM Db2 both [have] their own advantages and performance optimization mechanism, but IDM Db2 is ahead on the race when we want better security and [easy] database management on the cloud. We [do not need to install Microsoft SQL Server in our remote server, we can directly use DB2 on Cloud and connect within [a] few minutes. It provides Auto-scaling without [downtime], [in] which users don't get any glitches or errors.
Read full review

Amazon AWS

Than Vertica: Redshift is cheaper and AWS integrated (which was a plus because the whole company was on AWS).
Than BigQuery: Redshift has a standard SQL interface, though recently I heard good things about BigQuery and would try it out again.
Than Hive: Hive is great if you are in the PB+ range, but latencies tend to be much slower than Redshift and it is not suited for ad-hoc applications.
Read full review

Contract Terms and Pricing Model

IBM

No answers on this topic

Amazon AWS

Redshift is relatively cheaper tool but since the pricing is dynamic, there is always a risk of exceeding the cost. Since most of our team is using it as self serve and there is no continuous tracking by a dedicated team, it really needs time & effort on analyst's side to know how much it is going to cost.
Read full review

Scalability

IBM

This IBM service is perfect for companies that have other services that can be integrated as in other IBM software; in relation to its scalability, I cannot give a precise opinion; based on the fact that it is an IBM database service, I consider that its The level of scalability is acceptable, but I don't think it will have an amazing level of enhanced growth, the company took advantage of this service to store important data, and it is used as an integrated module of another IBM product.
Read full review

Amazon AWS

No answers on this topic

Return on Investment

IBM

  • We have dealt with technical support on several occasions. Whenever we run into issues, the specialist team is involved and the resolution cycle is stretched. We have to rely on makeshift solutions and the issues keep recurring. Ultimately, the product itself has challenges and we are not currently satisfied with the support, either.
  • Scalability has been a problem area. We have traffic on the order of gigabytes and it impacts our queries and responses a lot. Considering the volume that we have, it manifests itself into a multitude of issues.
Read full review

Amazon AWS

  • Our company is moving to the AWS infrastructure, and in this context moving the warehouse environments to Redshift sounds logical regardless of the cost.
  • Development organizations have to operate in the Dev/Ops mode where they build and support their apps at the same time.
  • Hard to estimate the overall ROI of moving to Redshift from my position. However, running Redshift seems to be inexpensive compared to all the licensing and hardware costs we had on our RDBMS platform before Redshift.
Read full review

Add comparison