I'm helping customers migrate from Oracle to Db2. I am also assisting with business intelligence using Db2 Database.
External reviews
672 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Reliable database platform with impeccable support.
What do you like best about the product?
Extremely reliable DBMS with quality support.
It works with great encryption and decryption features.
Easy scalability.
Great connection between Cobol and db2
Queries and transactions in milliseconds.
It works with great encryption and decryption features.
Easy scalability.
Great connection between Cobol and db2
Queries and transactions in milliseconds.
What do you dislike about the product?
Some query syntaxes are different, but in a short time, it's easy to learn.
Licensing can be an issue due to the high value of the premium version.
Licensing can be an issue due to the high value of the premium version.
What problems is the product solving and how is that benefiting you?
Inventory, ingest and question open information designs utilizing a solitary stage that upholds tight joining with your information lake over cloud object capacity. While implementing of the data over cloud for analytics the queries, the implementation of data analytics over cloud is much simpler and efficient here. Provides a stage that limited grating for clients by being exceptionally viable with existing SQL code, and simple to incorporate with SAP applications.
Dashing DB2
What do you like best about the product?
I am the certified database DB2 application developer. I am working in DB2 database at production side daily .
I am stunned with the vloume of data it handles and works seemslessly with webservices with different systems in real time basis.
As datastudio comes handy, there is no downfall at all now for DB2. Earlier you need to know mainframe a bit to access, but now its not the case
I am stunned with the vloume of data it handles and works seemslessly with webservices with different systems in real time basis.
As datastudio comes handy, there is no downfall at all now for DB2. Earlier you need to know mainframe a bit to access, but now its not the case
What do you dislike about the product?
none, I do not think of any. It now still embeds XML in a column. Its going strong.
What problems is the product solving and how is that benefiting you?
In a production tickets world, I connect,verify how the user sees the data and what is stored in DB2. In large scale, it helps me to isolate the problematic data easily.
DB2: the real scalable Database
What do you like best about the product?
The performance: no other database can guarantee the same performance
What do you dislike about the product?
The complexity of the management, the expensive maintenance
What problems is the product solving and how is that benefiting you?
Performance
Easy installation and configuration
What do you like best about the product?
Simple installation on Openshift via Operator
What do you dislike about the product?
I have nothing to complain about, I had no problems with installation and maintenance.
What problems is the product solving and how is that benefiting you?
Store data for the IBM CloudPak for Data product
A highly scalable solution with unique features that enable efficient management of data
What is our primary use case?
How has it helped my organization?
One of the benefits of the solution is efficiency. One of our biggest clients is a bank based out of Brazil. As their data grew, fetching data became slow, and they did not have a good banking experience. By moving to Db2, they get better efficiency in managing and accessing the data. They have a good experience with the application.
What is most valuable?
IBM DB2 pureScale Feature is valuable. It is used for scalability. Customers with huge growth potential would really benefit from having a database that enables them to scale their business without the fear of having a redundant database.
What needs improvement?
The product’s user interface is not easy to use. I did one implementation of pureScale at Welsh Bank. It was very, very complex to deploy the feature. It took us more than six weeks. It has specialized hardware for you to use, and specialized switches are required to have that functionality in place. Over the years, it has improved, but nine years ago, it was a nightmare. The product should make the implementation of pureScale easy. It could give a seamless experience.
For how long have I used the solution?
I have been using the solution for about ten years.
What do I think about the stability of the solution?
The solution is quite stable. It's not a simple database, but it comes with the territory. The product has existed for a long time, since the late 80s. The team has experience in databases, and maintaining them is a breeze for them. The tool is a futuristic database. I witnessed teams in IBM do time travel queries in 2012. The tool’s version 10 had already implemented time travel queries. Years later, we saw the features in other databases.
The product is years ahead of technology and architecture. It helps software developers have very good features that are years ahead. Now people are really focusing on the cloud. I'm sure they have features that help software engineers or developers work or code with the cloud in mind.
Which solution did I use previously and why did I switch?
I've used SQL Server for a very long time. Microsoft SQL Server is quite easy to use from a beginner’s perspective. Its user interface is very intuitive and quite easy to use.
How was the initial setup?
The ease of setup depends on the instances. In some instances, it's quite complex. Compared to SQL Server, MySQL, and PostgreSQL, Db2 is not easy to deploy. It is quite complex compared to other databases. However, the complexity comes with the territory. Companies that have complex requirements benefit from it.
What about the implementation team?
Depending on the features we are deploying, deployment would take a couple of days to months. IBM DB2 pureScale Feature is quite complex. Deploying it is not easy unless you have somebody who's very, very experienced. While deploying pureScale, we need staff to help with the deployment. I was working with IBM at the time, so I could ask my colleagues, who were quite experienced, to help me. They were from the worldwide team in Toronto. They're quite happy to help.
From a customer’s perspective, we would need a very experienced business partner if we get support from a business partner to assist with the deployment. If we have money, we can contact IBM. IBM is quite expensive. IBM is always ready to assist, and the team is quite experienced. As long as you have knowledgeable database administrators who have the experience and are ready to learn, it's quite easy to maintain daily. For upgrades, we need someone who's very, very experienced to do an actual migration. SQL Server is quite easy to migrate. For Db2, we need experienced people to help out with the migration.
What's my experience with pricing, setup cost, and licensing?
Compared to other databases, Db2 is relatively cheaper. Oracle is very expensive. Sometimes, it is ten times more expensive than what we pay for Db2. However, Db2 has more features as compared to Oracle. When we buy Db2, we buy all the features. When we buy Oracle, we just buy a few features. For example, for row access security, you have a different product that you need to pay to unlock that functionality. Things like storage are available on Db2 straight out of the box. You have to pay Oracle to unlock new features.
What other advice do I have?
I work with huge enterprise customers such as banks who, at the moment, are not quite ready to take the data to the cloud. Db2’s SQL PL understands up to 85% of Oracle’s thought procedures. Many developers are unwilling to invest a lot of money and resources to migrate Oracle databases with huge thought procedures to Db2. However, with Db2, we don't have to migrate all the thought procedures or triggers. DB2 understands most of that language out of the box without changing anything. So it's quite easy to move from Oracle to Db2. This is what I would advise any enterprise customer that is ready to move to Db2. It’s very, very cheap in the long term compared to Oracle or any other database. Overall, I rate the solution a nine and a half out of ten.
A highly scalable database system for production-grade workloads
What do you like best about the product?
IBM DB2 provides a suite of tools that can be used to manage data efficiently. It has out-of-the-box support for both relational and non-relational models. This makes it the go-to choice for all data-related operations as it has multi-cloud capabilities.
What do you dislike about the product?
There are a few things that can be improved. Firstly, the integration options are not readily available. The UI can be improved to assist the learning curve of new users.
What problems is the product solving and how is that benefiting you?
Our enterprise clients wanted a database solution that could scale at ease while being highly available. While there were several options out there, IBM DB2 had multi-cloud capabilities and made query execution seamless. The powerful performance clubbed with the reliability provided by IBM DB2 made this solution unwavering.
A balanced database for large scale data deployments
What do you like best about the product?
Ease of Installation as its UI is very convenient and flexible to use.
It has automatic scaling as per requirement and environment.
It has easy data loading option and drag and drop features of csv files.
High availability.
It has automatic scaling as per requirement and environment.
It has easy data loading option and drag and drop features of csv files.
High availability.
What do you dislike about the product?
Has fewer region options.
However it has less integration options.
Upgrades take a lot of time and a lengthy process.
Backup restoration is not handy with the running process.
However it has less integration options.
Upgrades take a lot of time and a lengthy process.
Backup restoration is not handy with the running process.
What problems is the product solving and how is that benefiting you?
It solves the scalability, performance, reliability and cloud deployment solutions. It provides a powerful platform for managing and analyzing their data effectively via hybrid cloud.
It's a good choice for critical applications which interface with ibm cloud
What do you like best about the product?
IBM Db2 is a good choice for businesses that need a reliable, scalable, and secure database for mission-critical applications. It is a mature product with a long uptime history and is used by companies of all sizes.
What do you dislike about the product?
Licensing can be expensive, Not as widely used as some other RDBMSs
What problems is the product solving and how is that benefiting you?
it's reliable, scalable, secure and performant
Db2 is well known for reliability and scalability give it a go...
What do you like best about the product?
Db2 is well known for reliability and scalability, and solid database solution for all your business needs including Data Lake, Operational Database, Data Warehouse, and Fast Data.
What do you dislike about the product?
There is quite a steep learning curve to using and deploying IBM Db2 so some investment in skills and training could be essential to maximise the product and deliver the correct solution.
What problems is the product solving and how is that benefiting you?
The product can give Improved data availability, extended processing capacity, configuration flexibility and higher transaction rates when compared to other similar database products.
A stable solution that needs to improve documentation and scale computing
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.
showing 61 - 70