IBM Db2 Database Reviews

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.

We primarily use the platform to store query data. I work in a bank, where we store customer information on it.

The product has improved our organization by performing well for data storage and queries. It helps us retrieve information quickly.

The solution's querying feature is most valuable. It allows me to retrieve data quickly.

The solution's data retrieval speed could be improved, especially for heavy queries. Better optimization or indexing might also be involved.

I have been working with IBM Db2 for about two years.

The product is mostly stable, even in a large organization like ours. 

I rate the stability a nine out of ten.

We manage around 15,000 to 20,000 platform users. I rate the scalability an eight out of ten. 

I do not interact directly with the technical support team. 

Our internal support team handles any issues and communicates with the provider.

The solution has been good with strong performance, contributing to our organization's efficiency.

We use the product combined with other solutions, such as SAP Crystal Reports and various reporting tools, but we do not directly integrate it with databases like SQL Server.

I rate it as ten because, despite occasional issues, it performs very well overall.

We use the solution for handling retail customer information. We use it as an integration broker. It stores all the vendor information.

We rely on it for our data transfers. If we need to send an invoice, for example, we'd use this product. 

The solution is very stable and reliable. It's a very mature product.

If you have specialized support, it's fine in terms of getting assistance.

The solution can scale. 

IBM gives us tools that help us 

When I look at Microsoft SQL Server, SQL Server provides me with better tools for database management. IBM is missing things like data permissions and backups, et cetera. Microsoft has a very user-friendly interface that IBM lacks. The user interface from IBM is not great.

I've used the solution on and off for the past ten years. 

It's a stable solution. It's been around for quite some time and is very mature. It's reliable. There are no bugs or glitches, and it doesn't crash or freeze. 

It's quite scalable. We haven't had any issues. We can reuse DB2 mainframes, et cetera. We haven't had issues. 

We're not increasing usage. We're pushing towards the cloud and Azure systems. 

We are a big customer of IBM and have some sort of specialized services. We have an elevated support agreement that helps. In general, it's not the greatest. That's only at a personal level.

Neutral

I am familiar with the Microsoft SQL Server, which is more user-friendly and has more user-friendly features. We're also exploring moving away from this solution to more cloud-based Azure services. 

The setup wasn't part of my job. We had a team that handled it. However, my understanding is it was straightforward. 

I don't deal with the pricing. I can't speak to its exact cost.

I'm not a database person. I'm a programmer. 

I'm using version nine in the company.

If a person wants to use the solution from a user perspective, I'd suggest they actually look at cloud programs, not IBM or on-premises. Cloud simplifies a lot of things. If I were starting from scratch, I'd go right to the could.

The reliability is excellent, and therefore I'd rate the solution eight out of ten. I only have issues with the user interface.

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. 

The only reason we are using IBM Db2 Database is that our client has an IBM setup for a data warehouse.

IBM Db2 Database could improve the user-defined functions. There are some user-defined functions that are missing, such as the spring functions. I used to have  Teradata for my projects and I was used to working in the environment. They had a good set of user-defined functions.

In a future release of the IBM Db2 Database, it could be helpful to have SQL assistance. Teradata had this feature and it was very useful to connect to warehouses.

I have been using IBM Db2 Database for approximately one year.

The stability of IBM Db2 Database is stable. We have not faced any downtime in one year. Our work is mostly during business hours and during that time, we haven't faced any downtime. However, we did see some performance issues when we are running multiple queries. The client's setup could be causing these performance issues. We are pushing that client to have the environment ready for multiple users so that they can query the database easily and faster data travel.

I have not used the support from IBM Db2 Database.

I have previously used Teradata and I started my career on it as a developer. I was doing migrations from Db2 or different databases to Teradata. The database of Teradata is very useful and is performance-based when it comes to data warehouse solutions.

We have three to four people in our DBA team for the maintenance of this solution.

I rate IBM Db2 Database a six out of ten.

We use it for the core banking business. We have Db2 for z/OS 2.4 on the IBM mainframe machine. It is on-premises of one of the big banks in Israel.

