News
Abstract
IBM i 7.2 - TR9 Enhancements
Content
The remainder of this landing page intends to make it easy to see the supporting detail for these enhancements, and more.
Hardware
Platform
- IBM Power E980 model 9080-M9S - IBM i native and VIOS configurations
I/O
- #EC67 - PCIe4 2-port LP 100 Gb ROCE EN adapter (VIOS NIC only)
- 931 GB / 1.86 TB / 3.72 TB SAS 4k SFF-3 and SFF-2 Mainstream SAS SSDs
Functional Enhancements
- Unmap for IBM Spectrum Virtualize configurations
- SAN Multipath Support for Tape Drives - Extended to additional tape drives
Db2 for i Enhancements |
Db2 for i - Functional Enhancements
- JTOpen JDBC driver – Alternate Server Support
- SQL Precompiler SQL0312 and SQL5011 message enhancements
- Optional parameter support for External procedures and functions
- JSON - Uniqueness controls for Key names
- Table correlation name enhanced to be optional
- DECFLOAT_FORMAT() built-in function
- NOW() built-in function enhanced
- EXTRACT() built-in function enhanced
- VARCHAR_FORMAT() and TO_CHAR() built-in functions enhanced
Db2 for i - Performance Enhancements
- Implicit parameter marker conversion on some data-change-table-references
- Improved code generation for SQL procedures, functions, & triggers
Db2 for i - Database Management Enhancements
- QSYS2.GENERATE_SQL_OBJECTS() procedure
- QSYS2.SYSPARTITIONSTAT enhancement
- QSYS2.PARSE_STATEMENT() table function enhancement
IBM i Services (new and enhanced)
- QSYS2.ACTIVE_JOB_INFO()
- QSYS2.JOB_DESCRIPTION_INFO
- QSYS2.NETSTAT_INFO
- QSYS2.NETSTAT_JOB_INFO
- QSYS2.OUTPUT_QUEUE_ENTRIES_BASIC
Db2 for i - Services (new and enhanced)
- QSYS2.GENERATE_SQL_OBJECTS() procedure
- QSYS2.SYSPARTITIONSTAT enhancement
- QSYS2.PARSE_STATEMENT() table function enhancement
OmniFind for IBM i
Db2 Web Query V2.2.1
-
EZ-Install Enhanced: ibm.biz/db2wqezinstall
Rational Developer for i
RDi 9.6.0.4
Big News... RDi Trial period has now been extended to 120 days. Great for students just learning!
Many new features to help both the experienced RDi developer as well as the 'PDM' user transition.
PDM comes to RDi - all the comfort and muscle memory you have been using with the old SEU/PDM interface is now part of RDi.
- All the same key commands
- Function keys
- Power filtering
- Searching
- BUT now with the power and enhanced productivity that RDi includes
Details on all that has been added as well as details on how to obtain can be found at the RDi Developer Hub - RDi Developer Hub. Fixes and updates can be found on the RDi Service Support page.
The strategic interface for Accessing, Managing your IBM i and the database continues to improve. Based on the input from our user community as well as working to finish closing any remains gaps as we continue the transition from the iAccess for Windows solution to ACS.
ODBC Driver NOW available on ACS download page!
The ODBC (and .net) drivers for Windows and Linux are now available on the ACS Download page. No longer do you need to go to ESS. Simple and easy. Use the short URL -http://ibm.biz/IBMi_ACS
Generate SQL Objects
-
Perfect order
Schemas
- Query in Run SQL Scripts
- View Journal Entries
- Locks (Alias/Index/Table/View)
- Transactions
- Index and MQT Partition Lists
- Locked Rows
Run SQL Scripts
- More Insert from Examples
Open Source Package Manager
- Interface to view and manage the RPM distributions on your IBM i.
5250 Java Print Services
- Updates to the 5250 print support to provide a better native printing option.
Integrated File System - Permissions Enhancements
- From the IFS interface you can now view and update the specific authorities for each directory and file.
Open Source
Open Source delivery mechanism and schedules
Open source technologies are not delivered as part of the technology refresh package. Instead, they are continuously delivered as they become available. All open source features covered here are already available, with the exception of TLS 1.3 support, which is only available in draft form, currently. Also, none of these functions are delivered via an installed product or PTFs (see the next section regarding RPM-based deliveries).
RPM-based deliveries and package manager
Many open source offerings are now available in RPM form. Large portions of the Linux community use RPM-based packages to distribute software. A package manager (yum) has also been delivered. With these changes, more open source technology can be made available, and the management and installation of these packages can be done in mere minutes.
Here are some examples of common tasks that can now be accomplished with the ‘yum’ command:
• yum list installed (list installed packages)
• yum list available (list available packages)
• yum list updates (list available updates to packages)
• yum install <package> (install a package)
• yum search <package> (search for a package)
For information on how to get started with these new RPM-based technologies, visit http://ibm.biz/ibmi-rpms
Language updates: Node.js version 8, Python version 3.6
TLS 1.3 support
As part of the RPM-based offering set, API’s and tools based on OpenSSL 1.1.1 are available. This brings TLS 1.3 capabilities to any technology that uses OpenSSL.
Also, the nginx HTTP server has been built to leverage OpenSSL 1.1.1 and therefore TLS 1.3. This allows nginx to be a TLS 1.3-capable front end to virtually any web workloads.
The ‘updatedb’ and ‘locate’ tools
As part of the RPM-based offering set, the `updated` and `locate` utilities are available. This allows for incredibly fast location of files on the system. The ‘updatedb’ command, when run, will populate a database with a list of files on the system. This takes several minutes and is often run on a nightly basis. Once the database is populated, the ‘locate’ command can quickly find files whose filename or directory contains a given string.
As part of the RPM-based offering set, GCC version 6.3.0 is available. Also, many tools that are often needed to build PASE or open source applications are also delivered. This includes autoconf, automake, pkg-config, cmake, libtool, m4, and many more.
LFTP
As part of the RPM-based offering set, the LFTP utility is now available. LFTP is a sophisticated file transfer program. While it can serve as a command-line FTP utility, it understands a number of protocols including ftp, sftp, http, and others. It comes with various features, such as the ability to create site mirrors or perform multiple tasks in parallel. GNU nano
As part of the RPM-based offering set, the ‘nano’ editor allows for easy editing of files within a terminal session. It supports several usability features like copy/paste and search/replace with regular expressions. It can also be extended to support syntax highlighting for several languages by running the following commands from an SSH terminal:
git clone https://github.com/scopatz/nanorc.git ~/.nano cat ~/.nano/nanorc >> ~/.nanorc
Other GNU Tools
As part of the RPM-based offering set, we have delivered industry-standard GNU forms of many common commands. Some examples would include:
• less
• grep
• ls
• awk
• sed
• find
• patch
• tar
• iconv
• sort
This allows for improved compatibility with scripts, documentation, or products in the open source community.
Was this topic helpful?
Document Information
Modified date:
27 April 2024
UID
ibm11171042