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
21 Reviews
Engineering
Search is temporarily unavailable. Filters are still applied.
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.
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
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 is an object-relational database. It supports database servers; it also extends to support object–relational features and non-relational structures like JSON and XML. It provides high availability and helps with zero downtime and no data loss. It also aids in data partitioning by indexing and delivering optimal performance since it has data governance in Unity catalogs in Data Lakehouse.
Pros
Data Governance.
High availability disaster recovery.
Data replication.
Cons
Data partitioning can be optimized with better partition algorithms.
Likelihood to Recommend
Db2 is well suited for the High data availability, which significantly helps the enterprise by providing zero downtime. This resulted in fewer outages and a great customer experience. Often, Db2 lags in data partitioning since the algorithm's performance is not that great compared to the other object-related databases.
In financial sector the organisation deals with high volume of data transaction which should be highly reliable and secure at same time. IBM Db2 can help to meet these standards and helps client to effectively manage and process massive data while ensuring integrity and complaince with regulatory standards
Pros
Security
Regulatory complaints
High volume of data processing
Cons
Cost
Hardware optimisation
Administration
Likelihood to Recommend
Well suited for use cases such as Regulated industries,Data warehousing,Mixed workloads Less suited for scenarios such as small businesses, simple data storage, and community driven developement etc.
I have worked directly with IBM DB2 since the 1980s to the current state of my responsibilities. Initially, working with DB2, it was hosted on a 3090 Mainframe Processor and then on a MF Z/OS platform. As in the past to present, we use DB2 for large transactional applications, which oftentimes are very large tablespaces that can accommodate millions upon millions of rows of data. Oftentimes, we find that using an application program such as Cobol defeats the purpose when the application begins to grow by leaps and bounds; this is where DB2 fits the bill by providing efficiency and stability. We have also been using DB2 on Cloud for a while now. Seamless and transparent and eliminates various onsite interactions from a processor standpoint. Scales out as needed.
Pros
Unparalleled availability 5 9's.
Optimization of application data utilizing machine learning and AI.
Provides simplistic step by step tablespace generation.
Cons
Learning curve. It takes time to learn DB2; I'll be quite frank: no one can come in without any knowledge and start working with it.
Database tuning at times can be time consuming and cumbersome.
Training can be very convoluted for someone with little experience, can be very daunting.
Likelihood to Recommend
I've worked with DB2 and Oracle for a long time; both are good products. However, I much prefer DB2 over any other database product; steady and reliable and does what it is supposed to do.
Inventory, ingest and question open information designs utilizing a solitary stage that upholds tight joining with your information lake over cloud object capacity. While implementing of the data over cloud for analytics the queries, the implementation of data analytics over cloud is much simpler and efficient here. Provides a stage that limited grating for clients by being exceptionally viable with existing SQL code, and simple to incorporate with SAP applications.
Pros
Bind together your information.
Interface dashboards and reports with the force of quick ingest and querying for constant bits of information.
Enable high performance and cost predictability based on object storage
Simple, Efficient and Reliable
Cons
Auto querying techniques
More enhanced dashboard features
Simplified navigation while jumping in data
Likelihood to Recommend
Its best suited where users want to create and predict with high-performance machine learning models inside data warehouse. The best feature is it can be integrated with the IBM AI: Watson for features and functionality. In helps the users perform real-time analytics and generate an instant report. However, prefetching and modelling of the data needs to be done at users end or in the different Db2 which can then be integrated again back here.
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.
