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.

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).
• *JOBCTL special authority is required to view Java jobs
• 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.