My main use of Db2 is as an additional data source for integration or a source for integration adapters.
Software architect at bergen
Simple, stable, and reliable solution with excellent technical support
Pros and Cons
- "The most valuable features are the simplicity of the database and the access to Db2 and Db2 information."
- "IBM's products tend to be quite costly, especially given the availability of free, open-source alternatives."
What is our primary use case?
What is most valuable?
The most valuable features are the simplicity of the database and the access to Db2 and Db2 information.
For how long have I used the solution?
I've been working with this solution for twenty years.
What do I think about the stability of the solution?
Db2 is stable and reliable.
Buyer's Guide
IBM Db2 Database
October 2024
Learn what your peers think about IBM Db2 Database. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,763 professionals have used our research since 2012.
How are customer service and support?
IBM's technical support is good, it's an excellent reason to purchase Db2.
How was the initial setup?
The initial setup was quick and easy.
What's my experience with pricing, setup cost, and licensing?
IBM's products tend to be quite costly, especially given the availability of free, open-source alternatives.
What other advice do I have?
I would rate Db2 eight out of ten.
Which deployment model are you using for this solution?
Private Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Business Intelligence Consultant at a university with 10,001+ employees
Good technical support and a stable platform for our Data Lake
Pros and Cons
- "The most valuable feature of this solution is the integration with other IBM products."
- "I would like to see better support for advanced analytics."
What is our primary use case?
Our primary use case for this solution was as a data lake, in an on-premises deployment.
We stopped using this solution almost a year ago.
What is most valuable?
The most valuable feature of this solution is the integration with other IBM products.
This solution has good storage capabilities.
What needs improvement?
I would like to see better support for advanced analytics.
For how long have I used the solution?
I had been using this solution for nine years.
What do I think about the stability of the solution?
This is definitely a stable solution. I would rate the stability a nine out of ten.
What do I think about the scalability of the solution?
I would say this solution is scalable, in terms of memory.
There are approximately one thousand users.
How are customer service and technical support?
Technical support for this solution is good.
Which solution did I use previously and why did I switch?
Prior to using this solution I was using Oracle, although it was not for exactly the same purpose.
How was the initial setup?
The initial setup of this solution is straightforward.
There are between ten and fifteen staff that maintain this solution.
What's my experience with pricing, setup cost, and licensing?
Licensing fees are on a yearly basis.
Which other solutions did I evaluate?
We have changed to a new platform, so I am no longer using IBM DB2.
What other advice do I have?
If somebody is looking for stability then I recommend this platform, although it depends on whether they want a Data Lake or are looking for analytics.
I would rate this solution a nine out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
Buyer's Guide
IBM Db2 Database
October 2024
Learn what your peers think about IBM Db2 Database. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,763 professionals have used our research since 2012.
Sr. System Architect at a tech services company with 1,001-5,000 employees
IBM is the king of servers (Infrastructure) , IBM DB2 the king of Database Servers
What is most valuable?
I have benefitted from many features including:
- Product is built on RDBMS principles and principles of Normalization. Have benefitted by the normalization capabilities built into the product;
- SQL Query capabilities, Tools such as SPUFI, QMF, BMC Catalog Manager,DB2 File-Aid make it easy to query the data,
- Programming capabilities (such as host variables, cursors ) provided by languages such as COBOL to invoke DB2 DML statements to query, modify the DB2 Tables;
- Ability of DB2 rows to be presented to CICS screens, Batch Jobs, Web Programs;
- Entire 4 GL Tools such as Cool:Gen, Advantage Gen Encyclopedias implemented as DB2 tables;
- Entire Advantage Gen / Cool:Gen / IEF components viz. programs, program components are modeled as DB2 tables. Thousands of programs, program components built, accessed by thousands of programmers are stored as DB2 table entries. These are easily queried, extracted, modified, loaded to other regions by customized programs. Entire models can be created by copying DB2 tables. These are done reliably, consistently, and scalability is provided. This speaks about the power and capability of DB2;
- Entire Cool:Gen components / DB2 entries can be queried by IBM Websphere with ODBC connection and the results can be web enabled. This means DB2 is programmable for the web as well;
- DB2 entries can be extracted, modified and loaded to other regions and datawarehouses. IBM DB2 Unload, Load Utilities, products such as IBM Optim, IBM Websphere Datastage, IBM Websphere all enhance the capabilities and features of IBM DB2.
How has it helped my organization?
The product has improved our organization in many ways. IBM DB2 has been used in many client projects. These projects are used for a number of years (more than 20-30). Entire Enterprise Applications in the IBM Mainframes have been built with the capability of IBM DB2. Many applications have thousands of DB2 tables and millions of rows. These are accessed for Batch Programming via COBOL, for online / CICS programming via COBOL. Some entries can be accessed by IBM Websphere for Web Programming. This has provided the organization the ability to implement millions of business functions through online / batch / web programs.
What needs improvement?
It should be easier for web enablement. It is currently easy, but the more web products use the tool, the better it is.
For how long have I used the solution?
I have been using IBM DB2 (Mainframe Version) for more than ten years.
What was my experience with deployment of the solution?
No. Occasional bind problems would occur, but were resolved through proper configuration management tools, such as ENDEAVOR or CHANGEMAN.
What do I think about the stability of the solution?
No
What do I think about the scalability of the solution?
No
How are customer service and technical support?
Customer Service: We didn't have to contact customer service. Our DBAs would contact customer service if and when needed. However, the near-100% availability of DB2 and Advantage Gen Encyclopedia that was housed in IBM DB2 speaks of the reliability of the product and its customer service.Technical Support: Very Good. When I contacted my DBAs, they were able to resolve the binding errors, authorizations etc. quickly and efficiently.
Which solution did I use previously and why did I switch?
We switched from VSAM to DB2. DB2 is much more sophisticated and advanced than VSAM and provides a number of features which make it easier to access the data and present it, as well as use it.
How was the initial setup?
It was straightforward and easy. Many of the utilities provided by the vendor functioned very well. We were able to upgrade the Gen Encyclopedia easily.
What about the implementation team?
Through an in-house expertise.
What was our ROI?
It is enormous. We were able to implement many business projects on an ongoing basis without any issues.
What's my experience with pricing, setup cost, and licensing?
I was not involved in the pricing negotiations. I would say it was cost effective based on the number of successful projects.
Which other solutions did I evaluate?
No, IBM DB2 has been used by the clients for a number of years; in some cases more than 20-30 years.
What other advice do I have?
I would say that IBM DB2 is one of the topmost Database products. It has very high availability and scalability just like the other products from IBM, such as IBM Websphere server, IBM Websphere MQ Server, and IBM Websphere Datastage. IBM is the king of servers and infrastructure. You will do well going with IBM products such as DB2, Websphere. I would say that these are very stable and scalable and available products and provide much needed reliability for businesses.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Enterprise Solutions Architect at a computer software company with 201-500 employees
Stability, scalability and security with high performance.
What is our primary use case?
Internet & Mobile banking database
E-Payroll & E-Statement solutions
Website database
What is most valuable?
A) The command set is almost the same in Windows and AIX operating systems, which greatly minimize the administration efforts to manage DB2 in both environments. Needless to say that working with the banking sector (which is my default playground) I need the ability to deal with many operating systems.
B) The ability to understand and interpret PL/SQL queries, with ease switching from Oracle to DB2.
C) Stability, scalability and security with high performance.
How has it helped my organization?
Our software products have to be PCI-DSS compliant, so encryption of customers' credit card numbers is a must-have feature. Using DB2 AWSE v11 enables us to do out-of-the-box encryption with ease.
What needs improvement?
Backing up databases from Windows and restoring them on AIX and vise-versa.
Support for migrating DB2 v9.7 to 11 in a single process with no intermediate versions jumping
For how long have I used the solution?
More than five years.
What do I think about the stability of the solution?
No.
What do I think about the scalability of the solution?
No.
How are customer service and technical support?
IBM Knowledge Base is more than enough, I never asked them for support.
Which solution did I use previously and why did I switch?
I used Oracle DB and am still using it with some of my customers, but Oracle administration is a nightmare compared to DB2.
How was the initial setup?
The initial setup is straightforward, but securing your environment is a bit more complex.
What's my experience with pricing, setup cost, and licensing?
Use DB2 Express for your development environment, but consider using Workgroup Server Edition if you need to federate two databases together or need to server a huge amount of data. If you plan to be PCI-DSS compliant, use AWSE.
Which other solutions did I evaluate?
MS SQL Server 2014 and Oracle 12g.
What other advice do I have?
I recommend it to medium-to-large enterprise applications
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Lead Code Wisperer at a tech vendor
If you want horizontal scaling and reliability, DB2 for i is absolutely the way to go.
What is most valuable?
Scalability, the IBM i Logical views, journaling.
How has it helped my organization?
DB2 was always there, so I can't answer that. Know that I've used MySQL, PostgreSQL, and SQL Server extensively as well, and always missed DB2 for i.
What needs improvement?
Not sure.
For how long have I used the solution?
Since before it was called DB2, back on the System/38, so twenty years or so.
What do I think about the stability of the solution?
Hah! You kidding. DB2 for i? No. Never.
What do I think about the scalability of the solution?
Hah! You kidding. DB2 for i? No. Never. Would you like a description of the IBM i Single-level Store. Add a new drive and you are good to go.
How are customer service and technical support?
Good to excellent. It can get expensive but third party is very good.
Which solution did I use previously and why did I switch?
I did not use a different solution prior to IBM DB2.
How was the initial setup?
It was integrated with the IBM i OS.
What's my experience with pricing, setup cost, and licensing?
If you want horizontal scaling and reliability, DB2 for i is absolutely the way to go.
Which other solutions did I evaluate?
No, I did not evaluate other options before choosing this product.
What other advice do I have?
If you don't know IBM i OS, just use it for DB2 for i, and scalability, reliability, and security. Then consider using partitions for Linux for your business logic.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data Practice Lead at Hyve Technology Consulting
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
Senior System Analyst at Thakral
Self-maintaining and self-monitoring data management
Pros and Cons
- "Db2's best features are that it's self-maintaining and self-monitoring, which means I have to view and monitor the database far less often."
- "There are some issues with Db2's database file system not being readable. The storage could also be increased, and the monitoring could be improved."
What is our primary use case?
Db2 is mainly used for Core Banking Systems, credit card systems, and production systems for CBS collecting.
What is most valuable?
Db2's best features are that it's self-maintaining and self-monitoring, which means I have to view and monitor the database far less often.
What needs improvement?
There are some issues with Db2's database file system not being readable. The storage could also be increased, and the monitoring could be improved.
For how long have I used the solution?
I've been using IMB Db2 Database for nine years.
What do I think about the stability of the solution?
There were a few hiccups directly after installation, but Db2 has been very stable since then.
What do I think about the scalability of the solution?
Db2's scalability is very good, especially when used in the IBM power system.
How was the initial setup?
The initial setup was very straightforward.
What other advice do I have?
I would rate Db2 Database 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: Partner
Managing Director, North America at Business Consultants, Inc.
Very stable and scalable but the pricing is not transparent
Pros and Cons
- "The solution is very stable, in both hardware and database."
- "End-to-end encryption specifically is something the solution needs to have in the next release."
What is our primary use case?
We primarily use the solution for different banking systems.
What is most valuable?
The solution is very stable, in both hardware and database.
What needs improvement?
IBM just came out with new hardware in September, so they are getting ready for the cloud. If they can push through with all those features they're talking about, I think they have a good product lined up. Right now, the solution needs to have end-to-end encryption, to be cloud-ready, to have native support for Linux, and built-in data scientist workbenches. These are promised to us in the new release, and I hope that happens.
End-to-end encryption specifically is something the solution needs to have in the next release.
For how long have I used the solution?
I've been using the solution since 1998.
What do I think about the stability of the solution?
The solution is very stable.
What do I think about the scalability of the solution?
The solution is very scalable. We don't plan on increasing usage any time soon, however.
How are customer service and technical support?
Technical support is good. they are pretty responsive.
Which solution did I use previously and why did I switch?
We also use SAP HANA. These are two different applications, however, and they have different use cases. HANA runs on memory. Db2 is a much more mature, older technology with its own platform. HANA is not that new but it's not that old either. It's much faster for sure. The difference is one is in-memory computing, while the other is a traditional database on hardware on the IBM platform.
How was the initial setup?
The setup is quite complex. The solution and the hardware build are two different events. The deployment itself doesn't take more than two weeks, followed by the setup which can take, depending on the organization and its processes, a few months to a year. It varies from client to client.
What about the implementation team?
IBM assisted us with the deployment.
They're quite good at what they do. They never deliver on time or on budget. However, they know what they're doing, as it's their product.
What's my experience with pricing, setup cost, and licensing?
The solution is pretty expensive and IBM isn't very transparent in their pricing plans. You need to be aware of what your company specifically needs before purchasing anything.
What other advice do I have?
I'd rate the solution a six out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free IBM Db2 Database Report and get advice and tips from experienced pros
sharing their opinions.
Updated: October 2024
Product Categories
Relational Databases ToolsPopular Comparisons
SQL Server
Oracle Database
Teradata
MariaDB
SAP HANA
Vertica
Amazon Aurora
CockroachDB
SingleStore
IBM Netezza Performance Server
IBM Informix
Oracle Database In-Memory
YugabyteDB
Buyer's Guide
Download our free IBM Db2 Database Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- When evaluating Relational Databases, what aspect do you think is the most important to look for?
- Do general purpose or OLTP Oracle databases really perform better on SPARC based servers?
- Microsoft sql2017 VS SAP Hana
- What is the best database choice for a long term plan?
- SQL Server 2005 vs. InfoBright - what are the pros and cons of these solutions?
- How does NuoDB compare to MySQL and SQL Server?
- Which RDBMS tool do you prefer and why?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Why is Relational Databases Tools important for companies?