• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Dropping Soon: IBM’s Big Application Modernization Redbook

    February 4, 2014 Alex Woodie

    Last year in Rochester, before the Polar Vortex swooped down and turned vast stretches of the Upper Midwest into arctic tundra, IBM convened a meeting of the minds like no other. Big Blue flew in dozens of IBM i modernization experts from all over the world to work on a forthcoming Redbook, with the idea of putting down on paper a complete guide for how to remake existing IBM i apps into sleek and powerful programs that will run businesses for decades to come.

    That Redbook is almost complete. According to sources in the IBM i community, we’ll soon get to see what the modernization experts came up with during those warmer Minnesota days. “I have been looking forward to this set of material for a long time,” IBM i chief architect Steve Will wrote in his blog last week, “and I am excited that it’s almost ‘ready for prime-time’ because it’s something customers need.”

    While hanging Web and mobile interfaces off RPG programs is currently all the rage, there seems to be a growing recognition that a more thorough modernization from the bottom up is the proper prescription to prepare for long term success of IBM i customers, IBM i ISVs, and IBM itself. As Will noted in his blog, there are many shops that have not touched their database in decades.

    “Despite the relational database capabilities that have been a part of this operating system for more than 25 years, they are still running their businesses using older flat-file or hierarchical designs,” Will writes in his blog. “Now that they are growing, and trying to interoperate with more modern technologies such as Web services, they are hitting limitations that will hamper their ability to handle that growth.”

    That Will is speaking about this topic is good news for folks like Marinus van Sandwyk, the managing director of TEMBO Tech Labs, who for the past couple of years has been trying to gain some traction in the North American market with his DB2/400 (DB2 for i) database modernization tool. van Sandwyk is adamant that, by moving databases from the legacy DDS architecture to a modern SQL-based architecture, businesses can retain the value in their IBM i applications, speed application performance, and minimize the pain of future upgrades and modifications. TEMBO is now represented in the Americas by inFORM Decisions.

    It’s also good news for other proponents of SQL on IBM i, such as Fresche Legacy, which last year acquired Databorough and its flagship X-Analysis tool for re-engineering IBM i applications and databases. You can also count the folks at Resolution Software, makers of the Xcase for i database modernization tool, among the interested parties.

    All three of these vendors support the notion that IBM i applications are best served when using the DDL-SQL database engine, and that the days of relying on the DDS engine are over. And IBM is obviously a big supporter of SQL, too. It has published many Redbooks advising IBM i shops and ISVs to adopt SQL as a standard.

    There is nearly unanimous agreement on where the IBM i platform needs to be, and what IBM i shops ought to be doing: using the DDL-SQL database engine (SQE), and not the old DDS engine. That engine served its purpose when applications were written monolithically, but it is proving to be a major hindrance in the migration to the modern world of segmenting applications according to the precepts of the model view controller (MVC) framework.

    The problem, of course, is how to get there. (The devil is always in the details.) Is a big bang migration best, or should it be undertaken in piece meal over time? Should existing RPG applications be entirely recoded and re-engineered to use SQE and the SQL precepts–including turning much RPG business logic into database routines? Or are customers best served by employing an abstraction layer to trick existing RPG apps into thinking they’re talking to the old DDS engine when in fact they’re talking SQL? What’s the best way for managing a big database modernization project, and how can you sell it to the boss? What role do new technologies, like RPG Open Access, play in all this?

    There are a lot of questions that come up when one undertakes a big IT project, like a database migration, and they all need to be studied and understood thoroughly. While the GUIs and mobile apps may get more attention from the employees and other users, the CEOs and business owners understand that there is a lot more at play when the guts of an IBM i application are opened up and tinkered with.

    There are potentially big rewards for IBM i shops that successfully modernize their applications’ database around SQL: simpler maintenance of code, ease of finding technical talent, a clearer modernization path, and faster performance (primarily for random data access). But there are also risks, which is why the upcoming Redbook is so highly anticipated.

    While it sounds bad, doing nothing is also an option. But there’s already been a whole lot of “doing nothing” done up to this point in the IBM i community. IBM itself has been a big enabler of the do nothing route, as it seeks to avoid rocking the boat and upsetting customers.

    “In my recent customer visits, I have been reminded once again what a ‘double-edged sword’ we have created as we’ve allowed customers to remain on older technology without forcing them to modernize,” Will writes in his blog.

    Let’s hope that in the upcoming Redbook, that IBM gives us clear bearings on which direction IBM i shops ought to go–and gives them the proper incentives to reach their destination. Although the Rebook was originally expected to be available in January, it is now being predicted for a March arrival.

    RELATED STORIES

    TEMBO Taps inFORM to Distribute Database Modernization Tool

    Databorough Snapped Up By Fresche Legacy

    Just Watching Or Making An IBM i Modernization Plan?

    Knee Deep In Database Modernization

    DB2 For i Modernization Gets Assist From RPG OA

    Database Modernization: A Matter Of Survival For IBM iISVs

    DB2 on i: The Time, Money, and Risk of Modernization



                         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
    DRV Technologies, Inc.

    Get More from Your IBM i

    Many users today struggle to get at the data they need on the IBM i. When users get reports, they look like they were formatted some time last century.

    Some organizations are still printing pre-printed forms and checks on impact printers.

    How often do operators log on to their system to look for messages they hope they don’t find?

    All of these scenarios can affect users’ perception of the IBM platform negatively, but there are simple solutions.

    DRV Technologies Inc. develops innovative solutions that help customers get more from their IBM i systems.

    Solutions include:

    • SpoolFlex spool conversion & distribution
    • FormFlex electronic forms
    • SecureChex MICR laser check printing
    • MessageFlex system monitoring

    FlexTools streamline resources, improve efficiency and enable pro-active system management.

    Better software, better service, DRV Tech.

    Learn how you can get more from your IBM i at www.drvtech.com

    Call 866 378-3366 for a Free Demonstration

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    Northeast User Groups Conference:  24th Annual Conference, April 7 - 9, Framingham, MA
    System i Developer:  Upgrade your skills at the RPG & DB2 Summit in Dallas, March 18-20.
    Profound Logic Software:  Live Webinar: "See What i Can Do With Modern RPG Development." Feb 12

    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

    Power Systems At The Center Of Texas A&M Research Quadrant Buys BCD Software

    Leave a Reply Cancel reply

