1. Home
  2. Relational Databases
  3. Db2 Reviews
  4. User Review of Db2
Why use IBM DB2?
Updated December 11, 2023

Why use IBM DB2?

Diovani Dupont | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Software Version

Db2 on cloud

Overall Satisfaction with Db2

I'm a fan of IBM technology, I'm currently studying systems analysis and development, as I'm studying data science I needed to look for a relational database based on SQL where I could store my data. At the moment I use DB2 for studies so I opted for the DB2 Community license, it is simple and free.
  • Storage optimization
  • Rapid database development
  • pureScale technology, which focuses the database on availability and scalability
  • Simplicity and security when performing migrations
  • Ease and flexibility in implementation
  • The relational model requires a rigid schema that does not necessarily fit with some types of modern development.
  • Proprietary database, requires a lot of Hardware for its good performance and its costs are high.
  • As data grows in production environment, it becomes slow.
  • Improved hardware compression had a positive impact on performance. For example, utilities that run on compressed data run faster.
Db2 for z/OS enables organizations to run mixed workloads with exceptional scalability, high-performance horizontal growth, greater scalability is achieved, the system can grow beyond the limit of a single machine while its database remains intact. It improves performance, reduces resource consumption, maintains database integrity, and increases business resilience.
Until the moment I had availability problems with DB2.
Before selecting Db2, I had the opportunity to work with three different products: MySQL, IBM API Connect and IBM Cloud Databases.MySQL is a very popular and effective relational database management system, especially known for its ease of use and reliability. While working with MySQL, I appreciated its flexibility and vast support community. However, when it came to handling large volumes of data and high availability resources, I felt I needed a more robust solution like Db2.IBM API Connect, on the other hand, is an API management solution that helped me create, run, manage and secure APIs, but it is a tool with a different focus compared to database management systems. Its functionality is complementary to what Db2 offers, but does not replace the capabilities of a dedicated database.Finally, IBM Cloud Databases offers a set of integrated database services in the cloud. Experience with IBM Cloud Databases was valuable, especially in terms of scalability and flexibility in the cloud environment. However, I chose Db2 for its superior performance, advanced security, and robustness in mission-critical environments.In summary, Db2 was selected because of its excellent balance between performance, security, and the ability to handle large volumes of data efficiently. Additionally, its integration with a variety of tools and systems, along with comprehensive support from IBM, made it the ideal choice for our project's specific needs and objectives.

Do you think Db2 delivers good value for the price?

Yes

Are you happy with Db2's feature set?

Yes

Did Db2 live up to sales and marketing promises?

Yes

Did implementation of Db2 go as expected?

Yes

Would you buy Db2 again?

Yes

Db2 offers many advanced features to improve data and database management. Actionable compression can save storage space without sacrificing performance. Many query predicates can be evaluated without needing to decompress the data. Hybrid Transaction Analytics Processing, or HTAP, performance is accelerated by Db2 BLU single-statement, multi-data, or SIMD column storage, data skip and skip technology on LUW platforms, and the IBM Db2 Analytics Accelerator on z/OS. A DBA can build a temporal database using Db2 to allow system and business changes to be captured, maintained, and queried. This allows organizations to store past, present, and future time-related information, as well as use time-travel queries to visualize past and future data states. AI and machine learning (ML) capabilities, including augmented data explorer, offer natural language query capabilities, an ML query optimizer, and a hybrid data management platform to enable seamless sharing of structured data, unstructured and semi-structured. The choice of deployment model includes on-premises hosted cloud deployment or managed cloud deployment. Db2 on LUW platforms offers an Oracle SQL compatibility option. Db2 for z/OS enables organizations to run mixed workloads with exceptional scalability, high performance, and 24/7 availability.

Using Db2

2 - Although I am currently using MySQL, IBM API Connect, IBM Cloud Databases, and Db2 for study purposes only, each of these products represents distinct and essential business functions in an enterprise environment.MySQL: It is a relational database management system. In a business context, MySQL is often used to store and manage data efficiently, supporting web applications, customer information systems, e-commerce and more. It represents the business function of data and information management.IBM API Connect: This product represents the integration and management function of APIs, essential for the development of digital business strategies. It allows companies to create, manage and secure their APIs, facilitating integration between different systems and applications, and promoting innovation and business agility.IBM Cloud Databases: Represents the cloud database management function, offering flexibility, scalability and efficiency for companies operating in cloud environments. It supports multiple database workloads, helping organizations quickly adapt to changing business and technology needs.Db2: IBM's Db2, being an advanced database management system, represents the business functions related to high-speed transaction processing and complex analytics. It is ideal for environments where reliability, data security and performance are critical, such as financial systems, logistics operations and big data analytics.Each of these products plays a vital role in supporting an organization's business operations and strategies, ranging from data management to digital integration and innovation.
As I am a student and currently using Db2 primarily for educational and learning purposes, I do not have a dedicated in-house team to support Db2 on an ongoing basis. My focus is on understanding the functionality and capabilities of Db2, not on providing operational or technical support for it in an enterprise environment. Therefore, all support or implementation issues related to Db2 are handled autonomously, using available educational resources and learning materials, as well as relying on support from the online community and forums when necessary.
As a student, my 'organization' is essentially my educational and skill development journey. In this context, Db2 is having a significant impact on the way I learn and understand database management systems. Using Db2 is helping me develop a deep understanding of database concepts such as manipulating large data sets, performing complex transactions, and implementing data security practices.Furthermore, it is preparing me for future professional challenges, as learning to work with an advanced tool like Db2 puts me in an advantageous position in the job market. It's teaching me about the demands of enterprise IT environments and how database systems can be optimized for efficiency and scalability.Although I am not applying Db2 in a traditional business scenario, the experience gained is equipping me with valuable skills and practical knowledge that will be essential in my future career, whether in software development, data analysis, or banking systems administration of data.