IBM Db2 Database Reviews

I am currently using IBM Db2 for z/OS. It is used to manage a huge amount of structured business data and provides DB services for many different applications.

Its performance is great. In my case, half a million transactions per second are using the DB services of the Db2 mainframe. So, it provides a great ability to support logical units of work.

For every big organization or big site, such as a bank or a credit card company, the most important asset is data. An organization puts all its business data and manages it in Db2 because it trusts that Db2 will be able to provide all the necessary services, such as:

• Business continuation
• The ability to process a large amount of data
• The ability to maintain a large amount of data
• The ability to execute DB services in a fraction of a second

Its functionality and availability are valuable. Its availability is great. It is available 99.99% of the time. 

Its security is great, and there is also the ability to execute very complex SQL statements. It provides the developers the ability to get the functionality using great tools like SQL and many other additional features.

The management of Db2 should be simplified because there are not too many specialists in this area, and the learning curve of Db2 specialists is very long. After the courses, probably it takes one and a half or two years to get to the point when you are using the product properly in the production systems. So, the complexity is very high, and the most important thing is to simplify the management of the product, including self-maintenance. They should simplify the installation, management, and monitoring to simplify the product. It takes too long for a person to be a specialist in this product.

The price should also be adjusted a little bit. IBM is quite expensive with respect to the product.

I have been working with this solution for 34 years.

It is very stable.

It is absolutely scalable. It is hard to count the number of users. For example, in a bank, each and every customer of the bank uses the product. There are hundreds of thousands or, in my case, even millions of customers. There are also people who are not customers but access the website of the banks to look at something. Those people are not registered, but they're using the product as well. So, there could be millions of users. In the banks where I work, the business is growing. With the growth of the business, the number of users is also growing every year by a small percentage.

If Db2 is properly used, an organization can build a database with thousands of tables, and it can provide the exact information for the applications within a second. We have 500,000 transactions a second, and each of them needs to get some information from the database to perform a show, insert, or delete operation for different users. In the banking or finance domain, there are a large number of transactions. Even in a small country, there would be a large number of transactions every minute or seconds of the day. Db2 is capable of providing services for each and every transaction.

Currently, technical support is concentrated in IBM's main supporting facilities and laboratories. Years ago, each and every country had its own engineers who provided technical support, but today, it is concentrated in a few hands through the support centers of IBM, and their support is good.

Before Db2, we used IMS. It was years ago, and currently, in addition to Db2, the same organization is using Oracle, MSSQL, MySQL, and even NoSQL databases, such as MongoDB. During the past five years or so, the NoSQL databases are getting in as well. So, we are using a few RDBMSs and NoSQL databases as well in parallel.

When I compare IBM's mainframe Db2 for z/OS with other relational database management systems, this one wins against almost each and every other database in terms of abilities and performance. Optimizing the scales or optimizer for creating the access process is probably the best in the world. In many aspects, Db2 wins against almost each and every other RDBMS, including Oracle, Microsoft, MySQL, and NoSQL ones. However, in the area of complexity and maintenance, probably the others are better.

It is quite complex. It is not a simple installation. If the installation is done by a specialist, it takes a few hours.

It was implemented by our own in-house team. For deployment and maintenance, in a big organization, probably two DBAs are required to be on the safe side, in case one of them is on holiday or something like that. Two people are sufficient to maintain the product.

It is expensive. The price depends on the size of the machine on which you are installing the Db2 and the features you are using. It also depends on the country. IBM has different policies and different options for payment for this product. 

IBM Db2 manages a huge amount of structured business data and provides DB services for many different applications in banking, military, logistics, and other areas. Big organizations that are using IBM mainframe are using Db2 Database for providing the database services for various applications. Thousands of organizations in the world are using Db2 for managing their data—their most important asset. By using Db2, they can manage this huge amount of data by building an enterprise-wide data model, consisting of thousands of entities and tables. When built with a proper methodology, Db2 is a great asset for each and every organization.

