CockroachDB vs IBM Db2 Database comparison

Cancel
You must select at least 2 products to compare!
Cockroach Logo
4,096 views|2,720 comparisons
80% willing to recommend
IBM Logo
10,870 views|7,336 comparisons
90% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between CockroachDB and IBM Db2 Database based on real PeerSpot user reviews.

Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed CockroachDB vs. IBM Db2 Database Report (Updated: May 2024).
771,212 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The product has valuable security features.""The availability and the easy to use feature is the most valuable. The documentation is also good.""The most valuable features of the solution are its resiliency features and the geo-partitioning capabilities.""I use CockroachDB to test big data samples and to create the best structure for databases. We have four users and required 10 people for deployment and maintenance.""The subset of SQL that my client is using is completely supported.""CockroachDB is highly reliable.""The best feature of CockroachDB is the ability to keep the nodes in different locations.""The tool's most valuable feature is node syncing, which takes only 0.54 milliseconds."

More CockroachDB Pros →

"IBM DB2 pureScale Feature is valuable.""We had a crash of the backup system and the IBM DB2 was always up and consistent. It's robust, and for us, it was always up and running.""When you submit a ticket the response time is quick.""Scalability-wise, I rate the solution a nine out of ten.""The solution has many beneficial features, such as security, support, and stability.""I like that its true active-active. For example, if there are two instances within a cluster, we can take one of them down and there's no failover or switch over. There's no primary and secondary, it's true active-active. We can take one side down and we can upgrade that with new maintenance or a new version, obviously testing coexistence beforehand, without impacting the business.""The solution's security is very tough and impenetrable.""It's easy to search and extract data from the warehouse using queries."

More IBM Db2 Database Pros →

Cons
"CockroachDB needs to improve store processes.""The closer they can make CockroachDB to being completely compatible with Postgres, the better. It's almost compatible, but not completely. If it was, it would be nice to just be able to use Postgres libraries without any fiddling.""The platform could be more extensible.""Cockroach does not support all types of protocols. I need to improve it myself to support a CouchDB on my network.""I find the serverless offer a bit confusing.""The initial setup and pricing could be improved.""The product must improve its disaster recovery features.""We are looking for more features to support distributed high availability and geo-partitioning."

More CockroachDB Cons →

"The backup solution lacks flexibility.""When I look at Microsoft SQL Server, SQL Server provides me with better tools for database management.""The product needs to improve its configuration and storage.""Microsoft SQL Server is comparatively very simple to use. I wish IBM would move towards making Db2 easy to use for both basic and advanced users. This is where I see room for advancement. Db2 is also more expensive than Microsoft SQL Server, and its price can be reduced. The replication feature needs to be there in Db2. Microsoft provides similar functionality in SQL Server. IBM also has similar functionality, but it exists in a different product. So, to have the replication ability, you have to buy a different product. It makes sense to have this functionality within Db2 instead of a different product. It will also be helpful in terms of competition. In Africa, the problem for Db2 is competition. Oracle Database and Microsoft SQL Server have been in this market for a very long time. These companies have built the ecosystem and the brand within this market for a very long time. So, they are very popular with users. Db2 or IBM came a little later in the game, and that's where the problem lies. They also don't do a lot of marketing for it, which is also a problem.""The only drawback that we see in Db2 Database is the crash recovery. When there is a crash and somebody has to do the recovery, Db2 Database first stops, and then it does any crash recovery. In Oracle Database, crash recovery happens within the database. The database is not shut down.""End-to-end encryption specifically is something the solution needs to have in the next release.""It would be ideal if the solution offered backup functionality. Many similar tools already do, which means Db2 is somewhat behind the curve in terms of what a customer might expect from it.""We just want a bit more integration with Linux. That said, we are already seeing Linux more readily available on the mainframe environment."

More IBM Db2 Database Cons →

