• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • The System i Still Owns the SAP BI Data Mart Benchmark

    November 5, 2007 Timothy Prickett Morgan

    It’s lonely at the top, apparently. In recent posting in her blog on IBM’s developerWorks site, Elisabeth Stahl, who is the program manager of performance marketing for Systems and Technology Group, was lamenting that no one else in the IT industry had yet done a test on SAP‘s BI Data Mart benchmark test as the System i platform was getting another machine tested on it.

    “When I hike, I love to get to the top of the mountain,” Stahl writes. “Then it’s time to break out the peanut butter and jelly sandwiches and enjoy the view. But I do admit that I feel a bit lonely when there’s nobody else up there. No one to say hi to. No one to talk about where you are from. No one to ask to take your picture.”

    Stahl, who has been dealing with system performance at IBM for two decades, knows exactly what the problem is, but there is no hint of this in her blog. The problem is that IBM has climbed the wrong mountain. Everyone else is playing king of the hill over on the Sales Distribution benchmark test, which has been the core SAP ERP benchmark for many, many years and which happens to be the test IBM ran on its OS/400 and AIX servers alike until Big Blue apparently got nervous about direct comparisons being made. Particularly by smart-aleks who edit newsletters and add pricing information for the SAP configurations tested on the SD test. IBM stopped running the SD test on the eServer i5 machines back in 2004.

    The funny bit, to me at least, is that the i5/OS and OS/400 platform is generally used as an ERP system and only secondarily as a BI box. As is the case with many midrange customers, i5/OS and OS/400 shops tend to put data warehouses and data marts onto Windows-based servers running Microsoft‘s SQL Server, which has basic OLAP functionality built in. There are also pre-packaged and native data marts available from New Generation Software, jut to give one example. So the BI Data Mart benchmark seems to be exactly the wrong test to run on i5/OS if you want to show its ERP muscle. And by doing so, IBM looks like it doesn’t understand its own customers and, even worse, looks like it has something to hide.

    Having said all that, any benchmark test result on any AS/400, iSeries, or System i machine is to be welcomed. I don’t want IBM to take away tests, but run more.

    As I previously reported, IBM talked about the performance of the new 9406-MMA System i 570 using the Power6 processor back at the July launch of the machine. Earlier this year, when IBM dumped the SAP Business Warehouse (BW) benchmark it has been using instead of the SD test since late 2004 for the BI-DM test, the company tested two Power5+ machines. In January, IBM tested a four-core i5 570 with 2.2 GHz Power5+ chips and 64 GB of main memory; this machine could process 51,875 query navigation steps per hour. In April, IBM doubled up the cores and memory in this machine, and more than doubled performance to 114,687 query navigation steps per hour. Both of these machines ran i5/OS V5R4 and SAP’s NetWeaver middleware. (Not WebSphere.) With the launch of the Power6-based System i 570 in July, IBM ran the BI-D test on a four-core machine using the 4.7 GHz processors, configured with 64 GB of memory. This machine was able to handle 92,716 query navigation steps per hour, a 79 percent increase over the four-core Power5+ machine tested earlier this year. (Why IBM didn’t put the pedal to the metal and run it on a 16-core box is beyond me, but maybe there are scalability issues that crop up in SMP inside V5R4M5. This is not the first time that IBM or other server vendors have done this.)

    In September, IBM ran the BI-DM test on a System i 520 with two 1.9 GHz Power5+ cores activated. The machine was rigged with 16 GB of main memory, and ran i5/OS V5R4, DB2/400, and NetWeaver 7.0, and with 97 percent of the CPU capacity utilized, this 520 box was able to handle 26,224 query navigation steps per hour. This is right about where you’d expect such a machine to fall compared to the other 570 machines tested.

    RELATED STORIES

    Power6-Based System i Performance: Your Mileage Will Vary

    The i5 Shows Linear Scalability on SAP Benchmark

    The i5 Tests Well on SAP Data Warehousing Benchmarks

    The i5 Tops SAP Warehousing Benchmark

    IBM Tests eServer i5s on SAP Benchmark



                         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: Tags: mtfh_rc, Volume 16, Number 43 -- November 5, 2007

    Sponsored by
    Precisely

    Participate in Precisely’s 2021 IBM i Security Survey

    Every year, Precisely asks IT pros responsible for IBM i security about their top challenges, strategies, technologies and best practices. These annual survey results provide a revealing look at the current state of IBM i security through the eyes of your peers.

    Click here to contribute your perspectives to this year’s survey.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Admin Alert: Limiting System i User Sign-ons the Smart Way XAware Takes the Open Source Plunge

    Leave a Reply Cancel reply

TFH Volume: 16 Issue: 43

This Issue Sponsored By

    Table of Contents

    • IBM to Recycle Silicon Wafers for Solar Cells
    • The System i Still Owns the SAP BI Data Mart Benchmark
    • IBM Brags About Its Power6 Server Shipments
    • IBM to Pump $1.5 Billion into Security Products, Services
    • Neuwing, IBM to Quantify and Monetize IT Energy Savings
    • IT Vendor Market Cap Follies
    • Ask TPM: Enticing Users to Upgrade Their i5/OS Hardware
    • BluePhoenix Rides Legacy Modernization to Another Successful Quarter
    • Project ECLipz Surfaces, But Not the Way You Think
    • The Latest i5/OS V5R4 PTFs: What Is Going On?

    Content archive

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

    Recent Posts

    • 2021 Predictions for IBM i: Part Two
    • Zend Server for IBM i Now 64-Bit, Available Via RPM
    • New IBM i Logo, Publication
    • Four Hundred Monitor, January 20
    • IBM i PTF Guide, Volume 23, Number 3
    • IBM i Software And Power Systems Upgrades Keep Rolling Forward
    • Preparing For What’s Next In A Thoughtful, Structured Way
    • Guru: Fall Brings New RPG Features, Part 3
    • ARCAD Plugs IBM i DevOps Suite Into Microsoft Azure
    • Park Place Buys Curvature To Become Maintenance Goliath

    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 © 2021 IT Jungle

    loading Cancel
    Post was not sent - check your email addresses!
    Email check failed, please try again
    Sorry, your blog cannot share posts by email.