• Oft-Requested SQL Function Coming In IBM i 7.6

  April 8, 2025 Alex Woodie

  IBM i engineers and product managers have no shortage of feature requests to wade through, some of which make it into the platform and many of which do not. With the upcoming delivery of IBM i 7.6, IBM will be delivering one of the most often requested features: Support for UPDATE and DELETE statements in the data-change-table-reference clause of a SQL statement.

  While the capability to update and delete statements with data-change-table-reference may not sound like a big deal, it actually represents a significant improvement that will simplify database programming tasks for developers, according to Scott Forstie, IBM’s Db2 for …

  Read more

• Database Enhancements Galore In Spring 2024 IBM i TRs

  May 13, 2024 Alex Woodie

  The IBM i server is a database machine at the end of the day, so it’s not surprising that the latest technology refreshes (TRs) focus heavily on enhancements to Db2 for i. From new aggregate functions for the query optimizer to new and improved SQL-based IBM i services, there’s plenty of database goodness to go around in these releases.

  On May 7, IBM announced IBM i 7.5 TR4 and 7.4 TR10. You can read the announcement letters for the two releases here and here. The functionality for the two releases, which will become generally available on June 14, is …

  Read more

• Tech Refreshes Bring SQL-Based Services Galore For IBM i and Db2

  October 16, 2023 Alex Woodie

  With the latest Technology Refreshes, IBM unleashed another round of new and updated IBM i Services aimed simplifying life for administrators, developers, and other IBM i professionals. The company also refreshed its slate of Db2 for i Services.

  Over the past decade, IBM has been busy rejiggering how users interact with core components of the operating system. Instead of issuing traditional CL commands or working with low-level APIs, users can tap into new SQL-based IBM i services via Access Client Solutions (ACS) to accomplish the same tasks.

  Db2 for i Database Architect Scott Forstie and his team have created hundreds …

  Read more

• IBM i at 35: A Walk Down Memory Lane

  April 26, 2023 Alex Woodie

  You may have heard that the IBM midrange platform is turning 35 this year. IBM has a number of events planned in honor of that milestone, culminating with a big birthday bash on June 21. IBM execs gave us a sneak peak of the festivities to come at this week’s POWERUp show in Denver, as well as a technical look back at exactly how we got here.

  The day the AS/400 launched in 1988 was notable for several reasons. IBM i CTO Steve Will, who was just starting his distinguished engineering career at IBM, recalls lots of excitement in the …

  Read more

• What the Spring 2023 TR Brings Db2 for i

  April 26, 2023 Alex Woodie

  As the beating heart of the IBM i platform, the Db2 for i database received its share of attending from Rochester for the Spring 2023 Technology Refresh. Among the goodness becoming available next week are enhancements to the database proper as well as a gaggle of new and improved IBM i services.

  One database enhancement common to both IBM i 7.5 TR2 and 7.4 TR8 is an improvement to SQL-based Web services using specific data types. The database and its SQL dialect already supported working with character large object (CLOBs) from the SQL HTTP REST functions, and provided commands for …

  Read more

• IBM Publishes Power10 Performance Optimize Guide

  December 7, 2022 Alex Woodie

  IBM i shops looking to squeeze the most performance out of their Power10 servers have a lot of options available at their disposal. IBM covers many, if not all, of them in its latest performance paper, titled “IBM Power10 performance optimization for IBM i,” which it released last week.

  The Power10 is the most powerful processor IBM ever built. Compared to the Power9 processor, the Power10 delivers 20 percent to 30 percent higher performance per core. And with 25 percent more cores per socket, that means oodles of more processing power to do useful work.

  At a system level, the …

  Read more

• TRs Deliver Database and SQL Updates for Every IBM i User

  November 2, 2022 Alex Woodie

  When it comes to SQL services and database updates, there’s something for just about every IBM i user in 7.5 TR1 and 7.4 TR7. With dozens of new and enhanced database functions and SQL services, these TRs in fact may be the biggest releases ever, according to Scott Forstie, the Db2 for i architect at IBM.

  During a recent interview with IT Jungle about the new Watson geospatial capabilities that his team delivered in the database (which you can read about here), Forstie pondered the journey he and his team have been on, and how it’s culminated to this …

  Read more

• Database And Developer Enhancements In IBM i 7.5 And 7.4 TR6

  May 9, 2022 Alex Woodie

  IBM has made a number of enhancements to the Db2 for i database with the launch of IBM i 7.5, which becomes generally available tomorrow. It also is bringing new features for developers, including changes to Integrated Web Services (IWS), which will improve REST integration.

  Most of the new features added to Db2 for i are only available in IBM i 7.5, which will give users a reason to adopt it. However, there are a few enhancements added in IBM i 7.4 Technology Release 6, which doesn’t ship until May 24.

  As we previously reported, IBM i 7.5 expands …

  Read more

• Query Supervisor Gives Database Engineers New Power

  April 14, 2021 Alex Woodie

  One of the most exciting new features in the upcoming releases of IBM i 7.4 Technology Release (TR4) and 7.3 TR10 is the Query Supervisor. We recently caught up with Scott Forstie, IBM’s Db2 for i business architect, who gave us the low down on the new tech for controlling the database.

  Forstie told IT Jungle said that the Query Supervisor was the biggest new feature added to Db2 for i with IBM i 7.4 TR4 and 7.3 TR10, which IBM announced yesterday (see “IBM Unveils Spring 2021 Batch of TRs” for more news about the TRs).

  So, …

  Read more

• Big Blue Unveils Spring 2021 IBM i Technology Refreshes

  April 12, 2021 Alex Woodie

  IBM tomorrow will announce the latest round of Technology Refreshes (TRs) for the current versions of the operating systems. With IBM i 7.4 TR4 and 7.3 TR10, IBM is focusing its efforts on extending automation across various components of the operating system, including the database, security, and high availability. But a surprise also awaits IBM i enthusiasts who are visually inclined.

  IBM gave IT Jungle a preview of the announcements that will go public tomorrow, and (very kindly) gave us permission to cover them in today’s issue of The Four Hundred. That means that the announcement materials will not …

  Read more

Previous Articles