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-2 of 2)
Companies can't remove reviews or game the system. Here's why
February 13, 2024

Db2 is good for you....

GP
Guy Przytula
DBA
IEE (Business Supplies & Equipment, 1001-5000 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
Db2 is used in factories, to collect all data about products produced. It is used to insert/follow up orders of products We also have a datawarehouse where we create all kind of statistics/reports
Pros and Cons
  • manageability
  • monitoring
  • easiness of use/administration
  • TSA and integration of other products
Likelihood to Recommend
well suited : as Db2 is easy to use and administer, almost all scenarios where data is to be handled and/or be kept are suitable the integration of XML is well done
Return on Investment
  • makes follow up easier and we can act faster in case of problems discovered
Scalability
10
we have small and larger databases. for the end-user we do not see any difference according the size. it can handle both at the same speed
Reliability and Availability
9
we have very few outages. we have hadr/tsa implemented to have high availability and automation of this process
Alternatives Considered
I prefer Db2 and hist command line interface
Other Software Used
Users and Roles
Db2 is being as repository for factories that provide data about production
It is used by employees that create reports about the produced parts
Support Headcount Required
2
Database administrators that know Db2 well
Organizational Effects
it is the main tool used by our factories
Cloud Transformation
not yet
Innovative Uses
  • flexibility
AI/ML Impact
we are not using AI/ML yet
Future Planned Uses
  • db2 in the cloud
Likelihood to Renew
10
the best and most reliable product and does all we need
Products Replaced
Yes
maxdb
older product with fewer possibilities
Key Differentiators
  • Integration with Other Systems
  • Ease of Use
Db2 is open for exchange of data with other products
Evaluation Lessons Learned
no changes
Implementation Details / Implementation Partner
  • Implemented in-house
Implementation Phases
Yes
first db2 install/usage
later IBM CDC install/usage/integration
Change Management Lessons
Change management was a minor issue with the implementation
Implementation Issues
  • none
Implementation Rating
10
no problems encountered for Db2 nor for IBM CDC integration
Training Types Used
  • In-Person Training
In-Person Training
9
the material was very clear and all subjects have been handled
Product Configurability
10
just right and well documented
Configuration Lessons
do it very carefully and apply changes one at the time
UI Customization
No - we have not done any customization to the interface
Extensibility and Customization
No - we have not done any custom code
Additional Customization Considerations
none
Support Rating
5
sometimes it is difficult to make the suppport people to understand our problem
if you submit a case, they only read the last sentences and request info/data that already have submitted
Premium Support
no
I presume the price
Bug Resolution
Yes
yes multiple cases have been submitted and we received special builds to resolve these problems
Exceptional Examples of Db2 Support
that was long time ago, in a weekend having a problem with db2 and needed a contact with IBM Toronto
that problem was well handled and corrected.
another problem we had with db2 datajoiner and 2 persons from the lab had to come over to resolve the problem because a compile with debug was needed for the product
Usability
10
it has all we need and much more
Easy Tasks
  • installation
  • database generation
  • integration
Difficult Tasks
  • none discovered
Performance
10
with few resources we can manage our implementation
Systems Integrated With
  • IBM data replication
easy to install/configure
we replicate in many directions our data
Future Integration Plans
  • none
no
Types of Integration
IBM data replication
ETL tools
Ease of Integration
9
no problems while integrating
Integration Lessons Learned
use all products from same supplier or products that are supported by Db2
Pre-Sale Experience
9
no problems encountered
Post-Sale Experience
9
we still receive info if needed
Key Negotiation Points
price
Dealing with IBM
none
Upgrade Process
Yes
yes, smootly
no impacts discovered
Upgrade Benefits
  • to have a supported version
Anticipated Benefits from Future Upgrades
  • none
Future Edition Upgrade Plans
No
Migrating Between Editions
No
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.
Return to navigation