News
Abstract
This document provides the date of when the Memo To Users was last changed, a summary of recent changes and the link to full documents for review by release level.
Content
The Memo To Users for supported releases were last updated July of 2025. Clients should review the full What's New details to understand recent changes and impact these may have.
July 2025
- 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
- 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
- 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.
- 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
- 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.
- 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
- 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
- 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).
- 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
- 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).
October 2023 Update:
- Db2 Mirror database IASP vary off processing change was added.
- Behavior changes for RGZPFM with ALWCANCEL(*YES) was added.
- RNF5393 is now issued for CLEAR *ALL or RESET *ALL for an array of data structures was added.
- QSYS2.PTF_INFO view requires *USE authority was added.
- Behavior changes for RGZPFM with ALWCANCEL(*YES) was added.
- RNF5393 is now issued for CLEAR *ALL or RESET *ALL for an array of data structures was added.
- QSYS2.PTF_INFO view requires *USE authority was added.
Updates to the following sections have been made:
- %TIMESTAMP now returns a timestamp with microsecond precision
- 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
- %TIMESTAMP now returns a timestamp with microsecond precision
- 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
April 2023 Update
- CHGSMTPA KEEPUNTIL now has two retention time parameters for successful and unsuccessful final status.
- Heritage Digital Certificate Manager is disabled.
- QMGTC user profile deleted in a future release.
- GROUP_PTF_INFO view requires *USE authority.
- SQL ILE RPG precompiler change for BOOLEAN support.
- STACK_INFO unauthorized access default behavior change.
- Generate Data Definition Language (QSQGNDDL) API will now produce SQL table names for VIEW and MQT definitions.
- ADDPFTRG/CHGPFTRG command changes.
- CREATE TRIGGER and ALTER TRIGGER - MIRROR YES option removed.
- Password parameters removed from db2mtool command.
- Heritage Digital Certificate Manager is disabled.
- QMGTC user profile deleted in a future release.
- GROUP_PTF_INFO view requires *USE authority.
- SQL ILE RPG precompiler change for BOOLEAN support.
- STACK_INFO unauthorized access default behavior change.
- Generate Data Definition Language (QSQGNDDL) API will now produce SQL table names for VIEW and MQT definitions.
- ADDPFTRG/CHGPFTRG command changes.
- CREATE TRIGGER and ALTER TRIGGER - MIRROR YES option removed.
- Password parameters removed from db2mtool command.
October 2022 update
The updates for this Memo to Users section were made at the above time frame. The actual release date of some changes documented here may not be until the next Technical Refresh (TR) date of December 2022. Check dates on the PTF specified for each entry to verify release dates.
- SQE Symmetric Multiprocessing Changes were made.
-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).
- *JOBCTL special authority is required to view Java jobs
- Access to lazy-load tables through NEWNAV in QNEWNAVSRV was added.
-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).
- *JOBCTL special authority is required to view Java jobs
- Access to lazy-load tables through NEWNAV in QNEWNAVSRV was added.
April 2022 update
- CHGSMTPA KEEPUNTIL now has two retention time parameters for successful and unsuccessful final status was added.
- QIBM_NAV_ALL_FUNCTION Function Usage ID now shipped with default of *DENIED was added.
- Check Parameters and Data Areas used in BRMS was added.
- Change to implementation of some shared common table expressions for SQL queries was added.
- Generate SQL will now produce SQL table names for VIEW and MQT definitions was added.
- RESTRICT ON DROP clause is no longer ignored, and will cause an error was added.
- Change in LISTAGG error was added.
- QSYS2.SYSTEM_STATUS table function, QSYS2.SYSTEM_STATUS_INFO view, and QSYS2.SYSTEM_STATUS_INFO_BASIC view changes was added.
- Db2 Mirror Security changes was added.
- Changes to authority required for QSYS2.COMPARE_RESYNC_STATUS() table function was moved to this new section.
- QMRDBAPI service program default public authority changed from *USE to *EXCLUDE was moved to this new section.
- Setup tools default public authority changed to *EXCLUDE was added.
- Replication Criteria List (RCL) default public authority changed to *EXCLUDE was added.
- Compare services now require *ALLOBJ special authority was added.
- QSYS2.EVALUATE_PENDING_REPLICATION_CRITERIA default public authority changed to *EXCLUDE was added.
- QIBM_NAV_ALL_FUNCTION Function Usage ID now shipped with default of *DENIED was added.
- Check Parameters and Data Areas used in BRMS was added.
- Change to implementation of some shared common table expressions for SQL queries was added.
- Generate SQL will now produce SQL table names for VIEW and MQT definitions was added.
- RESTRICT ON DROP clause is no longer ignored, and will cause an error was added.
- Change in LISTAGG error was added.
- QSYS2.SYSTEM_STATUS table function, QSYS2.SYSTEM_STATUS_INFO view, and QSYS2.SYSTEM_STATUS_INFO_BASIC view changes was added.
- Db2 Mirror Security changes was added.
- Changes to authority required for QSYS2.COMPARE_RESYNC_STATUS() table function was moved to this new section.
- QMRDBAPI service program default public authority changed from *USE to *EXCLUDE was moved to this new section.
- Setup tools default public authority changed to *EXCLUDE was added.
- Replication Criteria List (RCL) default public authority changed to *EXCLUDE was added.
- Compare services now require *ALLOBJ special authority was added.
- QSYS2.EVALUATE_PENDING_REPLICATION_CRITERIA default public authority changed to *EXCLUDE was added.
January 2022 updates:
- CHGRDBDIRE command authority requirements change was added.
- Change to implementation of some shared common table expressions for SQL queries was added.
- New database monitor field indicating shared common table expressions for SQL queries was added.
- Change to implementation of some shared common table expressions for SQL queries was added.
- New database monitor field indicating shared common table expressions for SQL queries was added.
November 2021 updates:
- Connection Type parameter changes to Save-Restore commands was added.
- IBM Universal Manageability Enablement (5770-UME) changes was added.
- Changes to authority required for QSYS2.COMPARE_RESYNC_STATUS() table function was added.
- IBM Universal Manageability Enablement (5770-UME) changes was added.
- Changes to authority required for QSYS2.COMPARE_RESYNC_STATUS() table function was added.
September 2021 updates:
- IBM Navigator for i was modified.
- Re-created Navigator for iwas added.
- IBM Navigator for i requires 64-bit Java™ SE 8 or greater was updated.
- IBM Navigator for i Primary Access Methodology was updated.
- IBM Navigator for i Integrated Server GUIwas updated.
- SQLGetData increased buffer length was added.
- Behavior change for SQL GENERATED ALWAYS AS (USER or SESSION USER) was added.
- QMRDBAPI service program default public authority changed from *USE to *EXCLUDE was added.
- DATA_QUEUE_ENTRIES() table function key length enforcement was added.
- System Limits removal of old rows was added.
- Re-created Navigator for iwas added.
- IBM Navigator for i requires 64-bit Java™ SE 8 or greater was updated.
- IBM Navigator for i Primary Access Methodology was updated.
- IBM Navigator for i Integrated Server GUIwas updated.
- SQLGetData increased buffer length was added.
- Behavior change for SQL GENERATED ALWAYS AS (USER or SESSION USER) was added.
- QMRDBAPI service program default public authority changed from *USE to *EXCLUDE was added.
- DATA_QUEUE_ENTRIES() table function key length enforcement was added.
- System Limits removal of old rows was added.
[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000C4BAAU","label":"IBM i"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.3.0;7.4.0;7.5.0"},{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSTS2D","label":"IBM i 7.3 Preventative Service Planning"},"ARM Category":[{"code":"a8m0z0000000C4BAAU","label":"IBM i"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.3.0"},{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS9QQS","label":"IBM i 7.4 Preventative Service Planning"},"ARM Category":[{"code":"a8m0z0000000C4BAAU","label":"IBM i"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0"},{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSB23CE","label":"IBM i 7.5 Preventative Service Planning"},"ARM Category":[{"code":"a8m0z0000000C4BAAU","label":"IBM i"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.5.0"}]
Was this topic helpful?
Document Information
Modified date:
23 July 2025
UID
ibm16471617