TrustRadius Insights for Db2 are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
Ease of Use: Users consistently praise the database for its intuitive interface and straightforward administration processes, such as backup, restoration, and monitoring capabilities, enhancing operational efficiency. The simplicity of tasks like data management allows teams to focus on core business activities.
Security Features: Many reviewers have highlighted the database's robust security measures, including encryption, access controls, and auditing functionalities that ensure secure data handling and prevent unauthorized access. This level of security instills confidence in users regarding data protection.
Performance and Scalability: Users value the database's efficient handling of large data volumes, effective query optimization capabilities, and seamless integration with external services like ERPs, contributing to enhanced performance and scalability. These features enable businesses to adapt to changing needs while maintaining optimal performance levels.
As a database, for enterprise wide applications across the globe which requires robustness, scalable and secure databases while allows multiple-faceted user community. Large / medium organisations with humongous data sets to be managed is recommended a serious consideration of Db2. The peripheral enablers for handling large volume of data makes it better than times before. ( am avoiding specific product callouts, as it will depends on each one’s need / requirement along with willingness to spend) . Have noticed a lot more of acceptance in BFSI , logistics and manufacturing conglomerates. Decision is very similar to that of owning or leasing a private jet. Merely acquiring one won’t help your case but using the same optimally with a qualified crew makes the difference. Maintenance too will cost you in its own ways. Have seen Oracle , old Sybase , Max DB, Mongo , and HANA DB in action. Other than HANA DB for SAP, will consider Db2 any day. MHave had opportunities to closely work with IBM labs to get support and enhancements. Experience was superlative. FYI-not been in Sync with labs since 2022. During these cloud y days, an operationally sharp acumen can take the calls as is the confidence alluded on security.
Pros
Hosting ERP applications of SAP across 3 continents and round the clock
Banking solutions with few hundreds of millions as customers
Secure DB operations where security outweighs spender
Cons
HA DR activities to be simplified
Normal DB maintenance requires qualified professionals
License costs
Likelihood to Recommend
Well suited for where ever you want to handle 1) large data volumes 2) most cases structured, you may considering a streaming complementary solutions for high volume write ( inputs from sensor kind of devices ) 3) security , back up , scalability as well as robustness
will not suggest for small and medium industries which does not have large data volumes or moderate ERP s where transactions are less than 100 a day… unstructured data retrieval also has it’s own lag
I use Db2 for all our back end processing and use it to handle a huge amount of transactions daily. It’s great for large data processing, especially for critical systems like point of sale and finance data security and also the ability to share data with each other makes everything work fast and efficiently.
Pros
from my experience I can tell that Db2 is quite reliable and stable even when put under heavy loads
it is very easy to use and the commands are also very easy to learn which makes administrating very simple
it can process data very quickly which saves us a lot of time and makes us more efficient
Cons
when the dark mode is on it can be frustrating to use since it's hard to tell what is going on
it lacks some of the connectivity options that Oracle provides by default and I think it is quite disappointing
it can be expensive for frequent data transfers from on-premise to the cloud
Likelihood to Recommend
I’d recommend Db2 to anyone needing a robust database for real-time transactions and it’s especially great for businesses handling a high volume of data, like retail and finance. The security is solid and IBM support is better than other vendors I’ve worked with.
I have been a long time Db2 user starting with version 7.7 and working through to the latest version and I can definitely tell you that when it comes to dependability and scalability and resource intensive applications, Db2 is the best solution that you'll ever need. And with its smooth interface which uses cobol and mainframe systems, managing large volumes is very easy and effective.
Pros
almost near zero downtime
simple UI and can easily be used using sql syntax
compatible with both older and modern systems
Cons
should have a option where we can create our own shortcut keys for different jobs
currently only supports a few other language apart from english
can be complex for some users
Likelihood to Recommend
From my experience IBM Db2 is best suited for environments which needs outstanding performance, security compliance and scalability and I think that this is what makes it the best if not the perfect solution for every company. Also we found the strong cobol application support very helpful and a perfect fit for us.
Db2 is powerful database management system and its capability of string and analysing large amount of data for the business and for the transaction processing like use in banking or any ware house infrastructure. Through this our company handle large amount of structural data with good performance and security optimization features.
Pros
Db2 is used in online transaction processing
Storage capability
Integration with AI and machine learning
Security
Cons
Potential improvement user friendlly
Cloud integration features
User interface for monitoring and analyzing
Likelihood to Recommend
Db2 is store high volume of data because of it features like multiple column and row capabilities. Db2 used in banking require boost system so that Data security and compliance is most important. It is very costly for the smaller type organisation it setup administration is more overhauling for short type organisation, need light features to store
VU
Verified User
Engineer in Information Technology (51-200 employees)
Db2 is a relational database. We are using Db2 in the cloud and accessing it through different regions. In our use case, we are storing the data through angular ui, which interns connect to Db2 using Java, and crud operations are used on it. We need the fast performance which is what is given by Db2 as well. Inbuilt quick queries are one of the key features to fast track the development.
Pros
Data storage
Data management
Analysis
Retrival
Data security
Data governance
Cons
High cost
Complex compare to oracle
Community support
Likelihood to Recommend
Db2 is feature rich database. It's very secure and reliable. Performance is really awesome. Can be stored at one place and accessed by multiple. High cost. Need more to get expertise.
VU
Verified User
Team Lead in Information Technology (10,001+ employees)
DB2 is the main database that holds the data of our entire organization. It is used because it provides the much-needed flexibility and scalability for ever-growing data demands. It addresses all medium to complex requirements with ease. The use case is extensive across our organization for every line of business. The robustness of DB2 gives developers, designers, and end users confidence. DB2 is used to create the tables.
Pros
Robustness, and scalability.
Ease of designing, implementing and using in long run with minimal maintanance.
Vast support material and help forums available online.
Very easy to learn, use and maintain.
Cons
Supporting apps or widgets should be provided for building complex queries with testing facilities using mock or dummy databases.
Simple playgrounds should be provided for learning, ideating, testing, and implementing without actually entering the actual database.
Detail demos and material for real time like problem solving.
Likelihood to Recommend
Ease of usage and upward scalability. Db2 is renowned for its exceptional performance and scalability. It is engineered to handle large volumes of data and high-velocity transactions efficiently. B2 products include operational databases, data warehouses, data lakes, and fast data. SQL allows flexible data table manipulation by allowing multiple users to insert, delete, and update records simultaneously using specific SQL commands.
VU
Verified User
Engineer in Information Technology (201-500 employees)
We are using IBM Db2 as our relational database for Financial and Mainframe applications. The database is very robust and we rarely had any issues with scalability and performance. We are also using it as a cluster database also to have 24*7 availability. It supports API and other integration very well as we have various application which connects to Db2.
Pros
Performance
OLTP
scalability
availability
Cons
Integration with other systems can be better
GUI needs much improvement.
Its quite hard to find Db2 engineers, so IBM should focus on trainings.
Installation and upgrade process is bit complex.
Likelihood to Recommend
It's best suited for systems that can't compromise on performance and security. That's why it's usually the first choice for banking and financial systems. It's very good at handling large-scale datasets. However, for small scale enterprises, using Db2 is not that feasible due to its licensing cost. Due to its complexity and lack of training resources, there are very less engineers in the market that have expertise on Db2.
VU
Verified User
Professional in Information Technology (1001-5000 employees)
IBM's Db2 is the most low latency enterprises database which supports for faster realtime as well as supporting low latency transactions equipped with full availability. Our use case for in order to use Db2 is to store all our banking related datas ( user data, bank/ATM branches data, Transaction purpose ), Assets inventory and some data of our own datalake which helds massive amount of data for showcasing analysis for various use cases.
Pros
Support for Integrations with Public cloud vendors
Rich Monitoring and Metrics so that a team can focus less on DB administration tasks and can focus more on Customer Experiences and Product Wellness, Queries monitoring/Indentification of slow queries, Query recommendations.
Database Scalability, Availability is very high
Migration Assistant so we can easily migrate the database from any platform to IBM DB2
Cons
Documentation needs bit attention as we have to find many things which can be found very easy
Good UI for monitoring, user can create own custom DB dashboards
Likelihood to Recommend
Products which are at very high scale in Storage,traffic patterns, Live analysis, realtime streaming, Transactional workload. IBM's Db2 is a jack of all these above mentioned trades. IBM's Db2 is not suitable the very small scale workload as it is bit expensive.
It can be used in both ways with or without relational concepts which helped with the current requirement of our business module where we need to be able to store data of both nature, structured and unstructured for us to help minimize the data loss which is incredibly sensitive and important for the business growth and fulfilling product needs.
Pros
XML structured data storage
Relational data storage
Materialized query table
Cons
Online backups need to be taken only in an offline environment which is quite troublesome because you don't always have the option to go offline.
Extensibility for buffer pool size in case of large data sets sometimes some tables could need more size for storing which is not possible at the moment.
Could be a lot more handy if they could introduce temporal tables like the ones in ms SQL.
Likelihood to Recommend
it is well-suited for mid-sized multipurpose data storage which is very likely in some integrated platform that requires multiple formats of data fetching and storage for pushing or pulling into or from the external or internal system.
Db2 has been a critical component of our organization's data management strategy, delivering several advantages to satisfy our business needs. It helps us to achieve our goals. One of the main advantages of Db2 is its dependability, which has continuously supplied us with secure and rapid access to our data.
Pros
Ideal for storing and organizing our client's data
Compatibility with many systems makes integration smooth
Processing of queries happens in milliseconds
Cons
The software upgrade process is quite hectic and lengthy
Rest is all good as per my experience while using it
Likelihood to Recommend
Db2 database is highly optimized and works very well with IBM products. They assist me in setting up indexes on massive data sets. My previous business employed Db2 for its backend application. Its Integration allows users to connect to a wide range of application programming interfaces via drivers. It is no SQL database so data can't be stored in the form of tables.
VU
Verified User
Team Lead in Information Technology (1001-5000 employees)