Its robustness, scalability, availability, and performance are valuable. All these are the major attributes of a relational database for supporting a very high-volume business, and Db2 is very good in all those areas and in all those attributes.

They should simplify the management of Db2 as a relational database system. There should be the simplification of management. This is probably one of the most important asks for being successful in the future.

They should add AI support for performance improvements for application and system performance and tuning management. AI is a very deep and complex product. There are thousands of parameters, and it is very hard to do it manually. So, I would suggest developing an AI system to do the monitoring, tuning, and performance improvements.

I have been using this product for 40 years.

It is very stable. There are organizations where Db2 has been working for more than a year and sometimes, for many years without going down. The operating system as well as Db2 work for a long time. There is no downtime at all.

It is very scalable. There are about 250 application systems with even more different databases on the same server with data sharing.

Their technical support is okay. It was better 10 years ago, but it is still okay.

It must be done by a professional. It is not a simple task. Somebody with quite significant experience must do the initial setup. It is difficult.

It is expensive.

I would rate IBM Db2 Database an eight out of 10.

The primary uses for this product have to do with the card management system for banks. We are working mostly in the financial sector and banking sector, so there are some card management systems there that we often work with. There are some databases for which we see value in using Db2, so we are working with this solution.  

One of the things I like most about Db2 is that it is almost maintenance-free. I do not have to maintain it, unlike a modal database. I have been using modal databases for a long time and those are more sensitive. It is almost 15 years now that I have been using modal databases and it is almost tedious to use modal databases by comparison. I have been using the Db2 more recently and both database types are in use in my company. With a modal database, I have to check to see how or if the data is coming through. But in Db2, it is not as much of a headache. It is also easier to understand than modal database structures.  

One thing that is a little bit difficult for me — other than when using Oracle — is creating database replication with Db2. It is not so easy. That feature could be improved.  

Another thing is that if part of the environment in Db2 goes down, I have to restore all of it. That is something that is just in the environment for the Db2 relational database. The restoration is very difficult because every node has internal storage. If one node is corrupted all have to get restored.  

If you compare Db2 to Oracle, both are enterprise-class. However, the development tools for Db2 are not as good. For example, if I want to develop an application in Db2, I have to use Java. That is not so easy because someone has to know the Java platform and a few other things to develop an application on Db2. But the difference is that if you choose to use Oracle there are some tools like Oracle Developers Suite that you can use to develop applications. It is very easy and very straightforward to develop an application in Oracle because of the development tools. It is harder when using Db2 by comparison.  

There are some things that are not in Db2. I have to do more to develop an application. Some things are easy to do with Db2 development. Like if I have an application where there will be three or four tables. I can do that with Db2, or I have to do it with other Java development tools. That is the catch: for most of the people who know Java, this development is easy for them. But those who do not know Java can have a very hard time. In that sense, IBM should work on that aspect of their product to make it easy to develop applications. They can do this by providing users with a development suite. If they do that, then I think Db2 has the potential to grow more in our market.  

I have been using Db2 for almost eight years.  

The stability of Db2 is good. It is very stable. Once we have the installation complete and the team is done with the job, there are some customers who go five years without having to do anything to Db2. It is very stable and runs smoothly for them the entire time.  

With scalability, I do not have as much experience as other teams in our group because I am on the sales end. I do not have experience on that side. Because we are a business partner of IBM, we all understand the use of Db2. In our company, the main focus is always on what the customer wants and what kind of applications they want to build. As we are working in the financial sector, they have DBS (Disclosure and Barring Service) and these requirements need to be fulfilled. What the customer wants ends up determining which database we suggest that they go for. In that sense, our market is mostly Oracle. But if they are trying to keep their budget concerns in check, then we will go for Db2, because it is less costly than Oracle.  

