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

October 2025

• New entries added:
  • ADD_HOURS, ADD_MINUTES, and ADD_SECONDS SQL scalar function error enforcement
  • QSYS2.CHANGE_DEVICE_LOCKING_POLICY and QSYS2.CREATE_LOCKING_POLICY password rule change

July 2025

• New entries added:
  • 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.
  • Change to XMLELEMENT SQL scalar function formatting for some decimal numbers
  • QADBXRDBD and QADBXRMTNM *FILEs no longer updateable

April 2025

• New entries added:
  • 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.
  • ATTENTION_LIGHT column definition changed for SYSTEM_STATUS views and table function.

October 2024

• New entries added:
  • 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

October 2023

• 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.
• 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
  • IBM Db2 Web Query for i (5733-WQX) changes

May 2023 update

• Db2 Mirror suspend due to storage threshold was added.

April 2023 update

• CHGSMTPA KEEPUNTIL now has two retention time parameters for successful and unsuccessful final status was added.
• Heritage Digital Certificate Manager is disabled was added.
• Heritage IBM Navigator for i is disabled was added.
• Heritage IBM Navigator for i permanently removed from the system was added.
• QSYS2.GROUP_PTF_INFO view requires *USE authority 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 update

• Db2 Mirror resume processing change was added.
• SM (Systems Management Change) audit journal entry change was added.
• *JOBCTL special authority is required to view Java jobs was added.
• CHGDEVTAP UNLOAD change now allowed while device is varied on was added.
• Access to lazy-load tables through NEWNAV in QNEWNAVSRV was added.
• Backup Recovery and Media Services (5770-BR1) was updated.

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.
• Database changes
  • 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 update

• 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.

• November 2021 update
• • 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.
• September 2021 update
  • IBM Navigator for i was modified.
    • Re-created Navigator for i was 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.
  
• May 2021 update
  • Db2 Mirror Object Replication Capability Extended to User Indexes, User Spaces, and Data Queues was added.
  
• April 2021 update
  • SYSDISKSTAT extended to return each disk path was added.
  • Updated EBCDIC Unicode maps for CCSIDs 1377 and 1388 was added.
  • Native JDBC driver can fail with SQL0191 (Mixed data or UTF-8 data not properly formed) was added.
  • OBJECT_STATISTICS() table function changes for *USRPRF objects was added.
  • Calls to SQLSetConnectAttr API may now return -1 with Message ID SQ99999 was added.
  • IBM Navigator for i requires 64-bit Java SE 8 was added.
  • Open Source Package Management Interface Proxy Support was added.
  • Queries that compare a numeric value with blanks or an empty string will fail with SQLSTATE/SQLCODE ‘22023’/-302 or '53045'/-678 was added.
  • Change to authority required for registering Query Governor exit programs was added.
  
• October 2020 update
  • Open Source Package Management Interface Proxy Support was added.
  • TLSv1.3 enablement may require changes to GSKit client to prevent GSK_WOULD_BLOCK or EWOULDBLOCK advisory condition was added.
  • Service Monitor autostart job entry removed from QUSRWRK subsystem description was added.
  • An RPG file defined with USAGE(*UPDATE) is no longer opened delete-capable was added.
  • XML-SAX with "ccsid=1200" or "ccsid=13488", when the default UCS-2 CCSID for the module is a different CCSID was added.
  • %TIMESTAMP now returns a timestamp with microsecond precisionwas added.
  • Links were updated in the following sections:
    1. IBM Developer Kit for Java (5770-JV1)
    2. Discontinued support for certain software and hardware
    3. Upgrade planning
    4. Required PTFs before you upgrade to IBM 7.4
  
• April 2020 update
  • Changes to CL commands sending messages to *EXT was added.
  • QSYS2 SQL catalog files no longer restored with restore commands was added.
  • Plan for your Operations Console installation or upgrade was updated.
• May 2019 update
  • Mitigating Spectre and Meltdown vulnerabilities in new and existing programs was added.
  • Percent of Permanent Addresses Used Calculation was updated.
• April 2019 update
  • Upgrade planning was updated.
  • QSYS2.ASP_INFO view change was added.
  • SQE_NATIVE_ACCESS QAQQINI control is deprecated was added.
  • IBM WebSphere Application Server 8.5 (5733-W85) and 9.0 (5733-W90) was updated.

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.