• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • IBM i 7.3 Arrives April 15; 7.2 TR4 Follows in May

    April 12, 2016 Dan Burger

    It’s here. Today is IBM‘s announcement day for i 7.3, which becomes available Friday, April 15. The Technology Refresh, TR4 for i 7.2, arrives May 20. A new OS release is a glimpse of the future. For some of you, the future is now. You’re the early adopters–the people who put the bug in IBM’s ear several years ago about expanding analytical capabilities and help getting a handle on the security problem that is crying for attention.

    This release fits into the long-term strategy of Chief Architect Steve Will by providing more options for those who want to develop on the platform. It expands open source support and brings RPG enhancements.

    We’ve reached another destination on the IBM i Roadmap with the unveiling of i 7.3.

    “We know the reason people use the platform is because of the data,” Will says. “Workloads have changed. Customers are interested in OLAP. We are working on data-centric enhancements. And the biggest dilemma in security is that many users have much more authority to see sensitive data than they should have and it has been complicated to match the correct authorization with users.”

    The top three enhancements–DB2 for i temporal support, enhancements to the OLAP capability for SQL, and security authority collection–are exclusive to i 7.3. To load and go with 7.3, you’ll need to be packing Power8, Power7+, or Power7 iron.

    To upgrade to IBM i 7.3 requires Power 7, Power7+, or Power8 hardware.

    “There’s always a number of people asking for the features that have been put into a new release. They have been asking and waiting for them for a long time. They jump on new releases right away,” says Alison Butterill, product offering manager for IBM i. After that, the upgrades are expected to move at slow pace for a couple of years. For i 7.2, now two years past its debut, our best estimate is that less than 20 percent of the installed base have made that jump.

    Will and Butterill discussed the new OS with IT Jungle Friday in a 30-minute pre-announcement briefing.

    Temporal Support
    The IBM i platform built its reputation on mowing through transactional workloads. It has some work to do on the analytical side. This is a good start. The SQL advocates in the IBM i camp will be elated to hear about temporal support, which in paradoxical fashion leads to the future by opening the door to the past. Temporal support allows SQL programmers to query data as if they were asking questions from a point in the past.

    “DB2 is excellent for keeping track of transactions,” Will points out. “Everybody has that. It’s what databases are about. But temporal support is for comparing current data with data at selected points in the past. Keeping track of data from the past is not typically what a database does.

    “Some have tried this in the past by taking snapshots of data and putting that data someplace where it could be examined. There has to be space for that data and that data has to be managed. This enhancement builds that capability into the database.”

    It’s happening across all the DB2 databases. Microsoft SQL and Oracle have added temporal support. There’s no temporal support in the open source databases.

    Online Analytical Processing
    For the past 30 years, online transactional processing (OLTP) was king in the IBM midrange kingdom. Reports were pushed out by reading rows of data, examining that data, and doing mathematical analysis. OLAP, which is embedded in SQL, makes it possible to ask questions of the data and get answers without all the shovel work. For example: OLAP could deliver the answer when the database is asked to predict sales based on marketing expenditures.

    A few IBM i users might have used Cognos to get these types of questions answered, but the operator would have accomplished this by writing a program that pulled data off the system and then the operator would have performed the calculation himself.

    With the OLAP functionality built into the database, questions can be asked of the data in real time and no data gets pulled off the system. SQL programmers will write their own queries ad get answers to questions like how do our product sales this year compare to the past three years.

    IT Jungle’s Alex Woodie will be getting into the analytics topic much deeper in an article to be published Wednesday in The Four Hundred newsletter.

    Security Authority Collection
    There’s much to be said about the tendency for users to be granted more authority than actually needed. All of it is critical of the practice. (You can read more about that in the Testing For Security Inadequacies article elsewhere in this issue of the newsletter.)

    “An operator should be able to run a job, but not modify data,” Will explains. “The policy is there, but the company is not sure it’s implemented. Fifteen years ago, it was not uncommon for companies to grant authority to all users. It was done “to be safe.” So that no one who needed authority was locked out. Now there is concern that some may have too much authority and it could be misused.”

    It comes down to knowing what the authority level needs to be to get the job done, and that is what this enhancement is about. The new capability traces the work being done by a certain user and determines the various programs, data, objects touched and what authority the user needs to do the job. It also determines what authority the user actually has. The end result is identifying when more authority than necessary has been granted to an individual.

    Will expects the feature will be very popular with IBM i security vendors. One reason is that it’s a complicated process. Companies with small staffs are not likely to tackle this analysis themselves.

    The tool traces at the object level and uses Navigator and SQL to do its work.

    TR 4 for IBM i 7.2 joins i 7.3 by sharing the remaining enhancements.

    Open Source
    IBM i has a pretty strong collection of open source components that it supports–PHP, Ruby, Node.js, and Python. Now it’s adding Git and Orion. Both have big developer appeal.

    Git is used for collaboration, tracking development, change management, and source control.

    Orion is an open source software development environment.

    “We see a lot more components being introduced around the world that are based on open source,” Butterill says. “The volume of customers asking about open source has increased dramatically over the past two years.”

    RPG
    After focusing RPG development on support for Open Access (2010) and free form RPG (2013), support for a number of small features backed up, according to Will. We will have to wait for the specifics of this list, but cleaning up some free form support and adding parameters were mentioned. COBOL developers should find some added support as well when the full documentation becomes available.

    PowerHA
    This latest version of IBM’s PowerHA is labeled 7.2, but it runs on i 7.2 and i 7.3. It differs with early versions of PowerHA because of tighter integration with storage area networks (SANs). Yes, that’s plural. The former one SAN limit is now two. Clustering anyone? The two SAN combo allows a quick switch from one primary HA environment to the other, which could be very useful if an outage is caused by one of the SANs.

    Web Query
    Several additional functions have been added to Web Query. The most interesting is the capability to create reports with data from additional sources converged with data being pulled from IBM i.

    “There’s a whole lot of data associated with MySQL and Maria DB, the follow on to MySQL,” Will notes. “Some shops have brought MySQL data onto IBM i, but there’s a lot of data not hosted on i, but still important to business.”

    RELATED STORIES

    IBM i Tech Refresh Reiterates Database Emphasis

    IBM i Strategist Sets Priorities, Balances Resources

    It’s TR Time: What’s Next For The IBM i Database?

    DB2 Enhancements, Free Form RPG, Modernization Top Rowe’s ‘Big Hits’ List

    IBM i 7.2 Tightens Data Access And Security

    As The World Turns: Investments In IBM i

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Midrange Dynamics North America

    Git up to speed with MDChange!

    Git can be lightning-fast when dealing with just a few hundred items in a repository. But when dealing with tens of thousands of items, transaction wait times can take minutes.

    MDChange offers an elegant solution that enables you to work efficiently any size Git repository while making your Git experience seamless and highly responsive.

    Learn more.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    COMMON:  2016 Annual Meeting & Expo, May 15 - 18, in New Orleans! Great Power Systems event!
    iTech Solutions:  Get your copy of Pete Massiello's The IBM i State of the Union report now!
    Profound Logic Software:  'i on the Enterprise' Worldwide Virtual Event. June 8. Register Now!

    Refacing Your Database, Part 1 Inside the New Analytic Functions of IBM i 7.3

    Leave a Reply Cancel reply

Volume 26, Number 16 -- April 12, 2016
THIS ISSUE SPONSORED BY:

Profound Logic Software
BCD Software
Chrono-Logic
Linoma Software
WorksRight Software

Table of Contents

  • IBM i 7.3 Arrives April 15; 7.2 TR4 Follows in May
  • IBM Puts Future Power Chip Stakes In The Ground
  • Spreading A Wider IT Net At UCG Technologies
  • Testing For Security Inadequacies
  • Thank You, IBM

Content archive

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

Recent Posts

  • Public Preview For Watson Code Assistant for i Available Soon
  • COMMON Youth Movement Continues at POWERUp 2025
  • IBM Preserves Memory Investments Across Power10 And Power11
  • Eradani Uses AI For New EDI And API Service
  • Picking Apart IBM’s $150 Billion In US Manufacturing And R&D
  • FAX/400 And CICS For i Are Dead. What Will IBM Kill Next?
  • Fresche Overhauls X-Analysis With Web UI, AI Smarts
  • Is It Time To Add The Rust Programming Language To IBM i?
  • Is IBM Going To Raise Prices On Power10 Expert Care?
  • IBM i PTF Guide, Volume 27, Number 20

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