News
Abstract
IBM i 7.3 - TR10 Enhancements
Content
IBM i 7.3 - Enhancements timed with Technology Refresh 10 (TR10) |
IBM i Anywhere
IBM i Everywhere
|
The remainder of this landing page intends to make it easy to see the supporting detail for these enhancements.
Db2 for i Enhancements |
IBM i Services (new)
- QSYS2.MESSAGE_QUEUE_INFO()
- QSYS2.QCMDEXC (scalar function)
- QSYS2.SECURITY_INFO
- QSYS2.SEND_MESSAGE()
- QSYS2.USER_INDEX_ENTRIES()
- QSYS2.USER_INDEX_INFO
- QSYS2.USER_INFO_BASIC
- QSYS2.USER_SPACE()
- QSYS2.USER_SPACE_INFO
- SYSTOOLS.AUDIT_JOURNAL_AF()
- SYSTOOLS.AUDIT_JOURNAL_CA()
- SYSTOOLS.AUDIT_JOURNAL_OW()
- SYSTOOLS.AUDIT_JOURNAL_PW()
- SYSTOOLS.CHANGE_USER_PROFILE()
- SYSTOOLS.GENERATE_PDF
IBM i Services (enhanced)
- QSYS2.ACTIVE_JOB_INFO()
- QSYS2.CERTIFICATE_INFO()
- QSYS2.DISPLAY_JOURNAL()
- QSYS2.IFS_OBJECT_STATISTICS()
- QSYS2.JOB_INFO()
- QSYS2.OBJECT_STATISTICS()
- QSYS2.SYSDISKSTAT (table function)
- QSYS2.SYSDISKSTAT (view)
- QSYS2.USER_INFO
- Alerts for IBM i System Limits
- SYSTOOLS.FIRMWARE_CURRENCY
Db2 for i - Services (new)
- QSYS2.ADD_QUERY_THRESHOLD
- QSYS2.END_IDLE_SQE_THREADS
- QSYS2.QUERY_SUPERVISOR
- QSYS2.REMOVE_QUERY_THRESHOLD
Db2 for i - Services (enhanced)
- %LOWER and %UPPER built-in functions convert to lower or upper case
- %SPLIT built-in function to split a string into an array
- New option, EXPROPTS(*STRICTKEYS), disallows search arguments that might overflow or be truncated, for keyed operations using %KDS or a list of keys
- All SQL warnings encountered during results retrieval are now posted to the Messages tab
- A Refresh list... option has been added to Database drop-down on the Connection->Connect to Database... dialog
- Descriptions for JDBC configurations are displayed as hover text on the Connection->Connect to Database... dialog and Connection->Apply JDBC Configuration menu
- Data mapping errors in results are now displayed as "++++++++++++"
- Additional Insert from Examples
- A new option on Generate SQL allows constraints to be defined in the CREATE TABLE statement instead of a separate ALTER TABLE statement
- Advised Indexes now combines multiple CREATE INDEX statements into a single Run SQL Scripts window
- Actions for Delete, Hold, and Release can be monitored in Active Tasks Pane
- Allow target address in lower right corner to be copied so it can be pasted
- Warn user when logging in if caps lock is on
Save/Restore Enhancement
Hardware and Firmware
|
BRMS for i (5770-BR1)
BRMS for IBM i 7.3 and later has several enhancements.
- New SQL services that provide similar views of BRMS log information as those provided by the DSPLOGBRM command.
- BRMS network sync job improves performance by reducing the number of journal entries processed.
- Improved cloud support for Network Installations using Network File Systems.
- Integrated support for full system backups using IBM i iSCSI supported devices.
For BRMS IBM i 7.3, these enhancements are available with PTF SI74478.
PowerHA SystemMirror for i (5770-HAS)
In this technology refresh, PowerHA a SystemMirror for i brings a new set of enhancements centered around switchover, automation, and simplification.
Streamlined switchovers
PowerHA continues to provide simple and easy switchovers. The latest enhancements provide simplified node selection with automated recovery domain management.
FlashCopy® automation
The integration of IBM FlashSystem® FlashCopy technologies are enhanced with integrated automation to simplify FlashCopy operations. Previously, FlashCopy operations required externally developed tools and scripts that performed multi-node operations.
Additional enhancements
PowerHA SystemMirror for IBM i 7.3 offers the following additional enhancements, including:
- Continued simplified management of PowerHA with interactive prompting
- Additional simplified commands that provide contextual F4 prompt options that are optimized for a specific environment and configuration.
For more information on these enhancements and to get started, see the IBM PowerHA SystemMirror for i wiki page.
The PowerHA enhancements will be available on June 25, 2021.
Was this topic helpful?
Document Information
Modified date:
27 April 2024
UID
ibm16405636