IBM Db2 Database Reviews

The value and impact of using IBM Db2 Database lie in its essential role in storing data. The benefits include enhanced performance, reliability, and effective data management compared to other databases.

The most valuable feature of IBM Db2 Database is its ability to perform automatic self-management, reducing the need for manual tasks such as managing logs and folders.

One area where IBM Db2 Database could be improved is its Java development environment. Similar to those found in competitors like Oracle, there could be more user-friendly tools with features such as drag-and-drop functionality, visual basics, and low-code capabilities.

We have been using the IBM Db2 Database for ten years.

The platform is stable. I rate the stability an eight out of ten.

The primary concern is related to the cost implications when scaling with multiple nodes in a database. The associated costs increase when additional nodes are added, each requiring separate storage space. We have approximately four or five Db2 instances being used in the organization.

It is a scalable platform. I rate the scalability an eight out of ten.

I have used MySQL and Oracle in my previous environments. We switched to IBM Db2 Database for auto-management features and reduced manual intervention.

The initial setup is straightforward. We have to install and register. The deployment process includes downloading the software from the vendor's website, having a customer account, copying the downloaded file to the machine, and executing the installation. It takes five to ten days to complete. We have around 50 executives working in the database administration team.

We implemented the product in-house.

We purchase the product's yearly license. Later, we have to pay support and license renewal fees. Its pricing is comparable to other database solutions such as Oracle and MySQL. If you choose to buy IBM Power Systems, there may be opportunities to receive Db2 licenses at a lower cost or even free of charge. However, if the installation is on servers other than open Power servers, standard licensing fees apply, similar to those of other database solutions.

The application has analytical tools to support day-to-day management and analytics needs. It is convenient to meet business needs objects.

Regarding integration with other tools and systems, Db2 can be integrated with comprehensive banking solutions involving various teams, including CVS, analytics, and importing teams.

As for recommendations for those considering Db2, it can effectively impact performance. If an organization predominantly uses Db2, individuals are more likely to choose Db2. However, there is a challenge related to training resources for Db2, which may be less readily available or focused on compared to other platforms like Oracle.

I rate it a nine out of ten.

We work with a few use cases suggested by the IBM Watson Library. All the data is inside the event processor, we can extract it with a query. There are multiple use cases already in the IBM marketplace.

It's easy to search and extract data from the warehouse using queries.

The queries can be difficult for beginners because there are so many. I would like to see more use cases for flow analysis that enable us to correlate the flow with events. Adding this feature in a QI format would be good for beginners.

I have used Db2 for around two years.

I rate Db2 eight out of 10 for stability. 

I rate Db2 nine out of 10 for scalability. We have more than a thousand users. 

IBM's technical support is excellent. They provide a solution in 24 to 48 hours. 

Setting up Db2 is straightforward. Most IBM products I've used aren't complex to integrate or deploy. We deploy it on-premise and in the cloud.

I rate IBM Db2 two out of 10 for affordability. It's expensive but not much more than other tools. There are also cloud-based solutions like Elasticsearch. 

There are multiple competitors like Oracle, but Db2 is the best for our use case.

I rate IBM Db2 nine out of 10. It's more expensive, but it's better than the competing solutions. I have to deduct a point for license costs. Everything else is excellent. We recommend Db2 to many clients, but few adopt it due to the high price tag. If a project has strict budgetary restraints, we typically don't recommend Db2. 

I use IBM Db2 Database for an application that we use in the marketing sector.

I was a consultant.

When we use IBM Db2 Database, we are using a simple SQL server. I didn't use all of the features. It's mainly because when I worked, they used to set up Db2 for DB.

The most valuable aspect of this solution is its stability. We have never had any problems and have never had to contact technical support.

The scalability could be improved, but the problem was that it was something in the legacy of the application where I work.

The problem was not the DB itself, but there were certain limits regarding the application, and the DB was the final component, where we worked. We weren't too concerned with the DB.

It's expensive, but it's not for every client. 

Also, the website could be more intuitive. I didn't find it easy to find documentation on the website.

I have been working with IBM Db2 Database for one year.

IBM Db2 Database was stable, we didn't have any issues.

