SQL Archives - Page 3 of 40

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
IBM Pulls The Curtain Back A Smidge On Project Bob

October 20, 2025 Alex Woodie

We learned last week that Project Bob is in at IBM, and Watson Code Assist for IBM i is out. IBM is gung-ho about the prospects for Bob to function as a do-it-all, AI-powered junior programmer for all of its platforms. But what exactly does this entail for IBM i customers? IT Jungle talked to IBM i chief architect Steve Will to get some answers.

When IBM eventually ships the AI code assistant that is currently called Project Bob, it will offer a range of AI-powered functionality for all IBM customers, including IBM i shops, mainframe customers, and Linux and …
Read more
IBM Just Killed Merlin. Here’s Why

October 20, 2025 Alex Woodie

The writing had been on the wall for some time, and IBM finally made it official as part of the Technology Refresh for IBM i on October 7. That was when Big Blue announced the immediate withdrawal from marketing and service for its Modernization Engine for Lifecycle Integration product, commonly called Merlin. It will likely go down in IBM i history as a well-intentioned product that got some things right, but which ultimately could not overcome its flaws.

The introduction of Merlin back in May 2022 represented a sizable shift in IBM’s approach to application development on IBM i. Prior …
Read more
What You Will Find In IBM i 7.6 TR1 and IBM i 7.5 TR7

October 13, 2025 Alex Woodie

It’s early October, which means leaves are changing colors, nights are getting colder, and IBM developers in southern Minnesota and elsewhere are gearing up the autumnal Technology Refreshes for the IBM i operating system.

With last week’s announcements of TR1 for IBM i 7.6 and TR7 for IBM i 7.5, which ship November 21, IBM has committed to delivering a slew of updates and new functionality across the range of IBM i system software, from application development to administration.

Before we get into the specific areas of IBM i, let’s cover the general enhancements it made with I/O handling. For …
Read more
Three Things For IBM i Shops To Consider About DevSecOps

October 13, 2025 Michel Mouchon

Way back in the Great Recession, when money was getting tight and the technical debt was getting high, the concept of agile infrastructure evolved into DevOps, the synchronization and coordination of application development, which likes to move fast, with IT operations, which likes to have things running in a stable fashion. The idea runs counter to half of the philosophy of Facebook founder Mark Zuckerberg, who has espoused the principle to “move fast and break things.”

DevOps wants to move fast, but it most assuredly does not want to break things, and many millions of programmers and operations staff …
Read more
Big Blue Boosts IBM i Support In Instana, Adds Tracing

October 6, 2025 Alex Woodie

IBM i shops that need more insight into how their hardware and software is running may want to consider IBM’s Instana software. IBM has been investing in the observability tool, which was recently updated to support traces on IBM i systems. That’s one of several upgrades IBM has made to Instana to help its IBM i customers.

IBM acquired Instana back in November 2020 to bolster its presence in the nascent observability arena, particularly as it related to monitoring cloud-native environments (i.e., those using Kubernetes and microservices). Big Blue had just spent $34 billion to buy Red Hat and its …
Read more
Stelo Touts Data Replication For IBM i In Azure Cloud

September 29, 2025 Alex Woodie

If you are in the market for data replication software for IBM i, you might want to check out Stelo (formerly StarQuest). The company has supported the IBM i server for many years, and recently announced that its software is available on the Microsoft Azure Marketplace.

Stelo got its start back in 1992, when Paul Rampel founded StarQuest to develop data connectivity tools for IBM, Microsoft, and Cisco Systems environments. The company launched the Host Data Replicator (HDR) product in 1998, when was adapted with real-time capabilities to become the StarQuest Data Replicator (SQDR) product in 2001.

In 2022, StarQuest …
Read more

Previous Articles Next Articles

Content archive

Recent Posts

Subscribe

Pages

Search