Volume 14, Number 3 -- February 4, 2014
THIS ISSUE SPONSORED BY:

ARCAD Software
Maxava
Profound Logic Software
Computer Keyes
Shield Advanced Solutions

Table of Contents

  • BCD Flushes More Green from Modernized IBM i Screens
  • Help/Systems Reduces Annoyances of Multi-OS Job Scheduling
  • Dropping Soon: IBM’s Big Application Modernization Redbook
  • Insurer Enjoys ‘Profound’ Transition of 5250 App
  • IBM Goes Graphical with PowerVP Performance Tool
  • Gumbo Spices Up IBM i Spool Tools
  • Software Change Management Designed For Small IBM i Shops
  • CNX Begins Beta for Valence 4.0
  • Krengel Soothes RPG to XML Integration Needs
  • IBM Adds Latest Sametime Chat Feature to Notes and Domino

Content archive

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

Recent Posts

  • Security Still Top Concern, IBM i Marketplace Study Says
  • Bob Langieri Shares IBM i Career Trends Outlook for 2023
  • Kisco Brings Native SMS Messaging to IBM i
  • Four Hundred Monitor, February 1
  • 2023 IBM i Predictions, Part 4
  • Power Systems Did Indeed Grow Revenues Last Year
  • The IBM Power Trap: Three Mistakes That Leave You Stuck
  • Big Blue Decrees Its 2023 IBM Champions
  • As I See It: The Good, the Bad, And The Mistaken
  • IBM i PTF Guide, Volume 25, Number 5

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 © 2022 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.