SQL Archives - Page 2 of 39

IBM Unveils Expert Query To Replace Db2 Web Query

February 16, 2026 Alex Woodie

IBM’s Technology Expert Labs is launching IBM Database Expert Query for i, a new tool that allows users to create and run reports against the integrated Db2 for i database from the comfort of a Web browser. IBM is positioning Expert Query as a replacement for Db2 Web Query, the business intelligence and analytics tool that it abruptly killed more than two years ago.

Expert Query was developed over the past year by Technology Expert Labs (formerly Lab Services). We have heard rumblings that Big Blue was gearing up a replacement for the well-liked Db2 Web Query product, and it …
Read more
Guru: Access Client Solutions 1.1.9.11 – Security First, With Continued Investment In SQL Tooling

January 26, 2026 Gregory Simmons

Big Blue has released IBM i Access Client Solutions (ACS) version 1.1.9.11, and while the release is anchored by an important security fix, it also reflects IBM’s continued investment in the SQL tooling that has become central to day-to-day IBM i development and administration. This is not a feature-heavy update on its own, but it arrives after a series of releases that have steadily expanded the usefulness of both Run SQL Scripts and SQL Performance Center.

The primary driver for upgrading to ACS 1.1.9.11 is the remediation of CVE-2025-66516, an XML External Entity vulnerability related to how ACS processes certain …
Read more
Profound Says New Agentic AI Dev Tool Delivers Huge Productivity Boost

January 19, 2026 Alex Woodie

Profound Logic is rolling out a new AI-powered development tool that it says will increase the productivity of individual developers by five to 10 times. Dubbed CoderFlow, the software coordinates the work of multiple AI agents to assist with the development new IBM i applications or the maintenance and modernization of existing ones.

Existing AI copilots provide some productivity gains for developers working in an IDE, somewhere around 20 percent, according to Profound Logic chief executive officer Alex Roytman. But CoderFlow is a different type of product. It is not a coding co-pilot, he said. Instead it is a framework …
Read more
Learning And Laughing With Scott Forstie And Tim Rowe

December 8, 2025 Alex Woodie

In the darkest days of the 2020 pandemic, with COVID lockdowns in full force, IBM i business architects Tim Rowe and Scott Forstie decided to try something new: start a video blog. Dubbed iSee, the short videos blend serious technical content around ACS and SQL services with goofy puns and silly drawings. Fast forward to fall 2025, and iSee is going strong, as the pair recently aired their 100th iSee episode.

“Scott and I have been thinking about some fun things that we want to talk about to help you in your every day job,” Rowe said in the very …
Read more
Guru: A First Look at Bob, The IBM i Assistant That’s Closer Than You Think

December 8, 2025 Gregory Simmons

I recently was granted early access to IBM’s new Project Bob, and I have been putting the Bob-IDE through its paces to understand what IBM is aiming for and what IBM i developers should expect as the offering matures. Bob is IBM’s emerging AI-powered development assistant and IDE ecosystem designed to modernize how developers work on the IBM i.

One of the first things that stands out is that the Bob-IDE is not an extension like the older WCA4i project, which was in extension form. IBM learned a lot from that experience, and those lessons led them to take a …
Read more
Bob More Than Just A Code Assistant, IBM i Chief Architect Will Says

December 1, 2025 Alex Woodie

When IBM i professionals finally get their hands on Bob, the new AI-powered tool currently in development in Big Blue’s labs, they will find that it is much more than just a code assistant, IBM i chief Architect Steve Will said recently. “It has a lot of knowledge,” he said. “It knows things about IBM i.”

While precise details about the timing of the release of Bob are slim, IBM is widely expected to release a public preview of the new AI-powered plug-in for VS Code in early 2026. The new software, which was unveiled in early October around the …
Read more
IBM i PTF Guide, Volume 27, Number 47

December 1, 2025 Doug Bidwell

We start this week with performance anxiety. Well, more like performance degradation. As you will see at this link, if you have installed IBM i 7.4 TR12 or IBM i 7.5 TR7, SQL query plans might be spending more time waiting for I/O pending faults and therefore are performing poorly. There are actually two different but related issues and two different fixes that resolve this issue.

This week, there is also a security vulnerability. See Security Bulletin: IBM i is affected by obtaining information without proper authority [CVE-2025-36371], with more information available here. The fixes for this vulnerability, …
Read more
Stacking Up Power10 And Power11 Systems Price/Performance

November 17, 2025 Timothy Prickett Morgan

We have been on the hunt to get you pricing on entry Power11 machines in the P10 and P20 IBM i software tiers to give you a sense of the relative price/performance of the Power11 machines compared to their Power10 predecessors. There are dozens of possible configurations of entry, midrange, and enterprise machines in these two families, and without an official and public price list, as Big Blue provided for many years, it is very difficult for even business partners to get pricing.

In fact, they need to use IBM’s official configurator, and they need to have a Power System …
Read more
IBM i PTF Guide, Volume 27, Number 44

November 3, 2025 Doug Bidwell

Welcome to the IBM i PTF Guide, we start out this week with a security vulnerability. Specifically, we have Security Bulletin: IBM i is affected by a privilege escalation in IBM i SQL services [CVE-2025-36367], about which you can find out more at this link. IBM strongly recommends addressing the vulnerability now, with the following patches:
```
IBM i Release	5770-SS1	PTF Number(s)
7.6			        SJ07552
			        SJ07650
			        SJ07651
			        SJ07652	
7.5			        SJ07553
			        SJ07653
			        SJ07654
			        SJ07655	
7.4			        SJ07554
			        SJ07656
			        SJ07657
			        SJ07658	
7.3			        SJ07555
			        SJ07659
			        SJ07660
			        SJ07661	
7.2			        SJ07556
			        SJ07662
			        SJ07663
			        SJ07664 
```
And now, for downloads and drivers: Upcoming Migration of Secure File Transfer …
Read more
Beta Of MCP Server Opens Up IBM i For Agentic AI

October 27, 2025 Alex Woodie

When Anthropic quietly released Model Context Protocol (MCP) in November 2024, it didn’t garner a whole lot attention. But as the agentic AI wave grew in early 2025, the protocol suddenly was hailed as the new standard for integrating AI applications, tools, and data sources. A good indication of just how far MCP has come is the fact that IBM released an early version of the MCP server for IBM i this month.

Project Bob got the big headlines at the IBM TechXchange conference, which took place the second week of October in Orlando, Florida. And for good reason, as …
Read more

Previous Articles Next Articles

Content archive

Recent Posts

Subscribe

Pages

Search