Try our new research platform with insights from 80,000+ expert users
Luigi Notarantonio - PeerSpot reviewer
DevOps Engineer at Cy4gate srl
Real User
Feature-rich, and performs well, but the price could be reduced
Pros and Cons
  • "The most valuable aspect of this solution is its stability. We have never had any problems and have never had to contact technical support."
  • "Also, the website could be more intuitive. I didn't find it easy to find documentation on the website."

What is our primary use case?

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

I was a consultant.

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

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

Buyer's Guide
IBM Db2 Database
November 2024
Learn what your peers think about IBM Db2 Database. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

IBM Db2 Database is not scalable.

We have approximately 8, 000 clients.

How are customer service and support?

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.

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

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.

How was the initial setup?

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.

What's my experience with pricing, setup cost, and licensing?

Clients are required to purchase a license.

What other advice do I have?

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

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

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Department Head of Big Data and Analytic Solutions at a tech services company with 501-1,000 employees
MSP
Data Warehouse for large enterprises with good technical support
Pros and Cons
  • "When you submit a ticket the response time is quick."
  • "The price should be lower."

What is our primary use case?

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.

What is most valuable?

The most valuable feature is data analytics.

What needs improvement?

The price should be lower.

For how long have I used the solution?

I have been working with this solution for six months.

I use the DB2 BLU version.

What do I think about the stability of the solution?

This solution is stable. It's good.

What do I think about the scalability of the solution?

I don't' have any knowledge about scalability.

How are customer service and technical support?

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

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

Previously we were using SQL Server.

The main difference is the pricing and implementation.

How was the initial setup?

The initial setup was straightforward.

It took four months to deploy this solution.

What about the implementation team?

I only use one server to implement the solution.

What's my experience with pricing, setup cost, and licensing?

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

What other advice do I have?

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.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer:
PeerSpot user
Buyer's Guide
IBM Db2 Database
November 2024
Learn what your peers think about IBM Db2 Database. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
Cosmin CIobanica - PeerSpot reviewer
Global Solutions Architect at a tech vendor with 10,001+ employees
MSP
Top 20
A tool that offers better performance and competitive advantage when compared to its competitors
Pros and Cons
  • "The most valuable feature of the solution is its compatibility with IBM Power Systems."
  • "I would say that the tool has to be made more cloud-friendly and should have agreements with AWS, Microsoft, or Google to run things on hyperscalers."

What is most valuable?

The most valuable feature of the solution is its compatibility with IBM Power Systems.

What needs improvement?

IBM Db2 Database is not a commodity product compatible with hyperscalers. IBM Db2 Database needs to work more on compatibility with other platforms.

Considering the competitors of IBM Db2 Database, I would say that the tool has to be made more cloud-friendly and should have agreements with AWS, Microsoft, or Google to run things on hyperscalers. In general, I would want the tool to have a bit more openings around cloud solutions rather than only being available on-premises.

For how long have I used the solution?

I have been using IBM Db2 Database for a few years.

What do I think about the stability of the solution?

It is a stable solution.

What do I think about the scalability of the solution?

It is a scalable solution.

It doesn't really matter whether small companies or big companies use IBM Db2 Database. Whether to choose IBM Db2 Database or not depends on a customer's preferences.

What's my experience with pricing, setup cost, and licensing?

If I consider the price of IBM Db2 Database, I would say there are cheaper products in the market.

Whether or not there is a requirement to pay additionally for maintenance or support apart from the standard licensing fees of the solution depends on the agreement you have with IBM.

Which other solutions did I evaluate?

When you look at IBM Db2 Database, you feel it is more of a vendor lock-in type of approach. IBM Db2 Database offers little performance difference or competitive advantage compared to Oracle SQL or other platforms.

The products recommended to my customers may vary and depend on certain agreements. There are a lot of products, like Oracle, Microsoft SQL, and many other cloud databases, making for a wide portfolio of products.

What other advice do I have?

IBM Db2 Database is a very standard and IBM-centric solution, so you need to be familiar with all the aspects of the product since it is not really an open product, meaning you can't run it on everything. IBM Db2 Database only runs on specific systems. I rate the overall product an eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller
PeerSpot user
Jørgen Espensen - PeerSpot reviewer
Project Manager at SPS
Real User
Secure solution but command line is outdated and could be better
Pros and Cons
  • "It's very secure."
  • "The command line part of this solution could be much better."

What is our primary use case?

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.

What is most valuable?

It's very secure.

What needs improvement?

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.

For how long have I used the solution?

I've been using this solution for two years.

What do I think about the scalability of the solution?

It's scalable.

How are customer service and support?

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

How was the initial setup?

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

What's my experience with pricing, setup cost, and licensing?

It's very expensive.

What other advice do I have?

I would rate this solution 6 out of 10.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Michael Raz - PeerSpot reviewer
Consultant at Discount Bank
Real User
Very good in terms of robustness, scalability, availability, and performance
Pros and Cons
  • "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."

What is our primary use case?

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.

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

I have been using this product for 40 years.

What do I think about the stability of the solution?

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.

What do I think about the scalability of the solution?

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

How are customer service and support?

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

How was the initial setup?

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.

What's my experience with pricing, setup cost, and licensing?

It is expensive.

What other advice do I have?

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

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
reviewer2053638 - PeerSpot reviewer
reviewer2053638Technical lead at HCL Technologies
Real User

It is a very useful relational database in banking backend system.

Solution Architect at a insurance company with 10,001+ employees
Real User
Offers a valuable Database Partitioning Feature and has good performance
Pros and Cons
  • "Very good for performance and scalability."
  • "There could be better integration with some cloud solutions."
  • "The GUI interface is not particularly friendly for those who do not have experience with the product."

