• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Reader Feedback Regarding The Shadow Of Database Hype

    December 2, 2013 Timothy Prickett Morgan

    Hey, Dan:

    I must disagree with the quote that it was not until V7R1 that the AS/400 had “in-memory database.” We have been using the SETOBJACC command for many, many years to lock commonly used table files and work files into memory to improve performance.

    The trick is to create a separate subsystem/memory pool that has no job queues to route actual jobs into the same memory paging space. It takes a surprisingly small amount of memory to achieve dramatic I/O savings on these files. For the work files, be sure to create them with deleted records, and set them to Reuse Deleted Records = “Y”; this prevents the data space from overflowing the initial allocation and being paged out to disk.

    The following text is from the IBM Help on the SETOBJACC command:

    Set Object Access – Help

    The Set Object Access (SETOBJACC) command temporarily changes the speed of access to an object by bringing the object into a main storage pool or purging it from all main storage pools. An object can be kept main storage resident by selecting a pool for the object that has available space and does not have jobs associated with it.

    Repeated use of the command can cause a set of objects to be resident in a main storage pool.

    FYI . . . The article at this link references V2R2, with performance data from a D70 box. V2R2 was released 2/18/1992. A D70 box was rated at 384 MB max memory with 146 GB DASD, and 32.3 CPW (32, not 32,000). It cost about $400,000 for the base hardware/OS at the time. (See the IT Jungle article A Radical Idea For IBM i Software Pricing for support of this pricing reference.)

    If I remember correctly, our latest P05 class 720 with four cores, 64 GB RAM, and approximately 1 TB of flash disk cost about $120,000 with all cores active for OS/400, memory, and the flash disk included in the amount. (I don’t think the base D70 price included the full memory/DASD configuration). It is rated at 23,800 CPW and can handle about 52,000 IOPS due to the flash disk. It supports 1,600 users in only 4U of rack space.

    Twenty years has made a bit of a difference, hasn’t it?

    But an application written then still runs on the current systems.

    –Dave Flint

    Hey, Dave:

    Regarding the contention about in-memory database capabilities arriving with IBM i 7.1, that was when individual objects could be kept in memory, which is a more direct comparison with what other in memory database options are offering at this time. The article, I believe, makes note of earlier in-memory-like capabilities available in IBM i and OS/400. I would not argue that using memory to enhance database performance has been a capability for many years. In fact, it riles me to hear SAP and Oracle talk about their recent in memory “discoveries.” Their marketing people would like to rewrite history and that sets off my BS meter.

    –Dan

    RELATED STORIES

    In The Shadow Of Database Hype

    A Radical Idea For IBM i Software Pricing

    Knee Deep In Database Modernization

    Business Strategy Bumps Into Database Deficiency

    DB2 for i: The Beating Heart of the IBM i Platform



                         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
    VISUAL LANSA 16 WEBINAR

    Trying to balance stability and agility in your IBM i environment?

    Join this webinar and explore Visual LANSA 16 – our enhanced professional low-code platform designed to help organizations running on IBM i evolve seamlessly for what’s next.

    🎙️VISUAL LANSA 16 WEBINAR

    Break Monolithic IBM i Applications and Unlock New Value

    Explore modernization without rewriting. Decouple monolithic applications and extend their value through integration with modern services, web frameworks, and cloud technologies.

    🗓️ July 10, 2025

    ⏰ 9 AM – 10 AM CDT (4 PM to 5 PM CEST)

    See the webinar schedule in your time zone

    Register to join the webinar now

    What to Expect

    • Get to know Visual LANSA 16, its core features, latest enhancements, and use cases
    • Understand how you can transition to a MACH-aligned architecture to enable faster innovation
    • Discover native REST APIs, WebView2 support, cloud-ready Azure licensing, and more to help transform and scale your IBM i applications

    Read more about V16 here.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Minimizing IPL Surprises With The IPL Startup Kit BCD Brings Mobile App Goodness to WebSmart PHP Edition

    Leave a Reply Cancel reply

Volume 23, Number 41 -- December 2, 2013
THIS ISSUE SPONSORED BY:

looksoftware
Databorough
Abacus Solutions
Essextec
RJS Software Systems

Table of Contents

  • Open Source Is Here To Stay On IBM i
  • Power Chips To Get A GPU Boost Through Nvidia Partnership
  • Roping The Wind: Power7+ In The Texas SMB
  • As I See It: Poisoning The Well
  • Better Worldwide IT Spending Ahead, Predicts IDC
  • Reader Feedback Regarding The Shadow Of Database Hype
  • IBM i ERP Vendor Modernizes For Success
  • Wanted: The Enterprise Data Center Of The Future
  • IBM Tweaks European Power Systems Trade-In Deal
  • IBM Bops Around With Flex System Feature Prices

Content archive

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

Recent Posts

  • With Power11, Power Systems “Go To Eleven”
  • With Subscription Price, IBM i P20 And P30 Tiers Get Bigger Bundles
  • Izzi Buys CNX, Eyes Valence Port To System Z
  • IBM i Shops “Attacking” Security Concerns, Study Shows
  • IBM i PTF Guide, Volume 27, Number 26
  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25

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