IBM Support

IBM i 7.4 - Base Enhancements



IBM i 7.4 - Base Enhancements


You are in: IBM i Technology Updates > IBM i 7.4 - Base Enhancements

IBM i 7.4

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



IBM Db2 Mirror for i

    Operating System Synchronous Replication
    Continuous Availability 
    24 x 7 Up Time
    RTO/RPO Near Zero
    IBM Db2 Mirror for i(5770-DBM)
image 2068
For more details on Db2 Mirror for i: IBM Db2 Mirror for i Knowledge Center.

Db2 for i Enhancements 
image 2073

Db2 for i - Functional Enhancements

Db2 for i - Performance Enhancements

Db2 for i - Database Management Enhancements

Db2 for i - Database Security Enhancements

IBM i Services (new and enhanced)

Db2 for i - Services (enhanced)

Db2 Web Query V2.2.1

Security and Networking


Application Development



  • PCIe4 2-port 100 Gb ROCE EN adapter adds dedicated and native SR-IOV NIC, and dedicated and native SR-IOV RoCE
  • PCIe 2-port Ethernet adapters add dedicated and native SR-IOV RoCE
  • PCIe3 6-Slot Fanout Module for PCIe3 Expansion Drawer 
  • PCIe x16 to CXP Converter Card
  • New Enterprise SSDs 
  • New Mainstream SSDs 
  • Operating System limits increased for disk arms and LUN size
  • Operating System limits increased for multicore and multithread

Core Operating System Updates

Systems Management and Power HA

  • Access Client Solutions - Latest download site 
    • Run SQL Scripts
      • SQL Syntax verification 
      • SQL Formatting
      • Last used DB connection remembered 
      • New SQL Examples added to Insert from Examples
    • IFS
      • New include support to allow server side limiting of entries returned 
  • Clustering enhancements to automate and simplify operations
  • IBM PowerHA SystemMirror for i enhancements:
    • Support for DS8000 HyperSwap with a Global Mirror link
    • Automation of administrative domain operations
    • Support for disaster recovery of a Db2 Mirror deployment
    • Support for replication of IFS data in a Db2 Mirror deployment
    • For more details, see the PowerHA 7.4 Wiki page 
  • IBM Backup, Recovery, and Media Services for i (BRMS) enhancements:
    • Turn-key cloud control group deployment for easy set-up
    • SAVLIBBRM default now backs up changes to journaled objects
    • Support for new 3592 tape device
    • Support to easily back up all spooled files, which improves restore performance
    • Enhanced logging to help preserve message order when log entries occur at the same second

Open Source Updates

IBM i Access ODBC driver ported to IBM i. 

Allows any standard ODBC client to be able to communicate to the local database on i. It also allows an application to be developed using the IBM i Access ODBC driver for Windows/Linux and deployed to IBM i using the same ODBC driver. 

Node.js Ecosystem Enhancements

  • idb-connector and idb-pconnector 1.x released  - provides direct API access to Db2 using conventional (callback-based) JavaScript conventions. See idb-connector  and idb-pconnector for details.
  • itoolkit package - SSH or ODBC connections can be used to communicate with ILE IBM i objects. See itoolkit for details.
  • Loopback - a JavaScript framework that allows for rapid creation and deployment of REST API’s

Python Ecosystem Enhancements 

New packages allow for security enhancements, more options for application development, data science, and machine learning.
Python Machine Learning and Data Science libraries. The following RPM Packages are available:

  •  Pillow
  • asn1crypto
  • bcrypt
  • cffi
  • cryptography
  • devel
  • ibm_db
  • idna
  • itoolkit
  • lxml
  • numpy
  • pandas
  • pip
  • pycparser
  • pynacl
  • scikit-learn
  • scipy
  • tkinter


R brings another programming language to IBM i. Although it has a wide variety of uses, R excels at statistical computing and data mining. Db2 can be accessed from R by installing the “odbc” package and using the newly-delivered ODBC driver.

Open Source Tools

  • Apache ActiveMQ, a robust message broker with support for several protocols including OpenWire, STOMP, MQTT, AMQP, REST, and WebSockets. For more information, see Apache ActiveMQ for details
  • Apache Ant  build automation tools.  For more information, see apache for details
  • Maven  build automation tools. For more information, see Maven for details
  • vim, a terminal-based editor. For more information, see vim for details
  • yum-utils, a collection of tools and programs for managing yum repositories and installed software for more advanced users. For more information, see yum-utils for details
  • Midnight Commander, a terminal-based utility for exploring the filesystem which enables the user to access FTP sites, compare files/directories, edit files, run things from a subshell, and lots more! The interface also has mouse support, allowing for menu-based access to functions and scroll wheel support. For more information, see Midnight Commander for details 


Other Product Updates 


Administration Runtime Expert - 5733ARE 

  • Many new features added to the ARE for better PTF management support


[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"IBM i 7.4","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
31 January 2020