What is our primary use case?

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.  

How has it helped my organization?

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

What is most valuable?

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.  

What needs improvement?

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.  

For how long have I used the solution?

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

What do I think about the scalability of the solution?

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

How are customer service and technical support?

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.  

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

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.  

How was the initial setup?

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.  

What about the implementation team?

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

Which other solutions did I evaluate?

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.

What other advice do I have?

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.  

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Database Engineer at Meezan Bank
Real User
Top 5
An affordable and stable solution to audit databases
Pros and Cons
  • "The solution helps secure the database."
  • "The product needs to improve its configuration and storage."

What is our primary use case?

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.

What is most valuable?

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

What needs improvement?

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

For how long have I used the solution?

I have been using the solution for six months.

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

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

How are customer service and support?

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

How would you rate customer service and support?

Neutral

How was the initial setup?

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.

What about the implementation team?

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.

What's my experience with pricing, setup cost, and licensing?

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

What other advice do I have?

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.

Disclosure: My company has a business relationship with this vendor other than being a customer:
PeerSpot user
reviewer1932312 - PeerSpot reviewer
Architect at a wellness & fitness company with 1-10 employees
Real User
Performs well, easy to manage, technical support is helpful, and responsive
Pros and Cons
  • "I believe that because the support is good, they jump in and assist us in determining the root cause."
  • "The pricing could be improved, it's expensive."

What is our primary use case?

The primary use case of the IBM Db2 Database is our trading platform.

We use store procedures and SQL. 

We have some tables with partitions, as well as some tables with a large amount of data. 

We use partitions, we use views, and we know who uses them.

What is most valuable?

We don't have any compatibility issues because we use all IBM products. We use every IBM product. That is why we use IBM's developer tool as well. We never encounter any product compatibility issues during development and deployment.

That is one of the good things that happened to us, in my opinion.

When we had server-related issues, such as a database outage, compatibility and support were good. I believe that because the support is good, they jump in and assist us in determining the root cause. 

The product is really reliable. 

We have seen very few instances of problems, overall IBM products are valuable.

The most valuable features are compatibility and support. 

What needs improvement?

I am currently moving away from that core application. I am not focusing on the solution. 

It is our trading application, and there are some reservations, about continuing to upgrade to the latest versions even though we are currently running on older versions. I believe the first step would be to upgrade it to the most recent versions and then see if any improvements are required while continuing to provide feedback on older versions.

The pricing could be improved, it's expensive.

For how long have I used the solution?

I am not working on it as closely these days, but our application began in 2001, and we have been using the IBM Db2 database since then.

What do I think about the stability of the solution?

IBM products are very nice and perform very well.

IBM Db2 Database is a stable product.

What do I think about the scalability of the solution?

We use a scalable WebSphere Application Server topology, but it's a monolithic application that can only be scaled vertically, not horizontally, because it's a monolithic single database, but those limitations exist. But there are times when I believe we are pleased with the product.

We have multiple production environments and various resources, as well as separate teams to manage the database and separate teams to manage the Application Server. I believe it began with a small team, but as time passed, I believe the number of environments and teams increased. Teams are popular now. I believe we have teams dedicated to each area.

I can say that there are approximately 100 developers, both offshore and onshore.

How are customer service and support?

We have support. In my opinion, they are prompt, we receive responses from IBM within two to three hours. 

There are some challenges. There may be one or two instances where it exceeds, but we are content with that.

The product is very reliable and stable, and we used to receive prompt responses from IBM on support. 

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

Previously, we were using the WebSphere Application Server. Those applications are in maintenance mode.

We also worked with the Application Developer,m which is the Rational Application Developer for WebSphere software. It is running on legacy Java version 8.

No one is currently using this software because everyone has upgraded to the latest version, but our application is still running with an older version. I don't believe anyone is currently using the older version of Java and the Application Developer that we are.

It's an older version of Java, and I don't believe any developmental improvements will be made to the tool as of now. Because we are not using the most recent version of the tool and the most recent version of the WebSphere Application Server, the feedback I could provide may be ineffective.


We are in the process of migrating to the AWS Cloud.

Our design approach is to convert our monolithic applications to microservices.

We have not used Hadoop, High-Availability Clustering, or Backup and Recovery, we only use the Application Server to host our applications.

How was the initial setup?

The monolithic application is hosted on-premises.

We installed the system in 2001 and have been using it ever since.

The maintenance and support staff is quite small. We have a dedicated database team, we can support multiple database products in addition to Db2.

What's my experience with pricing, setup cost, and licensing?

I am aware that IBM pricing is expensive in comparison to other products. 

However, I am not the person who dealt with pricing.

It is expensive when compared to other products.

What other advice do I have?

We are moving away from IBM products.

Everyone is now gravitating toward AWS and cloud computing. And this is a legacy monolithic platform. My advice will be ineffective. The legacy system was designed in the year 2000.

When we first launched our product, IBM hosted our client platform.

Our client insisted on using IBM products, but I believe we are now satisfied. However, the company where we started, has now been acquired by four different companies.

We are working on a different company that has Java-based products, department-based products, and many other products. It's obvious it's a trade. We will build a trading platform on which our clients and sponsors will trade.

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

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free IBM Db2 Database Report and get advice and tips from experienced pros sharing their opinions.
Updated: November 2024
Product Categories
Relational Databases Tools
Buyer's Guide
Download our free IBM Db2 Database Report and get advice and tips from experienced pros sharing their opinions.