Amazon Web Services vs. Db2

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Amazon Web Services
Score 8.7 out of 10
N/A
Amazon Web Services (AWS) is a subsidiary of Amazon that provides on-demand cloud computing services. With over 165 services offered, AWS services can provide users with a comprehensive suite of infrastructure and computing building blocks and tools.
$100
per month
Db2
Score 8.7 out of 10
N/A
DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.
$0
Pricing
Amazon Web ServicesDb2
Editions & Modules
Free Tier
$0
per month
Basic Environment
$100 - $200
per month
Intermediate Environment
$250 - $600
per month
Advanced Environment
$600-$2500
per month
Db2 on Cloud Lite
$0
Db2 on Cloud Standard
$99
per month
Db2 Warehouse on Cloud Flex One
$898
per month
Db2 on Cloud Enterprise
$946
per month
Db2 Warehouse on Cloud Flex for AWS
2,957
per month
Db2 Warehouse on Cloud Flex
$3,451
per month
Db2 Warehouse on Cloud Flex Performance
13,651
per month
Db2 Warehouse on Cloud Flex Performance for AWS
13,651
per month
Db2 Standard Edition
Contact us
Db2 Advanced Edition
Contact us
Offerings
Pricing Offerings
Amazon Web ServicesDb2
Free Trial
YesYes
Free/Freemium Version
YesYes
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeOptional
Additional DetailsAWS allows a “save when you commit” option that offers lower prices when you sign up for a 1- or 3- year term that includes an AWS service or category of services.
More Pricing Information
Community Pulse
Amazon Web ServicesDb2
Top Pros
Top Cons
Features
Amazon Web ServicesDb2
Infrastructure-as-a-Service (IaaS)
Comparison of Infrastructure-as-a-Service (IaaS) features of Product A and Product B
Amazon Web Services
8.9
67 Ratings
9% above category average
Db2
-
Ratings
Service-level Agreement (SLA) uptime8.863 Ratings00 Ratings
Dynamic scaling9.164 Ratings00 Ratings
Elastic load balancing9.360 Ratings00 Ratings
Pre-configured templates7.956 Ratings00 Ratings
Monitoring tools9.164 Ratings00 Ratings
Pre-defined machine images8.457 Ratings00 Ratings
Operating system support9.062 Ratings00 Ratings
Security controls9.365 Ratings00 Ratings
Automation9.116 Ratings00 Ratings
Best Alternatives
Amazon Web ServicesDb2
Small Businesses
Linode
Linode
Score 9.0 out of 10
SingleStore
SingleStore
Score 9.7 out of 10
Medium-sized Companies
SAP on IBM Cloud
SAP on IBM Cloud
Score 9.1 out of 10
SingleStore
SingleStore
Score 9.7 out of 10
Enterprises
SAP on IBM Cloud
SAP on IBM Cloud
Score 9.1 out of 10
SingleStore
SingleStore
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Amazon Web ServicesDb2
Likelihood to Recommend
8.8
(79 ratings)
8.6
(75 ratings)
Likelihood to Renew
9.4
(10 ratings)
8.0
(12 ratings)
Usability
7.2
(9 ratings)
8.7
(7 ratings)
Availability
9.0
(1 ratings)
8.8
(52 ratings)
Performance
-
(0 ratings)
9.1
(11 ratings)
Support Rating
7.2
(24 ratings)
6.0
(6 ratings)
In-Person Training
-
(0 ratings)
8.2
(1 ratings)
Online Training
7.0
(1 ratings)
-
(0 ratings)
Implementation Rating
10.0
(3 ratings)
9.0
(2 ratings)
Configurability
-
(0 ratings)
9.1
(1 ratings)
Ease of integration
-
(0 ratings)
8.2
(1 ratings)
Product Scalability
-
(0 ratings)
8.7
(52 ratings)
Vendor post-sale
-
(0 ratings)
8.2
(1 ratings)
Vendor pre-sale
-
(0 ratings)
8.2
(1 ratings)
User Testimonials
Amazon Web ServicesDb2
Likelihood to Recommend
Amazon AWS
We recommend AWS Lightsail with Plesk Ubuntu Web Admin (free) edition for launching WordPress websites. Pricing starts with 3.5$ per month and they are providing 3 months free. In order to access advanced features of Plesk, consider upgrading to paid Plesk plans that starts with 13.50$ per month (10 websites supported). Up to 40% discount is available for the first year. Anyway, even the free Plesk Web Admin version is by itself self sufficient with free SSL.
Read full review
IBM
I could think of a couple but the obvious is in Fintech and Retail, because of the amount of transactional and event level data for global operations. It is imperative to have a solution that can handle such large scale date, in real-time and batch delivery for inbound and outbound delivery, and ultimately ensuring that workload management is supported in some cases for around the clock SLAs.
Read full review
Pros
Amazon AWS
  • Starting an instance and accessing it for testing purpose, demo or production deployment its always easy.
  • All the things which are available over AWS are pretty well managed and easy to use.
  • You might find everything you required for an product and other development over AWS.
  • Its suitable for both either an enterprise or an startup
  • Various resources and documentation are available in case you struck somewhere.
