What's new

What’s new

The updates for each Memo to Users entry were made at the specified time frame for the section. The actual release date of some changes documented may not be until the next Technical Refresh (TR) date. Check dates on the PTF specified for each entry to verify release dates.

November 2025

• New entries added:.
  • Change to Database file delete processing
  • Upgrade of IBM i: OpenSSH v8.6 to v9.6p1

October 2025

• New entries added:.
  • Enhanced key column for KEY_COLUMNS_ADVISED of system index advice table QSYS2.SYSIXADV
  • ADD_HOURS, ADD_MINUTES, and ADD_SECONDS SQL scalar function error enforcement
  • Automated removal of historical rows from QSYS2.SYSIXADV
  • Automated removal of historical rows from QSYS2.SQL_ERRORT
  • GENERATE_SPREADSHEET scalar function and QPRINT change
  • QSYS2.CHANGE_DEVICE_LOCKING_POLICY and QSYS2.CREATE_LOCKING_POLICY password rule change

July 2025

• New entries added:.
  • Change to XMLELEMENT SQL scalar function formatting for some decimal numbers
  • ILE RPG SQL Precompiler use of CONST for arrays
  • QADBXRDBD and QADBXRMTNM *FILEs no longer updateable
  • Authority requirement for underlying *FILEs for GRANT (view) SQL statement
  • Authority requirement change for SQL function invocation and procedure CALL

April 2025

• New entries added:.
  • Authority requirement change for SQL function invocation and procedure CALL
  • Authority requirement for underlying *FILEs for GRANT (view) SQL statement
  • BEFORE triggers not allowed on QSYS2.SQL_ERRORT and QSYS2.SYSIXADV tables
  • SQL Error Logging Facility (SELF) can be turned off system-wide using *NONE.
  • IBM Communication Utilities for System i (5761-CM1) withdrawn.
  • Business Graphics Utility (5761-DS2) withdrawn.
  • System/38 Utilities (5761-DB1) withdrawn.
  • Application Management ToolSet for i (5770-AMT) withdrawn.
  • ATTENTION_LIGHT column definition changed for SYSTEM_STATUS views and table function.

October 2024

• New entries added:
  • Transform Services (5770-TS1).
  • DRDA/DDM connection first attempt with more secure AES encryption algorithm
  • Authority requirement change for CREATE OR REPLACE SQL statements
  • Authority requirement change for CREATE VIEW SQL statement.

May 2024

• New entries added:
  • Authority changes from slip-install may cause *USER profiles to get blank screen was added to IBM Navigator for i.
  • Web Administration GUI migration to IBM Navigator i.
  • Administration Runtime Expert (ARE) Console migrated to IBM Navigator for i.
  • Heritage ARE Console No Longer Saves Passwords.
  • Management Central authority changes.
  • QSYS2.AUTHORITY_COLLECTION views authority checks
  • RENAME (SQL) statement changed to require more authority
  • Add Physical File Trigger (ADDPFTRG) CL command *PUBLIC authority
  • QRECOVERY/QDBppnnnn *FILE -*PUBLIC authority
  • QRECOVERY/QADBERAP *FILE - *PUBLIC authority

• Updated entries:

  • IBM-supplied user profiles deleted in a future release.
  • Plan for a Attended IPL - Sign-on required at DST
  • IBM Db2 Web Query for i (5733-WQX).

March 2024

• NLV Translation Changes was added.

October 2023

• Db2 Mirror database IASP vary off processing change was added.
• QSYS2.USER_INFO and QSYS2.USER_INFO_BASIC view performance change was added.
• Behavior changes for RGZPFM with ALWCANCEL(*YES) was added.
• JSON_ARRAY SQL scalar function change was added.
• QSYS2.PTF_INFO view requires *USE authority was added.
• Updates to the following sections have been made:
  • New database monitor field indicating shared common table expressions for SQL queries
  • Change to implementation of some shared common table expressions for SQL queries
  • QSYS2.GROUP_PTF_INFO view requires *USE authority

May 2023

• Db2 Mirror suspend due to storage threshold was added.

April 2023

• Heritage Digital Certificate Manager is disabled was added.
• IBM-supplied user profiles deleted in a future release was added.
• QSYS2.GROUP_PTF_INFO view requires *USE authority was added.
• SQL ILE RPG precompiler change for BOOLEAN support was added.
• STACK_INFO unauthorized access default behavior change was added.
• Generate Data Definition Language (QSQGNDDL) API will now produce SQL table names for VIEW and MQT definitions was added.
• ADDPFTRG/CHGPFTRG command changes was added.
• CREATE TRIGGER and ALTER TRIGGER - MIRROR YES option removed was added.
• Password parameters removed from db2mtool command was added.

October 2022

• SQE Symmetric Multiprocessing Changes was modified with additional PTF information for more recent changes.
• Db2 Mirror resume processing change was added.
• CHGDEVTAP UNLOAD change now allowed while device is varied on was added.
• SM (Systems Management Change) audit journal entry change was added.
• DNS changes was modified.
• Changes to Backup Recovery and Media Services (5770-BR1, 5770-BR2).
• *JOBCTL special authority is required to view Java jobs
• Access to lazy-load tables through NEWNAV in QNEWNAVSRV was added.

May 2022

• STRQMQRY command changes was added.
• CRTQMQRY and CRTQMFORM command changes was added.

How to see what's new or changed

To find other information about what's new or changed this release, see the Memo to users.