Pricing and Cost Advice
  • "I've used CockroachDB at a small scale on the free accounts because we are only testing."
  • "The pricing is good but can be made cheaper. I would rate the pricing a five out of ten."
  • "The platform is affordable even for the enterprise version. It provides value for investment in terms of performance."
  • "The product's price depends on the user's company and the contract model they enter into with CockroachDB. Depending on the contract model one enters into with CockroachDB, the product may or may not be expensive."
  • More CockroachDB Pricing and Cost Advice →

  • "They are competitive and honest (compared to how peer firms approach licensing conversations). ​"
  • "Compared to Oracle, it is so much cheaper."
  • "Licensing fees are on a yearly basis."
  • "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."
  • "Db2 is less expensive than Oracle."
  • "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."
  • "There is a license for this solution and we pay every three years."
  • More IBM Db2 Database Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
    771,212 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The subset of SQL that my client is using is completely supported.
    Top Answer:I find the serverless offer a bit confusing. The price is a function of the maximum database size. A single SELECT can use a number of request units, for example. If the throughput is high enough, you… more »
    Top Answer:Cockroach nodes were installed in the following: 1. Single host, triple nodes (containers): for evaluation on a low-end PC. 2. Single host, triple nodes (process): to test applications against a… more »
    Top Answer:Db2 database scalability and performance capabilities match our database needs. It covers pretty much everything a database administrator or engineer might need.
    Top Answer:I would rate the pricing a five out of ten. Since it's a government contract, the rates are negotiated and agreed upon with the government. So, it's not like the standard market price. It's not super… more »
    Top Answer:Db2 interface could be improved a bit. Comparing it to Oracle, Db2's interfaces could be improved.
    Ranking
    Views
    4,096
    Comparisons
    2,720
    Reviews
    8
    Average Words per Review
    416
    Rating
    8.5
    Views
    10,870
    Comparisons
    7,336
    Reviews
    28
    Average Words per Review
    453
    Rating
    8.0
    Comparisons
    Oracle Database logo
    Compared 28% of the time.
    MySQL logo
    Compared 18% of the time.
    Citus Data logo
    Compared 16% of the time.
    Amazon Aurora logo
    Compared 12% of the time.
    SAP HANA logo
    Compared 2% of the time.
    Also Known As
    DB2
    Learn More
    Overview

    CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally; survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention; supports strongly-consistent ACID transactions; and provides a familiar SQL API for structuring, manipulating, and querying data.

    CockroachDB is inspired by Google’s Spanner and F1 technologies, and it’s completely open source.

    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.
    Sample Customers
    Baidu, Kindred, Tierion, Heroic Labs, Gorgias
    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
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm39%
    Computer Software Company14%
    Retailer5%
    Manufacturing Company4%
    REVIEWERS
    Financial Services Firm38%
    Computer Software Company15%
    Manufacturing Company10%
    Insurance Company8%
    VISITORS READING REVIEWS
    Educational Organization53%
    Financial Services Firm9%
    Computer Software Company5%
    Government4%
    Company Size
    REVIEWERS
    Small Business60%
    Large Enterprise40%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise13%
    Large Enterprise72%
    REVIEWERS
    Small Business24%
    Midsize Enterprise19%
    Large Enterprise57%
    VISITORS READING REVIEWS
    Small Business8%
    Midsize Enterprise56%
    Large Enterprise35%
    Buyer's Guide
    CockroachDB vs. IBM Db2 Database
    May 2024
    Find out what your peers are saying about CockroachDB vs. IBM Db2 Database and other solutions. Updated: May 2024.
    771,212 professionals have used our research since 2012.

    CockroachDB is ranked 9th in Relational Databases Tools with 10 reviews while IBM Db2 Database is ranked 6th in Relational Databases Tools with 66 reviews. CockroachDB is rated 8.0, while IBM Db2 Database is rated 8.2. The top reviewer of CockroachDB writes "Open source with extensive documentation and a University for training". On the other hand, the top reviewer of IBM Db2 Database writes "Very scalable with high availability and excellent technical support". CockroachDB is most compared with Oracle Database, MySQL, Citus Data, Amazon Aurora and SAP HANA, whereas IBM Db2 Database is most compared with SQL Server, Oracle Database, SAP HANA, Teradata and Oracle Multitenant. See our CockroachDB vs. IBM Db2 Database report.

    See our list of best Relational Databases Tools vendors.

    We monitor all Relational Databases Tools 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.