Read full review
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
Cons
Amazon AWS
  • If there is one thing I think AWS needs improvement on, it is the administration dashboard. It can be a nightmare to use especially when trying to access billing. This could be made better, honestly, as there should be a simplified way to access simple admin features.
  • While AWS was fairly easy to integrate into our solutions, it is not as easy to use without some IT knowledge. The dashboards are complicated and designed for someone who is computer savvy. If you are just want to keep track of billing, for example, you may need to take a course or spend a few hours with someone being walked through the admin console.
  • AWS does tend to be slow at times. If you do not have a fast internet connection, it can take time to access services that are hosted on AWS. This is not always the case but we have had clients complain about this if they are trying to access a service from multiple points (IP addresses). The only real fix we found was to make our files cache to another server and only keep current data accessible to clients.
Read full review
IBM
  • The relational model requires a rigid schema that does not necessarily fit with some types of modern development.
  • Proprietary database, requires a lot of Hardware for its good performance and its costs are high.
  • As data grows in production environment, it becomes slow.
Read full review
Likelihood to Renew
Amazon AWS
We are almost entirely satisfied with the service. In order to move off it, we'd have to build for ourselves many of the services that AWS provides and the cost would be prohibitive. Although there are cost savings and security benefits to returning to the colo facility, we could never afford to do it, and we'd hate to give up the innovation and constant cycle of new features that AWS gives us.
Read full review
IBM
The DB2 database is a solid option for our school. We have been on this journey now for 3-4 years so we are still adapting to what it can do. We will renew our use of DB2 because we don’t see. Major need to change. Also, changing a main database in a school environment is a major project, so we’ll avoid that if possible.
Read full review
Usability
Amazon AWS
Our cloud platform architecture was designed in order to collect, analyze, and optimize modern networks, from AWS-powered computing, networking, storage, and more. So, we needed a reliable, scalable, and secure global computing infrastructure. Auto Scaling and Elastic Load Balancing were key features in our evaluation and later on for scalability and high performance. We being a cybersecurity company, we needed to ensure that our cloud provider utilizes an end-to-end approach to secure and harden the infrastructure, including physical, operational, and software measures - which AWS had all in place.
Read full review
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
Reliability and Availability
Amazon AWS
Availability is very good, with the exception of occasional spectacular outages.
Read full review
IBM
I have never had DB2 go down unexpectedly. It just works solidly every day. When I look at the logs, sometimes DB2 has figured out there was a need to build an index. Instead of waiting for me to do it, the database automatically created the index for me. At my current company, we have had zero issues for the past 8 years. We have upgrade the server 3 times and upgraded the OS each time and the only thing we saw was that DB2 got better and faster. It is simply amazing.
Read full review
Performance
Amazon AWS
AWS does not provide the raw performance that you can get by building your own custom infrastructure. However, it is often the case that the benefits of specialized, high-performance hardware do not necessarily outweigh the significant extra cost and risk. Performance as perceived by the user is very different from raw throughput.
Read full review
IBM
The performances are exceptional if you take care to maintain the database. It is a very powerful tool and at the same time very easy to use. In our installation, we expect a DB machine on the mainframe with access to the database through ODBC connectors directly from branch servers, with fabulous end users experience.
Read full review
Support Rating
Amazon AWS
The customer support of Amazon Web Services are quick in their responses. I appreciate its entire team, which works amazingly, and provides professional support. AWS is a great tool, indeed, to provide customers a suitable way to
immediately search for their compatible software's and also to guide them in a
good direction. Moreover, this product is a good suggestion for every type of
company because of its affordability and ease of use.
Read full review
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
In-Person Training
Amazon AWS
No answers on this topic
IBM
the material was very clear and all subjects have been handled
Read full review
Implementation Rating
Amazon AWS
The API's were very well documented and was Janova's main point of entry into the services.
Read full review
IBM
db2 work well with the application, also the replication tool can keep it up
Read full review
Alternatives Considered
Amazon AWS
Amazon Web Services is well suited when we have a huge amount of data to store, process, manipulate and get meaningful information out of. It is also suitable when we need very fast data retrieval from the database. They provide a superior product at a fair price which allows us to further our goals and push the limits of what we are capable of as a team / company.
Read full review
IBM
DB2 was more scalable and easily configurable than other products we evaluated and short listed in terms of functionality and pricing. IBM also had a good demo on premise and provided us a sandbox experience to test out and play with the product and DB2 at that time came out better than other similar products.
Read full review
Scalability
Amazon AWS
No answers on this topic
IBM
By
using DB2 only to support my IzPCA activities, my knowledge here
is somewhat limited.

