Db2

Db2

Customer Verified
Top Rated
Score 8.8 out of 10
Top Rated
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 stability

9 out of 10
October 08, 2022
Db2 is a great database for large datasets. We use the DB2 database to manage our membership and other data. It is reliable and has a fast …
Continue reading
Verified User
Professional
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
Verified User
Engineer

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
Verified User
Project Manager

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
Stewart Locklear | TrustRadius Reviewer
Stewart Locklear
Senior Information Technology Project Manager
Harriss and Covington Hosiery (Textiles, 51-200 employees)
Verified User
Engineer in Information Technology
Information Technology & Services Company, 51-200 employees

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!

Record a review
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.

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

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

 (154)

Attribute Ratings

Reviews

(1-25 of 26)
Popular Filters
Companies can't remove reviews or game the system. Here's why
May 08, 2023

DB2 just keeps going and going and going

Stewart Locklear | TrustRadius Reviewer
Stewart Locklear
Senior Information Technology Project Manager
Harriss and Covington Hosiery (Textiles, 51-200 employees)
Score 10 out of 10
Vetted Review
Verified User
Scalability
10
I have seen DB2 work in very small environments with only a couple users. Then when the company grew the database grew with no problems at all. We just bought faster servers and upgraded the OS and everything just worked.

At one company, I saw that DB2 started with less than 200 users and over 20 years later that grew to thousands of users with no need to rebuild the database or re-architect anything. It is simply amazing.
March 20, 2023

ROBUST DATABASE, WITH A SOLID ADMINISTRATION SYSTEM.

Verified User
Engineer in Information Technology
Information Technology & Services Company, 51-200 employees
Score 10 out of 10
Vetted Review
Verified User
Scalability
8
This is not the best aspect of this database suction; I do not think it is scalable; it has many limitations thanks to the fact that it is actually a module that must be part of other IBM services to work in the best way, for this simple reason I consider that its seat is reduced, in the same way, it is a database system that we cannot stop using thanks to the excellent results obtained to date.
March 20, 2023

Reliable and robust software for the best business performance.

Verified User
Project Manager in Information Technology
Information Technology & Services Company, 5001-10,000 employees
Score 10 out of 10
Vetted Review
Verified User
Scalability
8
This IBM service is perfect for companies that have other services that can be integrated as in other IBM software; in relation to its scalability, I cannot give a precise opinion; based on the fact that it is an IBM database service, I consider that its The level of scalability is acceptable, but I don't think it will have an amazing level of enhanced growth, the company took advantage of this service to store important data, and it is used as an integrated module of another IBM product.
December 23, 2022

Operating Data with IBM Db2

Verified User
Team Lead in Engineering
Computer Software Company, 201-500 employees
Score 8 out of 10
Vetted Review
Verified User
Scalability
8
It was used on large sets of organized as well as unorganized data where it required removal of unnecessary information and then again regeneration of data. This was implemented easily using the classification techniques and the dashboard reflected improvised results after analysis of complete overall model.
December 14, 2022

Db2 is processing high workload and with high availability for our business.

Verified User
Consultant in Information Technology
Banking Company, 10,001+ employees
Score 10 out of 10
Vetted Review
Verified User
Scalability
10
Pretty much our organization's critical applications are based on HADR functionality and so far other than smaller events we didn't have anything severe yet. Its widely used. We also like the simplicity of monitoring in HADR which helps us to understand the status in efficient way.
December 14, 2022

Scalable, reliable and compatible with a diverse set of applications

Verified User
Analyst in Information Technology
Hospital & Health Care Company, 10,001+ employees
Score 8 out of 10
Vetted Review
Verified User
Scalability
9
DB2 can be configured and can work with a variety of applications as opposed to how it was designed initially to only with with IBM mainframes. It's easy implementation process makes it a good buy for many organizations to scale their applications to be the best in terms of versatility, resilience and application performance
December 14, 2022

DB2/SQL being used together with another IBM product, IzPCA