IBM Db2 Database is not scalable.

We have approximately 8, 000 clients.

We didn't have any issues with IBM Db2 Database. It was stable for us. We did not have the need to contact technical support.

I have some experience with Terraform, from HashiCorp. 

It's a tool for infrastructure, for building automation similar to Jenkins, or Bamboo.

I worked with Bamboo a year ago.

I have worked with databases such as MySQL, IBM Db2, Oracle DB, and some NoSQL databases like MongoDB. We use the threat procedures when we used Oracle DB.

When I worked within Db2, I didn't set up the Db2. I just used it. I didn't do any tuning or anything like that. I only performed some database management.

Clients are required to purchase a license.

I would recommend this solution to others who are interested in using it.

I would rate IBM Db2 Database a seven out of ten.

I used DB2 two years ago. It's a data warehouse project solution for a bank. I use DB2 as a warehouse and the data stacks for the APL.

My role in this project was as a database designer. I would design the database, the warehouse, and get the requirements. 

I am not detailed in the technicality of creating the table in DB2.

I am now selling this product.

The most valuable feature is data analytics.

The price should be lower.

I have been working with this solution for six months.

I use the DB2 BLU version.

This solution is stable. It's good.

I don't' have any knowledge about scalability.

The technical support is good. They have presales and technical support. When you submit a ticket the response time is quick.

Previously we were using SQL Server.

The main difference is the pricing and implementation.

The initial setup was straightforward.

It took four months to deploy this solution.

I only use one server to implement the solution.

I think that everyone knows that with IBM the standard price is higher than the others.

There is a lot of documentation available. I was, however, able to find what I needed through Google.

For our clients who have a large scale enterprise, we suggest DB2 and mid-scale enterprise customers we suggest SQL Server or others.

It's a better solution, it's better on the application. The purpose of DB2 is for a data warehouse or with data analytics.

I would rate this product an eight out of ten.

Our company uses the solution as a database service for a client in the furniture manufacturing industry. 

The solution's security is very tough and impenetrable. 

Hardware and support subscriptions are very expensive. Better partnerships in the Middle East or Egypt could reduce costs. 

The solution no longer supports POWER8. 

I have been using the solution for ten years. 

The solution is very, very stable. 

The scalability is an issue for us because Database Hammer does not work with IBM Power and POWER9 is too expensive. 

Technical support is very helpful and better than competitors such as Dell, Lenovo, or HP. 

We previously used POWER5 and POWER7 so have been with the solution for some time. 

The setup is very easy and we accomplished it through self education. 

We implemented the solution in-house. 

The solution's hardware and subscription model for support are very expensive in the Middle East or Egypt. 

I rate cost a three out of ten. 

Database Hammer does not work with IBM Power or POWER8. It is too expensive for us to purchase POWER9 so we are migrating to AWS and comparing that to Azure. 

Currently, our server and database are shut down and not in use. 

Stability, mobility, and security are rated a ten out of ten but the extreme cost changes my overall rating to a five out of ten. 

I'm using this solution for a financial network. I make and prepare the databases for analysis.

I'm using version 11.5. There are 1,200 people using this solution in my organization. It's deployed on-premise.

It's very secure.

The command line part of this solution could be much better. Redshift is a lot better. It's easier to work with them. IBM Db2 is a little bit outdated.

I've been using this solution for two years.

It's scalable.

Technical support isn't very helpful when I've had problems.

It's not easy to set up. It takes a long time, especially compared to other solutions.

It's very expensive.

I would rate this solution 6 out of 10.

The primary use for our Db2 database is for OLAP (Online Analytical Processing). Our department is using it for data warehousing and data analysis.  

We are deploying some of our enterprise systems to Azure. We would like to migrate data there and most of the systems will be running on the infrastructure as a service, so we will have lots of servers. Migrating data from Db2 becomes an important matter.  

Our target currently is to create the infrastructure which would include the servers, the backup solutions, the databases, application servers and whatever else we need.  

Db2 enables us to analyze big amounts of structured data in DataWarehouse solutions.

