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.
Loading Reviews List....
Db2 Reviews
80 Reviews
Enterprises (1,001+ employees)
Search is temporarily unavailable. Filters are still applied.
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
So, I work for an investment bank, which has been our client for the last couple of years in the support role, and we use db2 extensively in our work. Some of the major highlights that I noticed with this tool are its reliability, ease of use, and the security it provides. We query a large set of data from the past several years for the business to make the decisions for the applications, and mostly, it just takes a minute or so to give us the data we require. This is very much suitable when used for a large set of data.
Pros
While we query a large set of data, the results are generally available within a minute or so.
Always reliable - I have never experienced an application going down.
It is easy to write queries and find tables and columns.
We can log in smoothly without any headaches.
Cons
Frontend can be much more engaging.
Takes time to understand the application.
Likelihood to Recommend
This is a perfect application when there is a large data set. Querying the data takes minimal time, which can save a reasonable amount of time, mainly when catering to a more extensive set of users. Having no downtime makes this a reliable and user-friendly application.
DB2 is a solid relational database that stores information mainly from or used by the mainframe. High availability ensures stability and allows one to concentrate on business logic.
Pros
Robust database.
Easy to be maintained.
Security and data integrity.
Cons
Can be complex to exploit due to the richness of features.
Contract conditions can be improved.
Reinstall requires manual activities to ensure all the previous legacy is erased.
Likelihood to Recommend
DB2 suits best-structured companies dedicating full-time resources to administer the instances. It works very well, providing a unique level of robustness and integrity. In terms of cons, it's a proprietary solution that can require a relevant investment in terms of hardware. There could be lighter solutions to be looked at for small and medium businesses or use cases.
VU
Verified User
Manager in Information Technology (10,001+ employees)
My organization uses IBM Db2 for real time dashboards, reporting and analytics. We use this database throughout our organization via cloud to feed real time metrics and reporting to staff in different regions. Our Analytics teams lever it for continuous data feeds and as well as presenting a large set of data to stakeholders. It makes it easy to access data, create a story, and present the results to audience in a short time period.
Pros
Real time analytics and reporting
Data Sharing
Supporting new projects where large amounts of data is required
Cons
Hard to learn to use
Gen AI assistance can take some time to learn and use
Hybrid cloud solution can be improved
Likelihood to Recommend
Db2 is excellent for real time analytics and insights. When you have a large database and want to paint a picture for team memeber that are not very technical. Db2 does a great job with getting the data you need , and creating real time reports. It also makes is super easy to share the data with people that live in different regions and have very little knowledge on the topic at hand. It make my organization much more productive by reducing time it take to pull queries from databases.
Our data and analytics team uses the platform as a relational database to manage, collect and store data. I use to to maintain data coming from multiple data sources, and is used to manage tasks relating to data integrity, data governance and data hygiene. Starting with initial implementation, it was seamless to transition and get up and running across our team.
Pros
Database querying - using query logic within the platform to build, test and deploy queries, and run multiple jobs and execute tasks is not troublesome and works well with our data systems.
Manipulating data - Formatting and executing data tasks to integrate with external platforms is one of the core business needs to move data between systems.
Data modeling - it's been relatively smooth to begin the process of modeling our data to fit the structure of multiple business units which all have different data needs. It is flexible and works well with storing and maintaining multiple data structures.
Cons
Being able to execute queries of the same data while multiple users are running tasks at the same time can be problematic and cause the system to run slow.
The support available to troubleshoot system error codes and runtime errors can be an issue and I wished was more readily available.
It has been costly when we've had to scale up some of our marketing databases and data structure sizing and I would like to see a change to the cost model.
Likelihood to Recommend
The platform is a viable and flexible option for larger cross functional and technical teams who have evolving data needs and need room to move from different systems of record and multiple sources of data over time. It is not as appropriate for smaller teams that have single databases that do not connect to external systems or existing tools in your tech stack.
We have explored the usage of Db2 as a relational database for hosting our Financial data, as it well integrates with receiving CSV files, which most of the Financial department rely on. Db2 was considered as the analysts are more comfortable with using standard SQL and in particular Db2 Big SQL, which facilitate their day-to-day queries. On top of that, it was also interesting exploring it for AI applications, as they would require more scalability capabilities.
Pros
Scalability
Security
Integration with different sources
Support for hybrid cloud deployments
Cons
Training materials and documentation (due to shortage of IBM-savvy engineers)
Upgrades require additional team planning, to ensure they go smoothly
Likelihood to Recommend
It is best suited for scenarios where security cannot be compromised (such as, financial systems). This is something that Db2 caters for and why it was considered in our use case. Its recoverability capabilities are also important to note, again due to some systems requiring availability 24/7. In general though, it is an Enterprise solution, meaning that the licensing cost can be hard to shoulder for smaller companies, which coupled with the lack of trained engineers on it, make it less attractive to more mainstream solutions
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)
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 Db2 we are using as a database for our production wesbsite and being used for storing relational data for like product information, product structure, raw materials, vendors ,customer, purchase orders, receiving reports ,details of critical machinery,infrastructure and processes involved in manufacturing of parts .Scope of use case is for data anlaytics for getting insights about production planning.
Pros
super efficient query mechanism
Low latency for applications using databases
good for analytical work
Cons
simple migration from other popular databases
graph databases like capability
security at tabular level
Likelihood to Recommend
it is best suited for use cases meant for relational databases like production environments where lot of data need to be stored in different tables and in one way or other way that data is interlinked like supplier information, customer information, product information etc with support for XML, JSON, text and spatial data formats and less suited to knowledge Mangement, fraud detection, real time recommendation engine etc where graph databases are more suitable.
