Customer Verified
Top Rated
Score 8.7 out of 10
Top Rated


What is Db2?

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.
Read more

Recent Reviews

Read all reviews

How Db2 Differs From Its Competitors

AI/ML Impact

We have only obtained positive results, it is a software that offers great positive guarantees for data management, it has good performance and with little effort.
Continue reading

Cloud Transformation

We have migrated to the cloud with this software and we know the way to keep scaling. Our workload continues to increase and this software is perfect for our environment.
Continue reading


Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Db2, and make your voice heard!

Return to navigation


View all pricing

Db2 on Cloud Lite



Db2 on Cloud Standard


per month

Db2 Warehouse on Cloud Flex One


per month

Entry-level set up fee?

  • Setup fee optional
For the latest information on pricing, visithttps://www.ibm.com/products/db2/pricin…


  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services
Return to navigation

Product Details

What is Db2?

IBM Db2 empowers developers, DBAs, and enterprise architects to run low-latency transactions and real-time analytics equipped for the most demanding workloads.

From microservices to AI workloads, Db2 is a hybrid database providing availability, built-in refined security, scalability, and intelligent automation for systems.


Mission critical environments require continuous availability and tolerance for failure. Db2 availability enables users to run workloads without interruption.

Built-in security

Db2 protects data with in-motion and at-rest encryption, auditing, data masking, row and column access controls, and role-based access.


Db2 grows with users, scaling up and out as workloads evolve and performance needs change.


Built-in container operators automate time-consuming database tasks, while keeping the business running. Users can build apps while using Db2's advanced workload management automation and ML-optimized query engine.

Db2 can be run in the cloud, on-premises, or in hybrid environments.

Db2 Videos

IBM DB2 Tutorial

Watch IBM Db2 – The AI database

Db2 Integrations

Db2 Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows, Linux, UNIX
Mobile ApplicationNo

Frequently Asked Questions

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.

Oracle Database, Microsoft SQL Server, and Google Cloud SQL are common alternatives for Db2.

Reviewers rate Performance highest, with a score of 9.9.

The most common users of Db2 are from Enterprises (1,001+ employees).
Return to navigation


View all alternatives
Return to navigation


(1-3 of 3)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
We are using DB2 as a primary database with one of our clients to store data generated by the GST software.
  • Reliable and fast
  • Easy to deploy and administer
  • Scalable as per the requirement
  • Micro options can be placed in more user intuitive interface
  • Documentation can be improved to include more information about micro options available in different menus in the UI
DB2 is best suited for the scenarios where you are already using the different products from the IBM ecosystem. It allows for easy integration between different tools.
  • Reliable and secure RDBMS
  • Fast deployment within IBM ecosystem which saves a lot of time
DB2 is one of the fast, reliable, secure, and robust databases.
The support experience is good. There is room for improvement in terms of the delivery of support services to customers.
Score 6 out of 10
Vetted Review
Verified User
In our organization, DB2 is being used as a database for our mobile app. We also use it for querying data for business analytics and marketing analytics insights. This is used in multiple departments in the organization. It allows us to generate reports for meeting with investors. It solves the issue of warehousing our customer data.
  • Business Analytics - facilitates data query to generate reports.
  • Integration - can connect with other software.
  • Easy - easy to learn and implement if you know SQL.
  • Database can run faster.
DB2 is suitable for various uses. The big use case is an online database where users can make online queries and generate batch reports.
  • Report generation was made easier.
  • We were able to pull useful insights.
MySQL was definitely faster in terms of making queries, but DB2 had many features that protected against errors and easier to use for SQL beginners.
Microsoft 365 (formerly Office 365), MySQL, Jupyter Notebook
DB2 provides a satisfactory solution to our business needs. However, we sometimes experience issues with query speed.
I haven't needed to contact the support team.
J.R. Bullington | TrustRadius Reviewer
Score 3 out of 10
Vetted Review
Verified User
We currently use DB2 as one of our major database platforms across the organization in multiple different capacities. We have it in different environments, use it for testing of new software features, and use it to support legacy software. This software addresses the need to support legacy Java with the technology of a robust mainframe.
  • 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.
  • You cannot run multiple secondary nodes or cluster without additional software purchases; in some cases third party tools. This drastically increases your overall capital investment. The only way to accomplish a true HADR scenario is to set up NEARSYNC in one datacenter and do logshipping to another datacenter. Downside: You have to wait for the final log ship to complete before your DB is back up.
  • Licensing is prohibitively expensive! If you are not grandfathered in, IBM licensing for a multi-datacenter, PRIMARY, SECONDARY, and Disaster Recovery (DR) setup can be in the multiple $100,000 range.
  • Data Studio is built on IBM's Rapid Application Development (RAD) tool, built on Eclipse. So the download is in the multi-GB range and it includes a ton of bloatware not needed for your standard database maintenance. Control Center is a simple, powerful tool at a quarter of the disk space.
  • Support for DB2 is very hard to come by without paid IBM support. Even then, opening PMRs does not solve problems as the response time for any PMR is always more than two (2) hours, even for enterprise-level paying customers. They always want the most inane log files that have nothing to do with DB2 or its operation, or they want core dumps during the issue. This becomes useless when the issue is "our database just crashed and you can't get those logs right now because I do not want to replicate the cause!"
  • DB2's SQL syntax, while ANSI in CRUD opertaions, is different than Oracle. PostgreSQL, MySQL, and even MS SQL. One must become accustomed to a different syntax for LIMITs, cursors, record counting, stored procedures, user-defined functions, and even table / index creation or altering.
DB2 is built on mainframe technology. If you are going to be running a mainframe - it's great for your uses. It also integrates well with other IBM products like IBM Datapower and IBM WebSphere.

If you are running websites or web services with it, then maybe it's time to investigate a newer, easier to use technology.
  • We inherited DB2 as a standard database platform when our company was founded, so we have been stuck with it. There are only negative impacts on the use of DB2.
  • We cannot find qualified candidates to help support it. You will occasionally receive a résumé of someone with DB2 experience, but they have either never run it in Linux or without a GUI, never run it via command line, or has only a very basic understanding of DB2 administration.
  • Licensing always continues to increase year-over-year.
We did not select DB2. We are currently attempting to phase it out of our architecture due to licensing costs, lack of support, and we are trying to unify on a single database platform.
  • Control Center
  • Task Scheduler
  • DB2 Registry values when initially working with a database.
  • DB2 Command Line Interface when using a DB2INSTANCE
  • Moving a database or instance from one server to another is particularly challenging, especially when using multiple partitions and tablespaces.
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.
Return to navigation