The feature that is one of the most valuable in Db2 is the DPF, or the Database Partitioning Feature that use Massive Parallel Processing architecture. We have deployments where one database is deployed on multiple physical servers. It is not exactly like RAC from Oracle. The purpose is not the availability but the performance and scalability of the DPF.  

Integration with other services could use some improvement. Currently, we are using Informatica ETL (Extract, Transform and Load) and the data is not loading as expected between the Db2 database and Informatica. Our goal is to eventually migrate the data to Azure servers and evaluate how it will perform. Currently, we are doing a POC (Proof of Concept) on this migration, but the second step cannot be completed without a dependable data load.  

We have been using Db2 for a long time. Maybe 15 years.  

DB2 is very scalable offering multichoice of possiblities - massive parallel processing and also  clustering.

We have technical support from IBM. If I had to evaluate their services, the quality really depends on the person that gets the ticket. There are some very good specialists on the technical support team and some that are not so good.  

If the ticket is critical, it will go to a queue and the IBM team will help you out very quickly and efficiently. Of course, sometimes critical problems are difficult and take some time to resolve.  

If I had to rate technical support overall, then I would give them about an eight-out-of-ten.  

We are a typical enterprise with the typical array of databases. Primarily we use Db2 and MS SQL, and some others. We have reporting tools like Business Objects, Power BI and Micro Strategy. We also have data warehouses. So we have ETL tools and then we need to have the backups, scheduling, and monitoring. We are using more than one database type for different reasons, so it is not exactly that we have switched away from something else to Db2.  

The initial setup is straightforward. I think that installing the Db2 is not that complex and it should not be a problem for a skilled DBA.  

Usually, we use our own team to maintain our products and we do not require outside services from vendors.  

As we have experience with a variety of database types any one of them could play into our architecture. I was hoping to have PaaS backup solution for the Db2 that we plan to deploy to Azure. But current plan is to back up the Db2 database to storage instead to some service in cloud. Doing it this way we would need to do a work-around and manage the backups by scripting and manage the retention and the sizes and disk drives. It is not optimal and it would be better if we could just send the backup to some kind of API or service in Azure and just configure it to back up images and files. In our testing, that is currently not working with Db2.  

I was looking for this kind of migration solution for the Db2 database, but I could not find it — which surprises me. I looked at the Tivoli Storage Manager, which supports the Db2 backups to the API, but they do not have that kind of PaaS service in Azure.

I have experience working with both Oracle and Db2. Comparing the two products, I would recommend Db2. Both Oracle and Db2 have some unique features that separate them. Although they are different, in comparing the two databases, they are both enterprise grade databases with lots of good features. But from my point of view, Db2 is much better.  

On a scale from one to ten where one is the worst and ten is the best, I would rate Db2 as an eight. It is not rated higher because I think that there are things that can be improved. It is currently not perfect. The graphical tools are not good. It is very common for GUI interfaces in IBM products to be lacking. For the first-time user who has no experience with it, the GUI will not seem very straightforward. If you had to work with it for four years, then you get used to it. But for the first-time users, it is not that user friendly.  

If some of the user-interface features can be enhanced, it could be a nine. Db2 is a good database. It is for structured data and there is always room for improvement. It requires an experienced person to handle it.  

I use the product to audit databases, SQL statements, and user activities. I am currently working on migrating the on-premise database to IBM Docker.

The solution helps secure the database. We can encrypt the data and mask the tables using the solution.

When we enable audits on our database, there is a server overload. The product needs to improve its configuration and storage.

I have been using the solution for six months.

The tool is stable. I rate the tool's stability an eight out of ten.

I rate the product’s scalability an eight out of ten.

The support team didn’t give me a quick response to the issue I raised.

Neutral

The initial setup is complex. Since the database has various types of data, we must integrate it with the audit server. An expert in Linux can easily manage the integration.

It takes three to four days to deploy the solution. We needed help from IBM to implement the solution. We need only one person to maintain the product.

The solution costs less than other products. I rate the pricing an eight out of ten.

Guardium can be used in confidential environments. There are many customization options available in Guardium. We purchased the solution in 2018. I will recommend the product for auditing. Overall, I rate the solution an eight out of ten.