What users are saying about
83 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
294 Ratings
83 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

SAP HANA

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
294 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100

Likelihood to Recommend

DB2

DB2 is suitable for any use. The main one is certainly the creation of an online database that can be queried online through TP queries and through batch reports. It is necessary to take care of the database maintenance to allow maximum performance, for this, there are the utilities that help the system operators to do it.
Anonymous | TrustRadius Reviewer

SAP HANA

HANA has incredible query processing speeds. When compared with Sybase ASE for large dataset queries, we saw 10,000 times performance improvement. And for the individual point queries, we found that it was on par with Sybase ASE and that is because all of the response time is the round trip latency from the client initiating the query to the database and back. But for those large set processing requests that take a long time on Sybase, they ran 10,000 times faster on HANA. HANA is expensive so it should be used where in-memory transaction speeds are required and there are large volumes of data to be processed.
Gene Baker | TrustRadius Reviewer

Pros

DB2

  • DB2 maintains itself very well. The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs.
  • Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery ) models gives you a range of options for maintaining a very high uptime ratio. Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click.
  • Task Scheduler ( DB2 9.7 and earlier ) allows for jobs to be run within other jobs, and exit and error codes can define what other jobs are run. This allows for ease of maintenance without third party softwares.
  • Tablespace usage and automatic storage help keep your data segmented while at rest, making partitioning easier.
  • Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio ( DB2 10.x+) makes administration a breeze.
J.R. Bullington | TrustRadius Reviewer

SAP HANA

  • HANA has allowed us to convert our BW reports and provide users with real time report data. Prior to moving to HANA, the reporting was based on prior day activities.
  • Queries involving large amount of financial data are able to be run much quicker with HANA than prior to implementation.
Renee Ferree | TrustRadius Reviewer

Cons

DB2

  • IBM is really behind in delivering developer tools. They pride themselves on Data Studio, but it is just frustrating.
  • Marketing. Horrible to do a Google search and get returns for a COMPLETELY different product, for z/os. Why they share the same name is beyond me. Better marketing would also increase the user base and help the product mature.
  • Slower than the competition to roll out next-generation features.
Anonymous | TrustRadius Reviewer

SAP HANA

  • Personally I believe the UI could be much more compact and I see improvement areas.
  • Mobile application and desktop are very different.
  • Sometimes you need type-in help on mouse hover for faster input and selection.
  • Now HANA is going cloud where data and security becomes a concern for larger companies. We want to see a benchmark company in manufacturing domain with such a large retail presence. I see there are areas for improvement in that.
Saurabh Sharan  PMP® | TrustRadius Reviewer

Likelihood to Renew

DB2

DB2 8.0
Based on 2 answers
Because it is required to support our business unit
Anonymous | TrustRadius Reviewer

SAP HANA

SAP HANA 4.5
Based on 6 answers
At this moment we are not focusing on SAP, however would love to in the future. This is primarily because of our limited ability to generate more revenue to fund for SAP partnerships and products. Our initial tryst with SAP Partneredge open ecosystem didn't go as planned and we have shelved that for now. Hope we can revive in the future
Ganapathy Sivakumar | TrustRadius Reviewer

Usability

DB2

DB2 5.0
Based on 1 answer
You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.
J.R. Bullington | TrustRadius Reviewer

SAP HANA

SAP HANA 7.6
Based on 3 answers
It needs more work.
Shoaib Ansari | TrustRadius Reviewer

Reliability and Availability

DB2

DB2 9.9
Based on 10 answers
DB2 for i is extremely stable. I've experienced system slowdowns and performance issues on badly configured systems or badly configured system accessing the DB but that's it, never had a problem caused purely by the software. Support is also pretty good.
Roberto Etcheverry | TrustRadius Reviewer

SAP HANA

SAP HANA 3.6
Based on 1 answer
No answer on this topic is available.

Performance

DB2

DB2 9.6
Based on 10 answers
The performances are exceptional if you take care to maintain the database. It is a very powerful tool and at the same time very easy to use. In our installation, we expect a DB machine on the mainframe with access to the database through ODBC connectors directly from branch servers, with fabulous end users experience.
Anonymous | TrustRadius Reviewer

SAP HANA

SAP HANA 3.6
Based on 1 answer
No answer on this topic is available.

Support Rating

DB2

No score
No answers yet
No answers on this topic

SAP HANA

SAP HANA 8.2
Based on 202 answers
Overall, support is good. The wait times are low, and you get a quick response. The available agents have good knowledge about the problems at hand. If the issue is more complex, they connect you with the appropriate source to build the solution around the issue. Support team is well organized, they take a step-by-step approach to understand the issue at hand and build a solution around it. Overall, my organization is highly satisfied with the support.
Prathamesh Muzumdar | TrustRadius Reviewer

Alternatives Considered

DB2

DB2 is a similar product that is most respected. Oracle might be supported in a broader context, but DB2 is superior on every platform where the choice is there. Licensing is also a factor in which DB2 is much better, which might offset any cost differences. DB2 support is also much better at all tiers.
Anonymous | TrustRadius Reviewer

SAP HANA

We changed PECTRA for SAP, since we were having many problems with the loss of information in the database and unexpected catalog changes. In addition to that, it was very cumbersome to perform data analysis. We had many problems with a lack of materials or that the necessary did not enter because of it.
Christian Borsotti | TrustRadius Reviewer

Scalability

DB2

DB2 8.7
Based on 10 answers
It can grow as your company grows. It also plays well with Crystal Reports and other BI software once you create an ODBC connection for the DB. It can be managed with SQL management studio so no extra software is needed for that.
Josh Rice, MBA, ACSP | TrustRadius Reviewer

SAP HANA

SAP HANA 4.5
Based on 1 answer
Limitation of training deliverable by organization
Shoaib Ansari | TrustRadius Reviewer

Return on Investment

DB2

  • Positive - Very good performance as compared to other traditional DBs.
  • Positive - Transaction and query search are made easy from a DB level with good performance, also runs on top scape on AIX servers.
  • Negative - There is always room for improvement, such as Webex queries and the GUI base tool. Also the available support documentation should be improved.
Pradeep Bele | TrustRadius Reviewer

SAP HANA

  • Since implementing HANA we have been able to save several million dollars a year in operating room supplies ($9 million last fiscal year).
  • It has allowed us to improve our processes to save $1 million dollars in our Laboratory Services
  • We have used it as part of our month end close to save over 20 hours every month of manual reporting.
Jamie Oswald | TrustRadius Reviewer

Pricing Details

DB2

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

SAP HANA

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
Optional

Add comparison