Db2

Db2

Customer Verified
Top Rated
About TrustRadius Scoring
Score 8.5 out of 100
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

DB2 is Good

10 out of 10
September 14, 2022
It is used widely company wise by different department and different applications, mostly it is lagacy system, created in house or …
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

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

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/pricing

Offerings

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

Product Demos

IBM DB2 on Cloud - an introductory tutorial
02:41
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 Features

  • Supported: Data compression
  • Supported: Query Compressed Data
  • Supported: Elastic scaling
  • Supported: Continual data ingestion
  • Supported: In-memory analytics
  • Supported: In-database ML
  • Supported: Multi model
  • Supported: Data Lake integration
  • Supported: High Availability Disaster Recovery (HADR)
  • Supported: Continuous availability
  • Supported: In-motion and at-rest encryption
  • Supported: Data auditing
  • Supported: Data masking
  • Supported: Row/column access controls
  • Supported: Role based access
  • Supported: Label-based access

Db2 Videos

IBM DB2 Tutorial

Watch IBM Db2 – The AI database

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

(1-25 of 41)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
  • Smoothly execute complex queries
  • Compatible with any operating system like Windows, Linux, Mac and run easily
  • Easy to store large file database
  • Index feature is awesome to identify the unique table
  • Automatic reporting and manage system via SQL is great
  • Lack of timely updates
  • Migration from other platform must be available
  • Need little knowledge to work on Db2
  • Consider price and storage models
Score 10 out of 10
Vetted Review
Verified User
  • Automated system.
  • Ease of querying data.
  • Easy integration with other tools.
  • Intuitive features to improve integration.
  • If it could work faster from the cloud, it would be much better.
  • Otherwise, this platform can be used by experts and developers who are just starting out in this world.
Score 10 out of 10
Vetted Review
Verified User
  • Easy to install and run, no subject matter expertise required.
  • Great compatibility with other tools.
  • Your database is quite manageable.
  • Technical Service that guarantees the proper functioning of the product.
  • Search speed needs to be improved, it's quite slow.
  • Overall, this product has nifty features that work seamlessly with top-of-the-line technology.
September 14, 2022

DB2 is Good

richard shen | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
  • DB2 has build in replication tools make online data replication/movement much easier and fast.
  • DB2 HADR is reliable, keep Database up and running 99.99% of time, switch beween servers in seconds.
  • DB2 Federation make the access to all kinds of Databases like in one.
  • DB2 is stable on Linux/AIX even Windows.
  • DB2 Locks is too strict, very little flexibility
  • Like to more built-in function, procedure for Analysis/Reporting
  • Love to see DB2 can go open source, so that it can get more developer involved
September 13, 2022

Heavy but lightning fast

Score 9 out of 10
Vetted Review
Verified User
  • transactional workloads at high volume
  • encryption at rest and in flight
  • manages large objects LOB/BLOB/XML well
  • everything about Db2 is 'heavy', even the Community edition and some of the clients
  • difficult to configure for beginners /option overload
  • LUW and z platforms have minor inconsistencies that really should be a non-issue
  • support seems to be declining in terms of quality/quickness of responses
Score 9 out of 10
Vetted Review
Verified User
  • Easy and user friendly. Secure and productive.
  • Easy connection strings via programmatic use and procs.
  • Database security, own interface, SPUFI, QMF.
  • On a black screen with no GUI, can explicitly go like DB2 visualizer.
  • More time required to pull data and time delay.
  • Not enough exposure to the product as a lead, need guidance from DBAs at times to learn.
  • Costing is too high.
Valarie Thomas | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
  • Very fast to retrieve data from IBM Db2 on Cloud.
  • Store large files in the database in an easy way.
  • Store data and access it in different locations.
  • Runs and scales well on IBMs power-based platforms.
  • Data recovery and back-ups can be complex to new users.
  • Only runs and scales well on IBM power-based platforms.
  • Can be complex to beginners when migrating XML data.
Ravi Khunt | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
  • Secirity
  • Availability
  • Multiple interface for manipulating data
  • Providing Standard and Enterprise plans based on users requirements.
  • Autoscaling Database
  • Can provide REST APIs for Other technologies as well.
  • Can improve API Documentation that can easily understand new users.
  • If possible, then can be select more availability zones.
Moris Mendez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
  • Very good availability and performance
  • support for various operating systems
  • Data management is efficient and security is guaranteed, which gives us confidence
  • setup and implementation can be a bit difficult or confusing for less experienced users
  • Response times in customer service could be improved
Rishabh Khanna | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
  • It is easy to understand
  • It is fully managed and highly available
  • It provides easy data migration
  • They should work on improving UI part
  • Documentation can be more helpful if they will add best practices section
Ejaz Hussain | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
  • Extremely easy data migration
  • Intuitive UI & easy to learn
  • Availability of auto backup feature
  • High service availability
  • Very less region options
  • Pricing model could be more flexible
  • More product documentation be made available
  • UI could be made more interactive with little bit of enhancement
Score 9 out of 10
Vetted Review
Verified User
  • 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
Ankur Varshney | TrustRadius Reviewer
Score 2 out of 10
Vetted Review
Verified User
  • The performance is okay as long as the volume of queries is not too high.
  • We have been facing some challenges with Db2 when scaling up the operations in terms of availability. It becomes a single point of failure and it pollutes the whole system, leaving us challenges in serving the traffic. This is the reason that we are considering migrating to Oracle.
  • Scalability has been a problem area. We have traffic on the order of gigabytes per second and it impacts our queries and responses a lot. Considering the volume that we have, it manifests itself into a multitude of issues.
  • We have dealt with technical support on several occasions. Whenever we run into issues, the specialist team is involved and the resolution cycle is stretched. We have to rely on make-shift solutions and the issues keep recurring. Ultimately, the product itself has challenges and we are not currently satisfied with the support, either.
Jay Padhya | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
  • Easy to learn, install and query - great support. IBM is extremely good in support whenever you have any type of questions. You will find no issues on learning the language and installing.
  • Amazing performance on big queries : Never had issues on performance and we have a big chunk of data to pull.
  • UI : the UI can be improved to a great extent. Ideally we would want to see the UI/UX to match with latest trends.
  • Limitation to a 15TB database size for any edition below than ES for on-prem. I am sure Cloud solves it, but falls in the same range as others (sometimes higher), making it maybe not the first one to go to.
Return to navigation