IBM Db2 Database Reviews and Pricing

Database Manager at a tech company with 51-200 employees

Feb 2, 2013

A useful tool due to its simple development environment and support for multiple technologies

What is most valuable?

• The structured query language dialect of DB2 is more powerful than other databases. It has features like object tables, java method support and multiple user defined functions. Data can be accessed directly via the database management interface of DB2 using SQL. • DB2 offers multiple platform support. It runs on all available platforms rather than just windows based platforms. This multiple platform support brings flexibility to the table that other database engines do not offer.• Self-tuning memory management feature of DB2 version 9 optimizes performance with no human intervention by allowing the database to automatically change the memory allocation when there is a change in the work load.

What needs improvement?

• Learning and understanding DB2 is a difficult process because no more resources are available for knowledge base.• DB2 is not a full graph database because it lacks inference engine.• Finding a database Administrator of DB2 is difficult.

What other advice do I have?

IBM’s DB2 is a robust relational database management system (RDBMS). Due to several advantages that DB2 offers, it continues to enjoy strong market presence. DB2 is very useful because its development environment is very simple and supporting multiple technologies with improves security other than database application. DB2 provides secure and safe environment and more improved development to enhance audit ability and security in key areas. DB2 provides hybrid data management for both relational and XML data and supports variety of platforms including, Linux, UNIX, Windows and can be used to power a variety of solutions including Web, SOA, data warehousing, ERP and other business and operational database applications.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.

Ahmed Ashmawy

Data Practice Lead at Hyve Technology Consulting

Jun 20, 2023

Download

A stable solution that needs to improve documentation and scale computing

Pros and Cons

"The solution is stable."

"The tool is not easy to use. It needs to improve scale computing so that the tool can be scaled vertically. The product needs to enhance pre-engine optimization and it needs to be more efficient in completing queries. The documentation should be updated to include different scenarios of deployment."

What needs improvement?

The tool is not easy to use. It needs to improve scale computing so that the tool can be scaled vertically. The product needs to enhance pre-engine optimization and it needs to be more efficient in completing queries. The documentation should be updated to include different scenarios of deployment.

For how long have I used the solution?

I have been working with the product since 2015.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

The tool doesn't work as a distributed database based on customer needs.

How are customer service and support?

The tool's support team is hard to reach.

How would you rate customer service and support?

Positive

Which solution did I use previously and why did I switch?

I have also worked with Microsoft SQL server. This product is easy to use. It is also smarter in optimizing the queries. Microsoft SQL serves is also easy to maintain on the operations side when compared to IBM Db2.

How was the initial setup?

The tool's time length for deployment depends on the design and can take around two days to three weeks to complete.

What other advice do I have?

I recommend the product to medium enterprises. I would rate the solution a seven out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner