News
Abstract
IBM i 7.2 - TR5 Enhancements
Content
The remainder of this landing page intends to make it easy to see the supporting detail these enhancements.
Db2 for i Enhancements
Db2 for i - Functional Enhancements
- JSON_TABLE() table function
- Enhanced INCLUDE SQL statement
- Add BINDOPT and INCFILE to SET OPTION
- Add PERCENT_RANK as an ordered OLAP specification
- Enhanced QSYS2.SYSPARTITIONSTAT catalog
- Enhanced REPLACE() scalar Built-in function
- Debugger enhanced for SQL procedures, functions and triggers
Db2 for i - Performance Enhancements
- Improved Inlining support for SQL Scalar User Defined Functions (UDFs)
- Statement deterministic functions
- Faster implementation of the following Built-in Scalar functions:
- LPAD
- RPAD
- Faster implementation of the following Db2 for i catalogs (views):
- QSYS2.OBJECT_LOCK_INFO
- QSYS2.SYSPROGRAMSTAT
- QSYS2.SYSPROGRAMSTMTSTAT
- QSYS2.OUTPUT_QUEUE_ENTRIES
- QSYS2.OUTPUT_QUEUE_INFO
Db2 for i Services (new)
IBM i Services (new and enhanced)
- QSYS2.HISTORY_LOG_INFO()
- QSYS2.JOB_INFO()
- SYSTOOLS.GROUP_PTF_CURRENCY
- SYSTOOLS.GROUP_PTF_DETAILS
- QSYS2.OBJECT_STATISTICS()
- QSYS2.GET_JOB_INFO()
- QSYS2.DISPLAY_JOURNAL()
PowerHA SystemMirror for i
- Support for IBM SVC and IBM Storwize HyperSwap
- New HMC interfaces for Advanced Cluster Node Failure Detection
Hardware
Platform
- IBM Power S822 Model 8284-22A increases max cores
- NovaLink support for SR-IOV configurations
I/O
- #ESLS - EXP24SX SAS Storage Enclosure
- #EJ32, #EJ33 - PCIe3 Crypto Coprocessor 4767
- #EC3M, #EC3L - PCIe3 2-port 100 GbE
- #EUA3 - RDX USB Top Mount Docking Station
- Tape Library TS4500 R3
Virtualization
- vNIC fail-over
- Shared Ethernet Adapter (SEA) large send
Functional Enhancements
- Containers make USB Flash and RDX look like a stack of DVDs
- New format for tape volume statistics
- Identifying a partition with a UUID
Application Development
RPG - Unicode Source
- Compile RPG from Unicode - New TGTCCSID parm for CRTBNDRPG & CRTRPGMOD
Rational Developer for i - V9.5.1
- Mac support
- Kerbrose - Single SignOn
- ILE RPG Outline subset to referenced variables
- ILE RPG live model improvements
- IFS synchronization support for local projects
- Run SQL Queries from RDi, now with Formatter!
- Visual Explain
- Improved Spool File support
- Block nesting shows containing Procedure / Subroutine
- EGit plugin support - Easy integration with Git for source control
Integrated Web Services Server
Swagger support to describe REST Web Services
IBM i HTTP Server (Powered by Apache) 5770-DG1
Updates to the Apache 2.4.20 level
WebSphere Application Server V9
The latest Java EE7 support for WAS
Open Source
- Perl - Being added to Option 7 of 5733OPS (being delivered before End of December)
- Node.JS V6 being delivered in Option 10 of 5733OPS (being delivered before End of December)
Open Source for the RPG Programmer. The new OSSILE Git Hub repository is for RPG programmers to share with the IBM i RPG community code that has saved them time, improved their programs, or source that they feel will be a benefit to other in the IBM i RPG Community. OSSILE Git Hub Location
Systems Management
PowerVC for i
The new version of PowerVC for i includes multiple enhancements.
Access Client Solutions
The M6 version of ACS includes a wealth of updates for the Database Engineer
IBM Cloud Storage Solutions
Cloud Storage Solution for i is an API that enables deployment of IBM i data to a public cloud
Was this topic helpful?
Document Information
Modified date:
27 April 2024
UID
ibm11274236