We performed a comparison between IBM Db2 Database and SAP Adaptive Server Enterprise based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."I like that its true active-active. For example, if there are two instances within a cluster, we can take one of them down and there's no failover or switch over. There's no primary and secondary, it's true active-active. We can take one side down and we can upgrade that with new maintenance or a new version, obviously testing coexistence beforehand, without impacting the business."
"Reliable, robust with great features."
"The most valuable feature of the solution is its compatibility with IBM Power Systems."
"Db2 Database has given us good results since we have started to use it. We predominantly use IBM hardware, and this is one of the reasons why we started to use Db2 Database. Db2 Database has a very good HADR capability. High availability resilience is also good in this solution. It also has pureScale, which allows you to upgrade one node to get very good and high-level resilience. If you are using a database on five nodes, you can take one node down, upgrade that, and let that node up. You can then bring the second node down, upgrade that, and so on."
"The solution's initial setup is straightforward."
"It's very secure."
"The solution can scale."
"When you submit a ticket the response time is quick."
"Provides very good integration."
"SAP Adaptive Server Enterprise is a good transactional database."
"It's user-friendly, especially in the logistics field."
"They provide easy integration with other systems."
"The actual interface is good."
"I like that SAP ASE can match code and the database index to index data in the programming language. There are many other valuable features, such as the table buffer, tuning, and various control agents like dispatcher. SAP ASE can handle many different data types, including views, domains, data elements, structures, objects, and various table types that are most useful in the application. Its modularization technique is also handy."
"This is a wonderful database that is, in my opinion, underrated. Users are able to get the most out of my experience by taking advantage of its centralized environment."
"It would be ideal if the solution offered backup functionality. Many similar tools already do, which means Db2 is somewhat behind the curve in terms of what a customer might expect from it."
"The GUI interface is not particularly friendly for those who do not have experience with the product."
"GUI needs improvement."
"The only drawback that we see in Db2 Database is the crash recovery. When there is a crash and somebody has to do the recovery, Db2 Database first stops, and then it does any crash recovery. In Oracle Database, crash recovery happens within the database. The database is not shut down."
"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."
"IBM Db2 Database could improve with better security."
"They should develop its containerized version."
"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."
"The solution should improve view partitioning. The documentation is very confined and available only for users. Distributors also would like access to it."
"Because the solution is customized. we do occasionally face unique bugs. There are always some changes that need to be made here and there."
"SAP should refine its debugging method, and the process needs to be a little faster. It should use more Pragmas and fewer pseudocomments. I would like if SAP added more features based on advanced technologies, like artificial intelligence and voice control. The modularization and if-else techniques could also incorporate the latest technology to code and solve complex problems. The SAP Editor should be more elaborative, and it should allow many more types of statements for all uses."
"Cost-wise, SAP is still expensive compared to other available products."
"User interface could be more user friendly."
"I think that the solution needs to be positioned better within the market as it appears as though the Adaptive Server is being left out of the SAP scope."
"There could be some improvements in barcode scanning and RFID access."
More SAP Adaptive Server Enterprise Pricing and Cost Advice →
IBM Db2 Database is ranked 6th in Relational Databases Tools with 66 reviews while SAP Adaptive Server Enterprise is ranked 17th in Relational Databases Tools with 10 reviews. IBM Db2 Database is rated 8.2, while SAP Adaptive Server Enterprise is rated 8.6. The top reviewer of IBM Db2 Database writes "Very scalable with high availability and excellent technical support". On the other hand, the top reviewer of SAP Adaptive Server Enterprise writes " Loaded with a lot of features but the price is a drawback ". IBM Db2 Database is most compared with SQL Server, Oracle Database, SAP HANA, Teradata and CockroachDB, whereas SAP Adaptive Server Enterprise is most compared with SAP HANA, SQL Server, SAP SQL Anywhere, Oracle Database and SAP IQ. See our IBM Db2 Database vs. SAP Adaptive Server Enterprise report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.