We primarily use the platform to store query data. I work in a bank, where we store customer information on it.
External reviews
External reviews are not included in the AWS star rating for the product.
My short term experience with IBM DB2
DB2 The game changer
It's integration with other external systems is one of the key factor that changed the data processing. The backend system fo the legacy systems like mainframes and other payment processing system revolutionized the digital world.
My experience about IBM DB2
Best database ever
IMB great database for the past.
IBM's DB2 for z/OS provides a powerful database management system
Contributes to our organization's work efficiency with valuable querying feature
What is our primary use case?
How has it helped my organization?
The product has improved our organization by performing well for data storage and queries. It helps us retrieve information quickly.
What is most valuable?
The solution's querying feature is most valuable. It allows me to retrieve data quickly.
What needs improvement?
The solution's data retrieval speed could be improved, especially for heavy queries. Better optimization or indexing might also be involved.
For how long have I used the solution?
I have been working with IBM Db2 for about two years.
What do I think about the stability of the solution?
The product is mostly stable, even in a large organization like ours.
I rate the stability a nine out of ten.
What do I think about the scalability of the solution?
We manage around 15,000 to 20,000 platform users. I rate the scalability an eight out of ten.
How are customer service and support?
I do not interact directly with the technical support team.
Our internal support team handles any issues and communicates with the provider.
What was our ROI?
The solution has been good with strong performance, contributing to our organization's efficiency.
What other advice do I have?
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.
Which deployment model are you using for this solution?
Provides high availability and maintains active configuration across multiple servers
What is our primary use case?
We continued with our existing mainframe Db2 solution due to its high availability and the ability to maintain an active configuration across multiple servers or LPARs.
How has it helped my organization?
There are two versions of Db2. One is Db2 for z/OS. The other is Db2 LUW—LUW stands for Linux, Unix, and Windows. From an availability perspective, it's not on the same level as the z/OS version, which I consider superior. This is why major airlines, banks, insurance companies, and retailers worldwide rely on mainframes and Db2.
What needs improvement?
IBM's support isn't as strong as it used to be, especially when it comes to providing fixes. We have to keep track of defects more closely now. When a defect is identified, IBM takes it to their lab, creates an APAR, and provides us with a fix. We receive these fixes periodically and apply them to our Db2 code in a sandbox environment first, not directly into production. We test thoroughly before rolling it out to development and eventually to production.
Recently, we've encountered some issues with Db2, requiring us to be extra cautious to avoid outages. Unfortunately, we did experience an outage in February due to a code defect. We recently received a Red Alert from IBM, a critical warning in the mainframe world indicating a potential risk of data loss if not addressed.
How are customer service and support?
We have technical support from IBM, but we have to pay for it as part of our product licensing. If you're skeptical, look up IBM PH61633. It’s an example of a Red Alert, which warns of a defect that could potentially cause data loss and provides temporary actions until a fix is available.
It feels like we’re seeing these kinds of issues more frequently, and we have to be very cautious to avoid causing any outages. About two or three weeks ago, we recently experienced problems with some Microsoft tools and a third-party security fix. When the fix was applied, many Windows servers started crashing, leading to significant issues for airlines and banks worldwide.
There was also an issue involving CrowdStrike. We seem to encounter these problems more frequently, which has forced us to heighten our vigilance. I wonder if a better system could be developed to prevent these issues.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
When compared with Oracle RAC or Microsoft SQL, Db2 for z/OS offers the highest level of availability and the best SLA, especially if you have skilled technical people managing it. For banks or airlines needing 24/7/365 availability, Db2 for z/OS is the top recommendation. If your business can tolerate occasional outages, Oracle RAC or Microsoft SQL might be suitable alternatives. However, in our experience, Db2 for z/OS on the mainframe provides the most reliable high availability and active-active configuration.
How was the initial setup?
Mainframe environments require skilled, trained database engineers; many are available, particularly in the Indian subcontinent. My team has a mix of talent from around the world. While mainframe Db2 does demand a higher level of expertise, other environments might not require as much specialized skill, though some skills are still necessary.
IBM mainframe manuals are exceptionally well-documented and provide thorough explanations. In contrast, companies like Dell EMC or Microsoft sometimes fall short by not providing all the details needed. They might instruct you to run a process without explaining its potential impact, such as CPU usage or the best time to execute it.
I've worked with other suppliers and generally find that IBM's documentation for mainframes is very thorough and well-structured.
What's my experience with pricing, setup cost, and licensing?
In the past, mainframes were considered expensive because software licensing was based on the full capacity of the hardware. Nowadays, licensing is based on peak usage, typically less than the hardware's full capacity—often around 75%. This change reduces costs. Additionally, IBM mainframe developers have introduced features like speciality processors that handle specific tasks, offload work from the main CPU, and reduce costs further.
For example, if you have special CPUs managing some of the workload, peak usage might drop from 75% to around 60%, making the system more cost-effective.
Mainframe hardware generally has a longer lifespan than other servers, such as HP Gen 10 or Gen 11 servers, which typically have two to three years. Mainframes are built to last much longer.
What other advice do I have?
You don't want to check in for your vacation flight and find that the airline's system is down, causing delays at the airport. That would be a nightmare. Or imagine being unable to access your money because the bank's system is down. These kinds of issues can cause significant problems and lead to a lot of internal headaches for the company providing the services.
As part of your licensing with IBM, you get access to their case system, which lets you raise incidents related to software or hardware. This system is helpful for problem determination and quickly identifying issues. You need to keep things up to date, but you also want to avoid potential problems. If you wait too long to update, you're more susceptible to security breaches, and someone could potentially hack your system.
If iOS is publishing fixes, people out there examine them to find potential exploits. The same happens with Microsoft—people review their fix lists and look for opportunities to exploit vulnerabilities. IBM doesn't publish its security fixes openly. You need special permissions to access them; they're not generally available to anyone except those with specific access to the security sites.
Overall, I rate the solution a nine out of ten.
Has an easy setup process, but the cloud integration capabilities need improvement
What is our primary use case?
We use the product for managing large volumes of data, particularly in mainframe environments. It supports interoperability with other IBM systems and products.
What needs improvement?
They could enhance the product's cloud integration and general-purpose database capabilities to better compete with solutions like Oracle and Microsoft SQL Server.
For how long have I used the solution?
Our organization has been using IBM Db2 Database for 20 years.
What do I think about the stability of the solution?
I rate the product stability an eight or nine.
What do I think about the scalability of the solution?
I would rate Db2’s scalability around a six or seven. While it is adequate, other solutions like Oracle offer higher scalability.
How are customer service and support?
While there can be occasional delays in response time, the support team is knowledgeable.
How would you rate customer service and support?
Neutral
Which solution did I use previously and why did I switch?
We are switching from Db2 as part of a broader strategy to consolidate onto fewer platforms. Oracle is being favored for its widespread industry use and better cloud compatibility.
How was the initial setup?
The initial setup was easy due to IBM’s comprehensive installation manuals.
I rate the process an eight out of ten.
What's my experience with pricing, setup cost, and licensing?
I rate the product pricing a nine out of ten.
What other advice do I have?
I rate IBM Db2 Database a seven out of ten.
A database solution for core banking with competitive pricing
What is our primary use case?
IBM Db2 is a database for our core banking. We extract data from Db2 and put it in the data warehouse.
How has it helped my organization?
The main database platform is for core banking. It covers vulnerabilities.
What is most valuable?
The structure is straightforward, consisting of the test file and the logical and physical files. You have one physical file and many logical files related to it.
Banks use it which indicates that the security and compliance features are quite good.
What needs improvement?
The data table names are very short which is not user friendly compared to the Oracle SQL server. It should have longer column and table names.
For how long have I used the solution?
I have been using IBM Db2 Database for six years.
What do I think about the stability of the solution?
I rate the solution’s stability an eight out of ten.
What do I think about the scalability of the solution?
The solution is scalable depending on the IBM hardware you're using. IBM has also operation for Unix hardware. 1,000 users are using this solution.
Which solution did I use previously and why did I switch?
Oracle is very good product compared to Db2. We have used Postgre too.
How was the initial setup?
Deployment is vert fast. It takes eight hours to complete. It depends on what path you're doing. IBM provides training.
What's my experience with pricing, setup cost, and licensing?
The product has a competitive pricing.
What other advice do I have?
The solution depends on the use case. It is reliable and scalable.
Overall, I rate the solution an eight out of ten.