RV
Ricardo Viegas
Systems Support
kyndryl-Brazil (Information Technology & Services, 1001-5000 employees)
Score 10 out of 10
Vetted Review
Verified User
Scalability
8
By using DB2 only to support my IzPCA activities, my knowledge here is somewhat limited.
Anyway, from what I was able to understand, DB2 is extremely scallable.
Maybe the information below could serve as an example of scalability.

Customer have an huge mainframe environment, 13x z15 CECs, around 80 LPARs, and maybe more than 50 Sysplexes (I am not totally sure about this last figure...)
Today we have 7 IzPCA databases, each one in a distinct Syplex.

Plans are underway to have, at the end, an small LPAR, with only one DB2 sub-system, and with only one database, then transmit the data from a lot of other LPARs, and then process all the data in this only one database.

The IzPCA collect process (read the data received, manipulate it, and insert rows in the tables) today is a huge process, demanding many elapsed hours, and lots of CPU.
Almost 100% of the tables are PBR type, insert jobs run in parallel, but in 4 of the 7 database, it is a really a huge and long process.

Combining the INSERTs loads from the 7 databases in only one will be impossible.......,,,,
But, IzPCA recently introduced a new feature, called "Continuous Collector".

By using that feature, small amounts of data will be transmited to the central LPAR at every 5 minutes (or even less), processed immediately,in a short period of time, and with small use of CPU, instead of one or two transmissions by day, of very large amounts of data and the corresponding collect jobs occurring only once or twice a day, with long elapsed times, and huge comsumption of CPU

I suspect the total CPU seconds consumed will be more or less the same in both cases, but in the new method it will occur in small bursts many times a day!!
December 14, 2022

Db2 a powerhouse for Data warehouses

Bhanu Taneja | TrustRadius Reviewer
Bhanu Taneja
Senior Database Administrator
HCL Technologies (Information Technology & Services, 10,001+ employees)
Score 10 out of 10
Vetted Review
Verified User
Scalability
9
The best thing about Db2 is its scalability. It can be used for small applications in parallel to the bigger applications as each DB is independent of each other. If the requirement increases in future it can be easily scaled as per requirements.
December 14, 2022

Db2 from the perspective of large scale infrastructure engineering and operations

Verified User
Engineer in Information Technology
Insurance Company, 10,001+ employees
Score 10 out of 10
Vetted Review
Verified User
Scalability
10
Many different scalability options from the very simple and easy-to-manage single instance with 1 to many databases to pureScale clusters.
Plus of course the imho unique DPF setup which pushes Db2's MPP capabilities to stretch a single database across many (physical or virtual) servers and even extends such huge systems to support HA configurations.
December 13, 2022

Why use IBM DB2?

Diovani Dupont | TrustRadius Reviewer
Diovani Dupont
Analista e Desenvolvedor de Sistemas
Private (Information Technology & Services, 1-10 employees)
Score 10 out of 10
Vetted Review
Verified User
Scalability
10
Db2 for z/OS allows organizations to run mixed workloads with exceptional scalability, high performance horizontal growth, greater scalability is achieved, the system can grow beyond the limit of a single machine while your database remains intact. It improves performance, reduces resource consumption, maintains database integrity, and increases business resiliency.
September 13, 2022

Heavy but lightning fast

SF
Sean Ford
Database Engineer
Shelter Insurance (Insurance, 1001-5000 employees)
Score 9 out of 10
Vetted Review
Verified User
Scalability
10
I give a 10 because it really can handle gigantic workloads, but for my other points up to this one it's because you're starting on level 50 instead of level 1 - heaviness of install, options galore, etc. It scales up well, but down only to a certain point.
March 26, 2018

A database that guarantees the company for the future

Verified User
Manager in Other
Banking Company, 10,001+ employees
Score 10 out of 10
Vetted Review
Verified User
Scalability
10
As an architecture, you can extend its use through features such as data sharing. Data sharing can essentially share data between DB2 members to allow queries from every system that is part of the enterprise. It is, in fact, a standard among relational DBs because the price/performance ratio is very positive for us.
Return to navigation