Anyway,
from what I was able to understand, DB2 is extremely scallable.

Maybe the information below could serve as an example of scalability.
Customer have an huge mainframe environment, 13x z15 CECs, around
80 LPARs, and maybe more than 50 Sysplexes (I am not totally sure about this
last figure...)

Today
we have 7 IzPCA
databases, each one in a distinct Syplex.

Plans
are underway to have, at the end, an small LPAR, with only one DB2 sub-system,
and with only one database, then transmit the data from a lot of other LPARs,
and then process all the data in this only one database.



The
IzPCA collect process (read the data received, manipulate it, and insert rows
in the tables) today is a huge process, demanding many elapsed
hours, and lots of CPU.

Almost
100% of the tables are PBR type, insert jobs run in parallel, but in 4 of the 7
database, it is a really a huge and long process.



Combining
the INSERTs loads from the 7 databases in only one will be impossible.......,,,,



But,
IzPCA recently introduced a new feature, called "Continuous
Collector"
.
By
using that feature, small amounts of data will be transmited to the central
LPAR at every 5 minutes (or even less), processed immediately,in
a short period of time, and with small use of CPU,
instead of one or two transmissions by day, of very large amounts of data and
the corresponding collect jobs occurring only once or twice a day, with long
elapsed times, and huge comsumption of CPU



I
suspect the total CPU seconds consumed will be more or less the same in
both cases, but in the new method it will occur in small bursts
many times a day!!
Read full review
Return on Investment
Amazon AWS
  • AWS has lowered our employee cost, because you don't have to hire Network/Server Admins to manage infrastructure.
  • Increased productivity by incorporating Continuous Integration with AWS and our development life cycle.
  • Increased customer confidence by being able to provide HIPAA level security in our development and production environments
Read full review
IBM
  • Fast response time by processing optimization and cost reduction by reduced CPU utilization. Nowadays, good performance is a necessary condition for the survival of a company and its sustained growth
  • SQL enhancements are targeted to improve performance, simplify current and new applications, and reduce the development cycle time to market.
  • A CPU reduction at peak times can immediately reduce our TCO by reducing software costs related to CPU utilization.
  • Impressive reductions in memory requirements, which used to limit the concurrent database activity
  • Out-of-the-box savings without changing the database or application
Read full review
ScreenShots