DB2 for i is the first DB2 Family member to add JSON_TABLE() to its SQL language support. Why did DB2 for i add JSON_TABLE() ? Because JSON is a pervasive data transport technology and like XML, customers can benefit from using a standards based, SQL Query Engine-centric solution.
Posted: January 03, 2017 |
New with the 7.3 release is the ability to automatically download PTF groups to your IBM i partition. The PTFs are downloaded in save files and stored on your system, ready to be installed. This enhancement was requested by requirements received through the COMMON Americas and COMMON Europe Advisory Councils.
Posted: December 07, 2016 |
In last week’s blog, Displaying Open Files with Work Job, I described how you can customize the information that is displayed with Work Job, option 14 (display open files).
Posted: November 22, 2016 |
While I was at the Power Systems Technical University in London a couple of weeks ago, a conference attendee in my work management presentation asked me this question: “How do I make WRKJOB, option 14 (display open files), display the I/O information rather than the activation group information? I always have to press F11 to see the I/O details.”
Posted: November 14, 2016 |
In release IBM i 7.1 and later, IBM Backup, Recovery and Media Services for i (BRMS)
has been enhanced to support the transfer of virtual save media from image catalogs to/from the cloud using product 5733ICC - Cloud Storage Solutions for i.
Cloud Storage Solutions for i allows cloud connector resources to be defined for cloud storage providers such as IBM's SoftLayer and for private interfaces such as file transfer protocol (FTP).
Posted: October 27, 2016 |
IBM i 7.3 Technology Refresh 1 has been announced. Steve Will has written about the announcement in general on his You and i blog. IBM i 7.2 Technology Refresh 5 was also announced.
Posted: October 11, 2016 |
When you sign in to Navigator for i on a partition that is running the 7.3 release, you will discover the welcome page is no longer displayed; rather you will see the dashboard. The dashboard consists of six graphs that are updated in real time, providing a quick overview of the health and status of your IBM i partition.
Posted: October 03, 2016 |
In the 7.3 release, IBM added a new parameter to the End Job Abnormal (ENDJOBABN) command.
Posted: September 20, 2016 |
Recently I wrote about IBM i 7.3 System Monitor Enhancements and mentioned the default monitor collection interval was changed to 60 seconds. On the 7.2 release, the default collection interval was 15 seconds; IBM has recently changed the default on 7.2 to 60 seconds. For this change, you will need the Navigator service pack that was made available this past June. You can find the details of the required PTFs and PTF Groups on the developerWorks page for Navigator PTFs.
Posted: September 08, 2016 |
System Monitor support was added to Navigator with the 7.2 release. Navigator system monitors are similar to Management Central system monitors—they allow you to monitor a set of metrics in real time with the option to set thresholds and define actions to take when those thresholds are hit. However, system monitor support in 7.2 had limited ability to visualize metrics.
Posted: August 17, 2016 |