What's new
The following revisions or additions have been made to the Memorandum to Users documentation since the first IBM® i 7.4 publication. These entries will be found only in the English version of the memo to users.
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.
October 2024
- New entries added:
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
- IBM WebSphere Application Server v8.5 support for TLSv1.3
- 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 entry:
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
- 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.
- IBM Navigator for i was modified.
- May 2021 update
- 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.
- 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:
- April 2020 update
- May 2019 update
- 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 help you see where technical changes have been made, this information uses:
- The image to mark where new or changed information begins.
- The image to mark where new or changed information ends.
To find other information about what's new or changed this release, see the Memo to users.