Skip to main content
TrustRadius
Db2

Db2

Overview

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

Db2 Review

9 out of 10
February 13, 2024
Incentivized
Db2 has been a critical component of our organization's data management strategy, delivering several advantages to satisfy our business …
Continue reading

DB2 review.

9 out of 10
February 07, 2024
Incentivized
DB2 helps design, store, and handle large collections of data. DB2 provides both on-premises and cloud hosting solutions. DB2 can be …
Continue reading
Read all reviews

Awards

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
Return to navigation

Pricing

View all pricing

Db2 on Cloud Lite

$0

Cloud

Db2 on Cloud Standard

$99

Cloud
per month

Db2 Warehouse on Cloud Flex One

$898

Cloud
per month

Entry-level set up fee?

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

Offerings

  • 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.


Availability

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.

Scalability

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

Automation

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.
Free Trials available here: https://ibm.biz/BdSWMA

Db2 Integrations

Db2 Competitors

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.1.

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

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(207)

Attribute Ratings

Reviews

(1-3 of 3)
Companies can't remove reviews or game the system. Here's why
January 04, 2022

Highly reliable database service

Verified User
Manager in Engineering
Consumer Electronics Company, 10,001+ employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
  • IBM Db2 Warehouse on Cloud
We use DB2 Warehouse on Cloud as our main relational database for the backend services running in IBM Cloud. We use it to store different business data. In different regions, we have separate DB2 instances running so data can be stored locally to fit the data regulatory compliance. It also provides the capability to do data analysis.
Pros and Cons
  • It can be easily scaled up
  • It offers good region support
  • Data is encrypted and secure
  • DB2 web console is not so stable
  • Not able to see long-term DB2 metrics data
Likelihood to Recommend
IBM offers a good variety of database choices like DB2, MongoDB, Redis, etc. If you want some database to use quickly but don't want to spend time on setting things up from scratch and don't want to spend efforts on daily operations, IBM Cloud Databases would be a good choice.

In our experience, some database service offers more than one URL, so our application needs to handle the failover.
Db2 Feature Ratings
Return on Investment
  • We are able to store a huge amount of data without worrying about the storage
  • We are able to set up databases in different regions
IBM Cloud Databases Managed Platform
I am not sure if this is supported in the DB2 database that we use. If yes, that would be great for auto scaling when we are running short of storage.
IBM Cloud Databases Flexibility
This flexibility is great, so we can choose different databases based on the data type and use cases. It will increase the complexity a bit from an architecture perspective as more components and tech stacks are introduced. But it may achieve much better performance.
IBM Cloud Databases Built-in Reliability
The auto-failover and redundancy are super important to our service availability. We now don't need to worry if IBM maintenance may affect our services or not. We can refer to the database SLA to ensure our service can reach its availability goal.
IBM Cloud Portfolio
We are able to chose the best IBM products or services that fit our requirements. IBM products have good integration support, so we gain more time on developing our core applications for our consumers, while IBM ensures the high availability and good performance of the infrastructure.
Other Software Used
Users and Roles
20
They are from different functions, such as backend developers, devops/SRE engineers, stakeholders, etc. Different people are granted different roles to ensure they have the proper permissions to access the data.
Support Headcount Required
5
Since this is a managed service, we don't put much effort into support. The environments are mainly managed and supported by SRE team, while a few senior developers also provide support if necessary.
Business Processes Supported
  • Relational database to store business data
  • No SQL database to store JSON documents
  • Data analysis
Innovative Uses
  • We created different database instances to spread the workload for better performance
Future Planned Uses
  • We may look into high availability and disaster recovery
Future Integration Plans
  • No
Likelihood to Renew
9
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.
June 27, 2018

DB2 easy access

Verified User
Engineer in Information Technology
Luxury Goods & Jewelry Company, 10,001+ employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
We are using DB2 in our IT department. It's used as a back-end tool and specifically, we highly leverage the DB2 client tool to connect to IBM IAccess to do data connections to feed other inventory tools.
Pros and Cons
  • DB2 provides a strong command line interface
  • Very resilient DB connection
  • Integrated very well with IBM product
  • Maybe they could have a simple UI interface similar to MSSQL management studio
Likelihood to Recommend
Database integration is very well suited since we have multiple connections from the DB2 connection tool to an AS400 system. It is working very well with IAccess and lets us integrate with our Windows server to provide a simple connection to an ODBC type connection to third-party tools and other databases like Domino.
Return on Investment
  • Positive, as it provides simple and stable data access to multiple other systems.
Scalability
9
Low overhead and it is easy to use a connection that we use on multiple systems.
Performance
9
Has been stable and has good performance.
Reliability and Availability
9
Have not had any unplanned outage.
Alternatives Considered
For this case, we need it because we needed to integrate with IAccess and AS400.
Other Software Used
Users and Roles
100
IT uses DB2 for data access to feed inventory database for inventory tool among others.
Support Headcount Required
2
Some Database admin skills are required.
Business Processes Supported
  • Data access
  • Data portability
  • Data Availability
Innovative Uses
  • Standard use
Future Planned Uses
  • For us, the use case is pretty set.
Likelihood to Renew
8
Because it is required to support our business unit
Products Replaced
No
Key Differentiators
  • Product Features
Integration with IBM was required
Evaluation Lessons Learned
Do it in-house instead of relying to a greater extent on the consultant recommendation.
February 16, 2016

IBM-DB2 for an Enterprise - one of the robust RDBMS in the market

SS
Shiv Shivakumar
customer service leader
ifox (Computer Software, 1001-5000 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
DB2 is the primary relational database being used in our organization both on z/OS and linux platforms - it is used across the entire organization and is being used to store information on transactions in financial, customer, purchasing environments
Pros and Cons
  • Is platform specific to Z/OS, Linux, Unix and hence can be leveraged in a customized manner
  • Error handling is the most important feature with warnings
  • Very robust database performance in the SQL schema
  • Allows shared access to the database using LAN in remote branch offices
  • DB2 for Unix has definite room for improvement when compared to competition
  • GUI can be much better than what it is now
  • Data base engine can be faster
Likelihood to Recommend
DB2 is very robust on both Z/OS and Linux platforms while it has room for improvement on Unix and Windows platforms. It is very robust and the best feature is the error warning system using SQL - whether it is a simple SQL or complex SQL. It can be used in remote locations over LAN and hence a centralized database would be sufficient.
Return on Investment
  • It is very robust and hence [provides] value for money
  • Also has a free version that is very robust for a smaller organization
  • Used a centralized DB2 database across the organization and hence saved infra investments
Alternatives Considered
  • Oracle
DB2 is much more robust than Oracle or mySQL when used in the Z/OS or Linux platform as it has the best error detection/warning system and also is very fast when accessed over the LAN in remote branch locations. It is scalable to a limited extent though as is the case in all relational database management systems. It is a high availability data base that can support mission critical applications in an enterprise and has had a proven track record over the last 30 years.
Other Software Used
Users and Roles
2000
All mission critical applications in the organization that include: order management, vendor management, purchasing and financial transactions, logistics, and fulfillment.
Support Headcount Required
5
Regular database management skils with knowledge of SQL, as DB2 is a relational database management system.
Business Processes Supported
  • Primary data base for mission critical applications.
  • Runs on both Z/OS and linux platforms for us.
Innovative Uses
  • Can be scaled to a limited extent
  • Complex SQL error warning
Future Planned Uses
  • Evaluating usage on Unix
Likelihood to Renew
8
Because it is robust and can be used across the enterprise for RDBMS.
Return to navigation