I find the technical support team is not so aggressive as Oracle. If I put in a request or a ticket it takes time for the team at IBM to reply. Almost always at that point, they are not replying with an answer. I have to do something to give them more information. They could be more efficient in the way that issues are handled. With Oracle, it will not take even half an hour and they take a readout and give you a solution. Oracle's support is very straightforward.  

I think that IBM needs to do better in training its support service to improve response time and efficiency. They should have a better structure to their support request responses and better procedures to follow. Right now, these procedures are not in place.  

In my scenario, I have installed both Db2 and Oracle for different use cases. I have not personally found that much of a difference. But I think the difference between this Db2 is what the customer wants. Some want to work on Db2 and some want to work with Oracle.  

One feature I like in Db2 is the self-maintenance feature. That maintenance feature or something like it is not found in Oracle. With Db2, it is safe to use self-maintenance with any data and that is the main feature in Db2 that I like.  

The initial setup for Db2 is really straightforward. Their deployment and integration are very easy and straightforward. The environment takes a maximum of 40 minutes for installation. I have done it by myself. The complete deployment is not so easy that it is a simple repetition to do the same way on every site, but two or three weeks will be all that you need for an enterprise installation.  

The pricing is done by our pricing team and the quotes are given to the client's finance team. So in that sense, I do not have direct experience with the pricing models. I can say that Db2 is less costly than Oracle because I am selling both and I am doing enterprise sales for both. When a customer gets a quote during the buying process, I can see the pricing. The pricing for Db2 is always less than Oracle.  

On a scale from one to ten (where one is the worst and ten is the best), I would rate IBM Db2 Database as a seven-out-of-ten.  

Most of the time recommending Db2 is harder than recommending Oracle because of the situation in our country. Whenever I propose Db2 to a customer, the customer will ask what they need to have to develop applications on Db2. I have to say to them that they need to have a Java developer to work on that. If the customer already has some Oracle databases, this makes introducing Db2 even more difficult because they already have the resources for Oracle development. Suggesting Db2 is difficult in our country because most of the people already have Oracle now. So suggesting Db2 is difficult because development on Db2 is not as easy as Oracle and finding the resources to work with it is not as easy. The question we have to answer all the time is who will do the development if the customer does not have a Java developer resource already.  

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.

The solution is running on top of IBM I proprietary hardware/software. It shows great stability. DB2 has improved the way our organization functions because we do not have to tune it. There is an autotuning function integrated into the OS, which is useful. On other databases, there is a need to do tunning from time to time.

Has a very good RDBMS with high throughput, customizable security features, and a reasonable licensing price.

The solution has many beneficial features, such as security, support, and stability.

IBM Db2 Database is not ACID compliant, which would improve it. Db2 lacks Isolation, so when two people are trying to update the same field at the same time it can become stuck. Other newer databases do not have this issue, such as Microsoft SQL, Oracle DB, PostgreSQL, and SAP HANA.

I have been using IBM Db2 Database for approximately thirteen years.

We did not have the need to scale the solution.

We are using the solution on a daily basis.

We have a good SLA contract with the vendor for support.

I rate the support from the IBM Db2 Database a nine out of ten.

Positive

I rate the initial setup of the IBM Db2 Database a seven out of ten.

The deployment of the database took one day and the application took some time because of the testing and integration.

I rate the price of the IBM Db2 Database an eight out of ten.

If someone is looking for a robust database with a reasonable price and security measures IBM Db2 Database is a good choice.

I rate IBM Db2 Database a seven out of ten.

We use the solution as a database for e-commerce applications.

The solution's most valuable feature is scalability.

The platform itself needs improvement. They should develop a containerized version of the solution. In addition, they should include dashboard features as well.

We have been implementing the solution for customers since 2006.

It is quite a stable solution. I rate its stability as an eight.

We have 34 technical users and over 50 end users for the solution. I rate its scalability as an eight.

The solution's technical support team could respond faster.

Neutral

I have used Oracle in the past. In Comparison, IBM provides better performance and scalability features.

The solution's initial setup process has medium complexity. It takes a few days to complete. I rate the process as a seven.

I rate the solution as a seven.