We just raised a $30M Series A: Read our story

Compare IBM Db2 Database vs. Vertica

Cancel
You must select at least 2 products to compare!
IBM Db2 Database Logo
8,734 views|5,832 comparisons
Vertica Logo
9,994 views|6,879 comparisons
Featured Review
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases. Updated: November 2021.
552,305 professionals have used our research since 2012.
Quotes From Members

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

Pros
"The solution has very good data compression of up to 50%. For example, if you have 50 terabytes of data, it can be reduced to 25 terabytes.""Your iOS, your throughputs, your performance cycles, you cannot touch it with Microsoft or with Oracle scalability-wise. That is far and away the most scalable systems and the highest performing systems of the set of them.""IBM Db2 was much cheaper as a package than using other products. This is because IBM supplied a package with its product. It's an application. So it was much more efficient and a stronger competitor in that regard.""The most valuable feature is PowerPC support.""The solution is a very stable relational database and has integration with legacy systems. It is a great product.""It has a good feature called pureScale, which is just for scalability. It is a perfect solution for environments where scalability is going to be an issue.""We are dealing with millions of transactions a month and the performance is very good.""Very good for performance and scalability."

More IBM Db2 Database Pros »

"The performance is very good and the aggregate records are fast.""Allows us to take volumes and process them at a very high speed.""Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful.""Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.""It has improved my organization's functionality and performance.""The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful.""For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments.""I have found the solution to be scalable."

More Vertica Pros »

Cons
"The technical support team is not very good when compared to the efficiency of Oracle's support.""The solution could be more modern and have updated database technology.""The GUI interface is not particularly friendly for those who do not have experience with the product.""The price should be lower.""The application development requires a Java developer and not every company has these resources.""Their view of it is they're maintaining it, they're continuing to upgrade it, they're continuing to grow it, however, they don't go out and try and sell that as an architectural solution the way they do Linux and Unix.""In terms of improvements, IBM Db2 can improve its interface and its functionality. Also, the embedded functions should be much richer than the current ones - the functions which are embedded in the engine itself.""It would be helpful to have a hybrid data storage facility that includes NoSQL technologies."

More IBM Db2 Database Cons »

"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be.""When it is about to reach the maximum storage capacity, it becomes slow.""Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible.""We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well.""I have found that coding support could be simplified.""Support is an area where it could get better.""Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint.""They could improve on customer service."

More Vertica Cons »

Pricing and Cost Advice
"Among Microsoft SQL Server, Oracle, and Db2, Microsoft SQL Server is the cheapest one, and Oracle is the most expensive one. Db2 is in the middle. As compared to SQL Server, its price could go down. It will be good for customers.""We did not buy it. It came with our hardware without any complimentary maintenance. If I compare Db2 Database with Oracle Database, its price is lower than Oracle Database.""Db2 is less expensive than Oracle.""It is expensive.""We don't see what the specific price of the DB2 license is because we pay for the backup license as a package.""I think that everyone knows that with IBM the standard price is higher than the others.""We normally handle large size businesses and as far as I am aware, the license is negotiable based on the number of users and the quantitative data.""There is a license for this solution and we pay every three years."

More IBM Db2 Database Pricing and Cost Advice »

"From a cost perspective, the software is less than most of its competitors.""It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy.""The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable.""The price could be cheaper and it is best to negotiate the price.""The pricing could improve, it is a little expensive."

More Vertica Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
552,305 professionals have used our research since 2012.
Questions from the Community
Top Answer: DB2 versus Oracle: - Table structure is different - Data structures - there are some differences including the data type, format and length.
Top Answer: IBM Db2 Database has good performance.
Top Answer: Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have… more »
Top Answer: The pricing could improve, it is a little expensive.
Top Answer: Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible. I know that's… more »
Ranking
6th
Views
8,734
Comparisons
5,832
Reviews
17
Average Words per Review
554
Rating
7.9
3rd
out of 30 in Data Warehouse
Views
9,994
Comparisons
6,879
Reviews
7
Average Words per Review
496
Rating
9.4
Comparisons
Also Known As
DB2
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Learn More
Overview
DB2 Enterprise for Linux, UNIX, and Windows is the ideal data server for the most demanding workloads. New XML support is designed to help firms minimize the time and effort it takes to persist and use their XML data reducing development costs and improving business agility.

Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.

To learn more about Micro Focus Vertica Advanced Analytics, visit our website.

Offer
Learn more about IBM Db2 Database
Learn more about Vertica
Sample Customers
Knorr-Bremse, Mizuho Bank Ltd., Australian Government Department of Defence, SCHWENK Zement, Friedhelm Loh Group, YAZAKI Europe Limited, Ekornes ASA, Baldor Electric, VSN Systemen BV, Lion Brewery (Ceylon) PLC, PLANSEE Group, TE Connectivity, Hansgrohe SE, Openmatics, University of Toronto
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Top Industries
REVIEWERS
Financial Services Firm43%
Insurance Company13%
Computer Software Company9%
University9%
VISITORS READING REVIEWS
Computer Software Company28%
Comms Service Provider17%
Financial Services Firm10%
Insurance Company7%
REVIEWERS
Computer Software Company21%
Media Company18%
Marketing Services Firm15%
Comms Service Provider12%
VISITORS READING REVIEWS
Computer Software Company32%
Comms Service Provider19%
Financial Services Firm7%
Media Company5%
Company Size
REVIEWERS
Small Business27%
Midsize Enterprise10%
Large Enterprise63%
REVIEWERS
Small Business31%
Midsize Enterprise25%
Large Enterprise44%
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases. Updated: November 2021.
552,305 professionals have used our research since 2012.

IBM Db2 Database is ranked 6th in Relational Databases with 16 reviews while Vertica is ranked 3rd in Data Warehouse with 10 reviews. IBM Db2 Database is rated 7.8, while Vertica is rated 9.4. The top reviewer of IBM Db2 Database writes "Extremely scalable, extremely stable, and unhackable". On the other hand, the top reviewer of Vertica writes "Superior performance in speed and resilience makes this a very good warehousing solution". IBM Db2 Database is most compared with Oracle Database, SQL Server, MySQL, SAP HANA and Teradata, whereas Vertica is most compared with Snowflake, Amazon Redshift, Teradata, SQL Server and Oracle Exadata.

We monitor all Relational Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.