IBM Support

IBM i 7.4 - TR9 Enhancements



IBM i 7.4 - TR9 Enhancements


You are in: IBM i Technology Updates > IBM i 7.4 - TR9 Enhancements
IBM i 7.4 -
Enhancements timed with
Technology Refresh 9 (TR9)

Note: The announcement materials for IBM i 7.4 TR9 can be found here.
The remainder of this landing page intends to make it easy to see the supporting detail for these enhancements.

Db2 for i Enhancements 
Note: The following Db2 for i enhancements are delivered by Db2 for i PTF Group SF99704 Level 26.
Db2 for i -  Database Engineer enhancements

IBM i Services (new)

IBM i Services (enhanced)

Db2 for i - Services (new)

Db2 for i - Services (enhanced)

Application Development 
RPG - The RPG language continues its journey as a modern business language. 
  • %LEFT and %RIGHT - New built-in functions to return the right- and left-most characters
    • Support for handling national languages leveraging *NATURAL or *STDCHARSIZE options
  • Simple Enumerations - a set of named constants 
    • Define multiple constants in a group, simplifies compare and usage
Additional Details can be found at the RPG Cafe.

    System Access and Management 
    ACS, the strategic interface for accessing the IBM i and managing & interacting with Db2 for i, continues to be enhanced based on the requests and requirements of our user community.  
    Run SQL Scripts
    In previous releases, support for tabs with the Run SQL Scripts interface was added. This new release includes multi-tab search support:
    • Find a specified set of characters across 'all' tabs open within the Run SQL Interface  Run SQL Scripts Search Results Pane
    • New Search Results pane shows all matching locations in context 
      • Click a result to automatically reposition to the found text 
    Integrated File System
    New preferences are added to provide additional controls to improve the usability and functionality of the IFS interface. 
    • Update Location - an option to provide the default location on your PC for uploading files/directories is now available 
      • Maximum concurrent Upload/Download - Specify how many objects can be uploaded or downloaded at a single time. When many files are selected, the existing support attempts to process all objects at the same time. This setting provides a way to throttle how many files are transferred at one time. IFS Preferences
    System Debugger 
    The ACS interface contains a graphical system debugger. This interface was previously buried within the Run SQL Scripts support. System debugger can now be accessed from the Tools drop-down.
    • System Debugger launch from Tools Menu
    The Generate SQL support within Schemas is dramatically improved to help the users by generating SQL for the following actions:
    Generate SQL for Actions
    • Insert 
    • Update
    • Delete 
    • DML
    • Query 
    • Create procedures for
      • Insert
      • Update 
      • Delete

    IBM Navigator for i
    IBM i

    The web-based interface for accessing, managing, and monitoring the IBM i nodes in your IT estate continues to improve. Based on enhancements from our advisors and the user community, as well as efforts to deliver function from previous versions, Navigator continues to improve and expand. Some of the updates delivered in this latest version are:


    • Table Filter and Sort Improvements:
      • Table filtering and sorts can now be saved to favorites
        • When you save a favorite, any filter or sort currently active on the table can be preserved with the favorite by selecting "Save table's current filters":Add Favorite > Save table's current filters checkbox
      • Multiple-column filtering is now supported
      • Table filters are preserved and applied to the new data when you switch to a different system by using the system tray


    Network > IP Policies > Virtual Private Networking > Create Connection
    • The Configure VPN wizard is now available under Network > Virtual Private Network > Create Connection
    • Additional Properties actions are now available for the following:
      • VPN Secure Connections > By Group > Properties - displays and supports updates to the properties for the defined connection.  Including:
        • Connections tab supports Edit for Policy filter
        • Interfaces tab supports Edit on the available Interfaces
      • VPN IP Security Policies > Data Policies > Properties > Proposals tab now supports the Edit action on existing Proposals
      • User-Defined Server User
    • DNS configuration root servers - added the ability to edit the file


    • Audit Journal Configuration is consolidated to one location under Audit Journal > Configuration.  A new context panel and Advanced settings (from Action > Additional Audit System Values) provide easy access to setting System Values related to auditing.


    • The Users table (including NetServer Disabled Users table) now provides a pre-filter to optionally limit the number of results and improve performance.

    Work Management

    • Remote Output Queues are now available under Printing.  Actions available are:  End Writer, Hold, and Create a remote output queue.
    • Active Jobs table now uses Run Priority in the ORDERBY clause.  The Subsystem is listed in the table before the jobs running in that subsystem (when using default sort).
    • Job Log table now makes better use of space available.


    • A Hardware Resources table was added by using QSYS2.HARDWARE_RESOURCE_INFO
    • New menu format for System actions with subcategories

    File System > IFS

    • The default initial sort is set to ascending
    • For locked files, the Show Usage information is now displayed on the properties panel


    • User-defined bookmarks now support launching to the currently-managed hostname.
    • Shipped bookmarks are now locked-down to prevent modification

    Advanced Job Scheduler (AJS)

    • Almost all functionality for AJS is now available including:
      • Job Groups
      • Most of Scheduled Jobs
    • See AJS page for more details

    I/O Enhancements
    IBM i 7.5 TR 3 supports new offerings for IBM Power Systems and for IBM Storage products:
    • #ENZ0 - PCIe Gen4 I/O Expansion Drawer
    • #ENZF - PCIe Gen4 FanOut Module
    • #EN24, #EN26 - PCIe 4-Port 25/10/1 GbE RoCE SFP28 Adapter
    • #EC71, #EC72 - PCIe 2-Port 25/10/1 GbE RoCE SFP28 Adapter
    • TS4500 tape library with TS1170 tape drives
    • Diamondback Tape Library

    Db2 Mirror for i

    New improvements for usability, serviceability, and performance.  See here for more details.

    IBM PowerHA® SystemMirror® for i (5770-HAS)

    IBM PowerHA SystemMirror for IBM i 7.4 with HA version 4.10.2 continues to evolve, featuring strategic integrations with the IBM i operating system for a more cohesive experience.

    Job Queue Tracking

    PowerHA is a High Availability solution on IBM i, replicating data at the disk level in an independent auxiliary storage pool (IASP). With an emphasis on simplicity and minimal operator involvement, the management and switching of IASPs between systems require little ongoing monitoring.

    Despite this ease of use, knowing the exact status of the environment at the time of failure and where to resume operations has been a hurdle for many high-availability solutions. Job queue tracking simplifies this challenge.


    New features include:

    • Simple user-defined tracking: Start and end tracking for specified job queues to enable automatic tracking of job lifecycle information.
    • Enhanced visibility: Users can easily view the status of active or recently active jobs at the time of the failure.
    • Simplified resubmission: PowerHA simplifies the resubmission of these jobs, paving the way for quicker system recovery.

    Additional Enhancements

    There are several other enhancements to PowerHA. For more information on these enhancements and to get started, see the IBM PowerHA SystemMirror for i wiki page.

    Planned availability date

    • PowerHA 7.4 HA 4.10.2: 15 December 2023

      IBM Backup and Recovery Media Services for i (BRMS)(5770BR1)

      Backup, Recovery and Media Services for i (BRMS) continues to be enhanced and improved.

      • BRMS SQL service enhancements have been added for IASP History Synchronization. These new services give users a set of SQL views and procedures to reflect the use of High Availability (HA) strategies and replication software being utilized in IBM i system environments and allows the BRMS recovery report capability to combine two systems backups into a single recovery report. The goal of the combined recovery report is to prevent replicated data from being saved multiple times, yet still being available for recovery from any system.
      • BRMS SQL service enhancements have been added for BRMS User Administration services. These new services provide BRMS Administrators an SQL procedure to show the BRMS functional authority usage for specified users and BRMS functional areas.
      • BRMS using VTL iSCSI Device solution has been enhanced to IPL the iSCSI IOP when the system comes out of restricted state to improve the user experience.

      The BRMS PTF that delivers these enhancements is: IBM i 7.4 - SI84132

      Follow this link to discover more detail on these and other BRMS enhancements:

        [{"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"IBM i 7.4","Edition":"","Line of Business":{"code":"LOB68","label":"Power HW"}}]

        Document Information

        Modified date:
        29 April 2024