• What IBM’s Got Cooking In Db2 For i In The Summer TRs

  July 27, 2026 Alex Woodie

  Last week, IBM announced PTFs containing a slew of new Db2 for i features and enhancements as part of the Technology Refresh for IBM i 7.6 and 7.5. While the database is just a part of the story for IBM i 7.6 TR2 and 7.5 TR8, it’s a critical piece of the puzzle. Here’s a preview of the new stuff that you can now play with.

  As part of the summer TRs that we covered last week, IBM delivered five functional enhancements to Db2 for i as part of the Summer TR, shipped one security enhancement, one enhancement for …

  Read more

• Big Blue Finally Unveils First IBM i Tech Refreshes Of 2026

  July 20, 2026 Alex Woodie

  Well, that took a little longer than usual. Last week, IBM finally made its first IBM i Technology Refresh announcements of 2026, formally unveiling the group of updates that collectively will make up IBM i 7.6 TR2 and 7.5 TR8. With the fall TR ostensibly just three months away, the good news with the two new TRs is that the general availability date is this Friday.

  Since IBM moved to the TR cycle back in 2010, it has traditionally given the IBM i community two big updates per year, one in the spring (normally April) and one in the …

  Read more

• Guru: Analyzing User Session Statistics, Part 1

  July 20, 2026 Mike Larsen

  I wanted to report on user activity on our IBM i. Knowing that there is a wealth of SQL table functions available to me, I knew it wouldn’t be hard to find something that would help me. For this report, I wanted to see how many times a user logged into the system during a certain timeframe.

  The table function I used is QSYS2.HISTORY_LOG_INFO. I’ll show the code I built, followed by a breakdown of what is does.

  Here is the SQL statement to determine the number of times a user signed in:

  SELECT COUNT(DISTINCT DATE(MESSAGE_TIMESTAMP)) AS DAYS_LOGGED_IN
  FROM 

  …

  Read more

• Big Blue Ships Bob 2.0 And Premium Package For IBM i

  July 13, 2026 Alex Woodie

  IBM’s push into the world of agentic coding continues, as Big Blue officially started selling and supporting major updates to its Bob agentic AI software. There are two separate but related pieces of news to cover, including the release of IBM Bob Premium Package for i and the release of Bob 2.0.

  As it is wont to do, IBM generated some confusion with its Bob launches, as both Bob 2.0 and the Bob premium packages became available on the same day, June 24. However, Bob 2.0 and the Bob premium packages are not the same thing, and their announcements were …

  Read more

• Talking Git On IBM i With A Bunch Of IBM i Gits

  July 13, 2026 Timothy Prickett Morgan

  If there is someone on planet Earth who is most definitely not a git, it is Linux operating system kernel and Git version control system creator Linus Torvalds. The term git was absolutely meant to be pejorative, but it has softened over the years in part because Torvalds chose the name for his version control system precisely to mock himself. The meaning of git is shifting from incompetent senile fool toward curmudgeon and is heading toward old fart.

  Torvalds manages one of the largest software projects in the world, and in the early 2000s chose BitKeeper, a proprietary source …

  Read more

• AI Is Not Just For Developers, It Is For Everyone At Your Company

  June 22, 2026 Alan Ashley

  I’m not a developer. Let me say that upfront, because it matters when I say the things I’m about to say. I’ve always had ideas that I could put forth to somebody who can code. But now, because of AI, I can ask it to do things that I can verbally explain, and it can create what I am asking for. That’s one of the reasons I’m so excited about GenAI.

  Before the GenAI boom started a few years ago, at ARCAD we had already gone down this road with a product called Discover. We had already tied chat into …

  Read more

• Guru: Finding Data In The Forest – Exploring Three-Part Naming In SQL

  June 22, 2026 Gregory Simmons

  Anyone who has spent time foraging for mushrooms knows that location matters. A chanterelle found in the Pacific Northwest is not the same as one discovered in the hardwood forests of the Midwest. Experienced foragers do not simply note what they found. They record exactly where they found it: the region, the forest, and the specific location. Context matters.

  The same is true in SQL. Most IBM i developers are comfortable with two-part naming. A reference like MUSHLIB.FORAGE_LOG identifies both the schema and the object. It tells SQL where to look within a single system, much like noting the forest …

  Read more

• GenAI Is The Death Of Deterministic Project Budgeting

  June 15, 2026 Dan Darnell and Eric Whitcomb

  Like many of you in the IBM i community, we have been treading the AI waters for a couple of years now, starting with small proof-of-concept applications such as chatbots but progressing to far more advanced and complex code-to-AI interfaces.

  One such project leveraged AI for recurring Jaccard similarity index processing over large sets of business data. The small projects fool a person into thinking that the large projects are just more of the same but, in reality, large projects take you into the world of proprietary AI APIs and can be complex engineering efforts.

  We mostly use ChatGPT because …

  Read more

• PTC Adds Support For VS Code With Implementer 12.7

  June 15, 2026 Alex Woodie

  IBM i shops that rely on PTC’s Implementer software to manage their RPG development will soon be able to use the tool within the VS Code development environment. The upcoming release of Implementer 12.7 will introduce several other important features as PTC begins the process of modernizing the tool.

  Implementer is a well-established change management system targeting the IBM i environment. The software traces its roots to 1987, when four Pansophic (creators of the PRMS ERP system now owned by Infor) employees founded Silvon Software in Chicago. One of their first products was a tool to manage source code …

  Read more

• Guru: Where’s The Table?

  June 8, 2026 Ted Holt

  It began with an irritation. I considered it a simple request. “Which file did my SQL query read?” I was using the Run SQL Scripts tool to modify an SQL query with unqualified table names. And yet I knew of no ready way to determine the schema (library) name of any of the files. How was I to know which tables I had just queried?

  Let me back up a bit. My SQL client of choice is the Run SQL Scripts tool, which is part of IBM’s Access Client Solutions (ACS). It is not unusual for me to copy and …

  Read more

Previous Articles