• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • SAP HANA: Just a Sidecar to IBM i, For Now

    March 4, 2014 Alex Woodie

    It’s been about three years since SAP unveiled HANA to the world. And while the in-memory database platform currently only runs on X64 commodity hardware and not IBM‘s Power processor, SAP’s extensive IBM i customer base is starting to explore ways that HANA might fit into an SAP implementations running on Power Systems and IBM i.

    Ron Schmerbauch, IBM’s technical lead for SAP on IBM i implementation, recently wrote about the possible integration options between IBM i and HANA. Currently, there are only two ways that HANA and IBM i can play together, Schmerbauch says: HANA as an analytical sidecar to a production SAP IBM i environment and using IBM i as an application server for a HANA database.

    When using HANA as a sidecar, the HANA system takes over some of the reporting workload from DB2 for IBM i. This could be a good way to minimize the disruption to OLTP workloads that commonly occurs when the SAP ERP Central Component (ECC) overloads the production database with analytical SQL queries, he writes.

    The sidecar option involves sending read-only copies of transactions from DB2 for i to HANA. “As rows are changed in the IBM i database tables that are being shadowed to HANA, the changes are sent to the copies so the HANA DB is just slightly behind real-time,” Schmerbauch writes. “If and when the particular reporting function is run, that small set of queries will go against the HANA database, leaving the IBM i to continue running OLTP functions without disruption.”

    The second option is to use HANA as a database platform for certain SAP Business Warehouse (BW) or SAP Business Suite applications running on IBM i. The SAP applications still require a three-tier configuration with a separation between the database and the application server. But SAP customers could configure their systems to use HANA as the database server and IBM i as the application server.

    While it’s possible to do this, there isn’t a great rationale at this point, Schmerbauch says. For starters, it would require moving all the data out of DB2 for i and into HANA and learning the new HANA-centric database administration, save/restore, and HA/DR skills.

    And then there is the performance issue. Schmerbauch brings up the fact that no server vendors have ventured to run the SAP Sales and Distribution (SD) benchmark with HANA as the database layer. This, he says, “may be taken as a strong indicator that HANA’s OLTP performance is not competitive with row-based DB platforms” such as DB2.

    In other words, an SAP-on-IBM i shop would have to be slightly unhinged if they wanted to use HANA as the database layer for their SAP applications. That leaves HANA as an analytic and reporting sidecar to a production IBM i system.

    Schmerbauch brings up another alternative to even using HANA in the first place. (He is an IBM employee, after all, and doesn’t speak for SAP.) While HANA is good technology, big speedups can be had by simply loading up on memory and Flash/SSDs. IBM has also developed Encoded Vector Index (EVI) technology for DB2 for i, which enables faster columnar operations. However, SAP uses EVIs for building OLAP cubes in BW, so that advantage is already baked in. Then there’s DB2 BLU, but that’s currently an AIX-only offering that isn’t attractive to IBM i’ers.

    There could be a third way to use HANA and SAP apps running on IBM i: Running HANA directly on Power. Last year, SAP executives said that they were exploring this with IBM and that it might happen. However, there hasn’t been any word from either IBM or SAP in the last 14 months about that possibility.

    One could certainly make a case that the combination of HANA and Power could be a compelling alternative. One person who’s explored the possibility in considerable depth is Alfred Freudenberger, the head of sales for IBM Power Systems for SAP in North America. In his SAPonPower blog (which isn’t affiliated with his day job whatsoever), Freudenberger asks some compelling questions.

    “Are you ready to bet your business on x86?” Freudenberger writes in his blog. “Do Intel systems offer the scalability that your business requires and can those systems react fast enough to changing business conditions? Are x86 systems reliable enough? Are x86 systems secure enough?”

    What can SAP on IBM i users do about this? Freudenberger encourages them to let their SAP representatives know that “you are unwilling to take a chance on allowing your SAP Business Suite database systems to be placed on anything less than the most reliable, scalable, secure and flexible systems available, i.e. IBM Power Systems.”

    Business Suite already runs very well on Power Systems, and until SAP is willing to support this platform for HANA, “there is very little compelling reason for you to consider a move to HANA.”

    RELATED STORIES

    HANA on Power? It May Be in the Cards

    SAP Puts In-Memory Database At The Heart Of Its BusinessSuite ERP

    SAP Sends HANA to the Cloud

    SAP On IBM i: The Best Alternative?

    SAP Fleshes Out HANA’s Roadmap with Heavy Dose of Sybase

    SAP Talks Up HANA In-Memory Database at TechEd 2011

    SAP Unveils HANA for In-Memory BI

    SAP on the iSeries: No Longer the “Best Kept Secret”?



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Manta Technologies

    The Leader in IBM i Education!
    Need training on anything i?
    Manta is all you need.

    Spring Sale! Save 20% off any Manta Combination Package, including the complete IBM i Training Library. Now through April 30.

    130 courses and competency exams on:
    · IBM i operations
    · System Management and Security
    · IBM i Programming Tools
    · Programming in RPG, COBOL, CL, Java
    · Web Development
    · SQL, DB2, Query

    Product features:
    · Runs in every popular browser
    · Available 24/7/365
    · Free Student Reference Guides
    · Free Student Administration
    · Concurrent User License
    · Built-In IBM i Simulator

    You can download our 200-page catalog and take sample sessions at MantaTech.com.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    Maxava:  Don't wait for a disaster. Start planning today. DR Strategy Guide for IBM i FREE eBook.
    System i Developer:  Upgrade your skills at the RPG & DB2 Summit in Dallas, March 18-20.
    Northeast User Groups Conference:  24th Annual Conference, April 7 - 9, Framingham, MA

    More IT Jungle Resources:

    System i PTF Guide: Weekly PTF Updates
    IBM i Events Calendar: National Conferences, Local Events, and Webinars
    Breaking News: News Hot Off The Press
    TPM @ EnterpriseTech: High Performance Computing Industry News From ITJ EIC Timothy Prickett Morgan

    Watson Goin’ Mobile, Keeps On Movin’ DB2 For i Scalar Function Performance Considerations

    Leave a Reply Cancel reply

Volume 14, Number 5 -- March 4, 2014
THIS ISSUE SPONSORED BY:

SEQUEL Software
ProData Computer Services
BCD
Linoma Software
COMMON

Table of Contents

  • IBM Aims to Smooth DevOps with RTC Update
  • Zend Patches High-Risk Security Flaw in PHP
  • SAP HANA: Just a Sidecar to IBM i, For Now
  • m-Power Gets All Gussied Up with New Charts, Graphs
  • Alaska Telecom Ditches Tape for LaserVault UBD
  • Krengel Rejiggers Mailing Automation Lineup
  • Google’s New Login Is ‘Slick,’ But Will It Fly in the Enterprise?
  • RJS Bolsters Report-Delivery Tool
  • Halcyon Gives IBM i Shops an Edge in MQ Management
  • Infor Adds Industry-Specific Functionality to M3

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • LANSA Developing Business Intelligence Tool
  • Blazing The Trail For VTL In The Cloud
  • Data De-Dupe Gives VTL Customers More Options
  • Four Hundred Monitor, March 29
  • The Big Spending On IT Security Is Only Going To Get Bigger
  • IBM Tweaks Some Power Systems Prices Down, Others Up
  • Disaster Recovery: From OS/400 V5R3 To IBM i 7.4 In 36 Hours
  • The Disconnect In Modernization Planning And Execution
  • Superior Support: One Of The Reasons You Pay The Power Systems Premium
  • IBM i PTF Guide, Volume 25, Number 13

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2023 IT Jungle