IBM mainframe Db2 for z/OS would probably be the best platform if you need a database that is not limited to one specific area and can provide you with the following:

• Different DB services
• Different functional and application areas
• Parallel processing abilities with a big amount of relational structured data

It will be difficult to find a better solution for such a business.

I would rate it a nine out of ten. It is very good.

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. 

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.

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.

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.

We use it to manage a data warehouse for customers. The data warehouse is focused on marketing, commercial and sales data.

The performance of the solution is valuable.

The initial setup could be improved.

We have been using the solution for approximately five years.

The solution is stable.

The solution is scalable, and approximately 50 users in our organization are currently utilizing it.

We have had a good experience with customer service and support. I rate customer service and support a ten out of ten.

Positive

The initial setup is not easy but can be completed with the assistance of the IBM technicians. It took us about four to five months to complete deployment.

The licensing cost is charged annually. I rate it a ten out of ten.

I rate the solution a nine out of ten. The solution is good, but the initial setup can be improved.

I am an ex IBM employee, and I used to be the brand ambassador for Db2 in Africa. So, I do understand how it works because I've used it with customers. Currently, I am mostly supporting some of the Db2 customers in Kenya.

I am now using version 11.1, but I used version 10.5 for the longest time. 

It has a good feature called pureScale, which is just for scalability. It is a perfect solution for environments where scalability is going to be an issue.

Microsoft SQL Server is comparatively very simple to use. I wish IBM would move towards making Db2 easy to use for both basic and advanced users. This is where I see room for advancement. Db2 is also more expensive than Microsoft SQL Server, and its price can be reduced.

The replication feature needs to be there in Db2. Microsoft provides similar functionality in SQL Server. IBM also has similar functionality, but it exists in a different product. So, to have the replication ability, you have to buy a different product. It makes sense to have this functionality within Db2 instead of a different product. It will also be helpful in terms of competition.

In Africa, the problem for Db2 is competition. Oracle Database and Microsoft SQL Server have been in this market for a very long time. These companies have built the ecosystem and the brand within this market for a very long time. So, they are very popular with users. Db2 or IBM came a little later in the game, and that's where the problem lies. They also don't do a lot of marketing for it, which is also a problem.

I have been using this solution since 2012. It has been nine years.

It is stable. The 10.5 Fix Pack One was not very stable. We also had Fix Pack 4, also called Cancun Release, which was very stable. As the product has evolved, it is more stable now than it was a couple of years ago.

It is a perfect solution for environments where scalability is going to be an issue. I am supporting two banks. They use Db2 for their core banking system. There are more than 500 users per bank who use this solution every single day.

I have worked with IBM, and I have seen their support teams. They are very passionate about supporting their users. Whenever there is a problem, they have a team that is there 24/7 to ensure that their customers are supported. They are very fast and very technical in solving problems.

I have used SQL Server, IBM Db2, and Oracle Database. Microsoft provides usability. SQL Server is very easy to use and adapt. The only problem is that it only lives within the Microsoft Windows operating system, whereas Db2 is available on Linux, Unix, Windows, and Linux for mainframes. 

When comparing IBM Db2 and Oracle Database, I would go for IBM Db2 because it has complete functionality. A lot of features available in IBM Db2 are not there in Oracle Database. IBM Db2 has time travel queries that are not available in any other solution. From the perspective of a software developer or a database developer, there are more functionalities in IBM Db2. It is more futuristic.

It is very technical to deploy, but once you configure and make it work, it is a perfect solution for an environment where scalability is going to be an issue.

Among Microsoft SQL Server, Oracle, and Db2, Microsoft SQL Server is the cheapest one, and Oracle is the most expensive one. Db2 is in the middle. As compared to SQL Server, its price could go down. It will be good for customers.

I would love to expand its usage in the future. We are looking to migrate the finance industry customers in Africa to Db2, especially from Oracle to Db2. 

I would rate Db2 an eight out of ten.