In our organization, We use Db2 for couple of application back end database purposes
Pros
Data Management
Data Security
Data performance
Cons
SQL advanced features like certain functions
HADR
Likelihood to Recommend
I think I am likely to recommend Db2 to a colleague because, in my opinion, Db2 is Easy to maintain and good performance DB with great features like security
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.
It is a database that is used for storing information with real time analytics and low latency transactions. We use it in many of our projects to store data for better performance as compared to other SQL databases whenever the project requirements are leaned more towards using a SQL database as compared to NoSQL, the Db2 is out go to preference for it.
Pros
faster data fetching
safer transactions
better indexing
Cons
could be better in terms of scaling
less migration options
could include JSON related indexing like in Postgres
Likelihood to Recommend
It is well suited when the project requires a SQL database and a database with faster retrieval of data and safer transactions is needed, if the project leans a lot on JSON related fields and it is required for the data be dependant on JSON indexing, I'd say avoid it altogether.
VU
Verified User
Engineer in Engineering (Computer Software company, 11-50 employees)
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.
VU
Verified User
Manager in Marketing (Computer Software company, 10,001+ employees)
After almost 4 years with Db2, I can confirm its reliability and accurateness and many features. As an illustration of its stability, it handles our situation with many transactions without issues and complaints. Also, due to its cross-platform interoperability, our efficiency increased, and we gained useful information. Finally, troubleshooting is very easy if any issue arises and can be solved very easily with detailed documentation and a helpful community.
Pros
Compatible with almost every 3rd party application, it is easier to link and integrate.
Very accurate and reliable. It has a reliable community and detailed documentation.
Has great data protection and security and robust backup options.
Cons
It is very difficult to setup or configure, even with the help of the documentation. So, make the setup process simpler.
The support takes quite some time to reply to our queries, which is sometimes frustrating.
There is nothing else that I see can be improved. Maybe a better UI or dashboard would be great.
Likelihood to Recommend
Both end users and programmers benefit from its reliability, accuracy, and simplicity. It offers the best cloud database management choices, which are very reliable and have almost zero downtime. With it, you can easily handle surges and loads without affecting server or database availability.
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.
Our organization use IBM Db2 to leverages its features such as Performance Optimization, backup and recovery, and resource management to ensure the reliability, scalability and performance of our backend used for demanding API-driven applications. It also plays a crucial role in making sure data integrity, security and compliance with regulatory requirements.
Pros
High Availability Disaster Recovery
Scalability
Real-time Data Processing
Cons
Open Source Initiatives
Automated performance tuning
Simple configuration
Likelihood to Recommend
Db2 excels in mission-critical applications requiring high availability, scalability, and robust security. It may be less suitable for smaller projects with limited resources, as its initial setup can be complex. It's well-suited for industries like finance, healthcare, and telecommunications. Meanwhile, organizations which heavily invested in non-relational databases might find a transition challenging.
VU
Verified User
Professional in Information Technology (Telecommunications company, 5001-10,000 employees)
IBM's Db2 on Cloud has been our primary DBMS software since our migration to the cloud. Our use of Db2 extends across various functions within the organization, including student and employee data management, ERP backend (for enterprise resource planning), transaction processing, and analysis. The scope encompasses the entire lifecycle of our educational and administrative processes, showcasing Db2's versatility and reliability in supporting a large and complex institution.
Pros
Can easily be scaled to growing data volumes.
Seamless integration with ERPs.
Optimizing queries.
High availability, minimum downtime.
Cons
Built in analytics functions would be useful.
Real-time monitoring and alerting can be improved.
Support/Documentation.
Likelihood to Recommend
Db2 is well suited for large-scale relational data management, transaction-intensive environments, and complex workloads. It excels in scenarios where there is a need for integration with enterprise applications. It is less recommended in cases where deployments are small-scale with minimal data management, transaction loads are simple, or resources are constrained. In all these cases, a simpler DBMS solution is recommended.
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.
VU
Verified User
Team Lead in Engineering (Computer Software company, 201-500 employees)