• GiAPA Tracks SQL Performance Issues On IBM i

  March 16, 2026 Alex Woodie

  Tracking down SQL performance problems with IBM i applications sometimes can be difficult, thanks to the mysterious ways that IBM’s Db2 query optimizer works. To help shine a light on changes the optimizer may suddenly make to query access plans, the IBM i performance experts behind GiAPA developed a new tool, dubbed SQL Observer.

  The Db2 query optimizer is a wonder of software engineering. The IBMers who developed it deserve a ton of credit for creating a smart piece of software that keeps SQL queries running so efficiently. Users simply submit the query they want to run, and the …

  Read more

• IBM Launches Hybrid Cloud Backup Product With Cobalt Iron

  March 9, 2026 Alex Woodie

  IBM and its business partner Cobalt Iron last week announced the launch of a new cloud backup product. Dubbed Secure Automated Backup with Compass for IBM Cloud, the new SaaS offering can protect data residing across customers’ landscape, including IBM Cloud, other clouds, and on-prem systems like IBM i.

  Cobalt Iron was founded in 2013 with the goal of modernizing backup and recovery. Founder Richard Spurlock saw that companies were spending too much time with platform-specific backup products, so he decided to build a centralized virtual tape library (VTL) solution that could back up and recover data across a range …

  Read more

• 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

• Why The IBM i Market Needed Another VTL Option

  November 3, 2025 Greg Tevis

  Over many decades now, the IBM i community of software vendors has done a great job coming up with new ways to extend and improve the systems that IBM has built for midrange customers. But every once in a while, a new idea comes into the IBM i community from the outside.

  So it is with Compass Tape Gateway from Cobalt Iron, which modernizes IBM i backup by replacing traditional VTL complexity with an automated, software‑defined experience. It treats IBM i as a first‑class part of enterprise data protection – not a silo – so teams get simpler operations, …

  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

• IBM Streamlines Data Migration With New Partition Mirror Tech

  July 28, 2025 Alex Woodie

  There is a brand new technology available for migrating data from one IBM i partition to another as part of IBM’s new Migrate While Active tool. It’s called partition mirror, and it gives IBM i shops a potentially less disruptive method for moving data across distances both long and short.

  IBM first unveiled its new Migrate While Active product in October 2024 as part of its announcement introducing subscriptions for the PowerHA high availability and Db2 Mirror continuous availability products. The co-mingling of the announcements made some sense when you consider that the original Migrate While Active product utilized a …

  Read more

• Profound Logic Adds MCP To IBM i AI Tool

  July 28, 2025 Alex Woodie

  The world of AI is moving extremely fast right now, with new models, techniques, and technologies emerging every week. One of the newest bits of AI tech to catch on is Anthropic’s Model Context Protocol (MCP), which has quickly become a defacto standard for connecting data sources to AI models. Profound Logic, which has been on the cutting edge of AI, is the first IBM i vendor to bring MCP support to the server and the Db2 for i database.

  Anthropic quietly launched Model Context Protocol in late November 2024 as a way to enable large language models (LLMs), such …

  Read more

• Say Goodbye To Downtime: Update Your Database Without Taking Your Business Offline

  May 5, 2025 Donna Westmoreland

  Downtime is costly, impacting productivity, revenue, and customer trust. For retailers and financial institutions, even a few minutes can mean significant losses. This is why enterprises rely on IBM i Db2 for mission-critical systems. IBM i offers 99.999 percent availability, high stability, robust failover strategies, and real-time monitoring to reduce unplanned downtime.

  However, planned downtime for critical updates and projects is also necessary. The challenge lies in scheduling this maintenance and upgrades without disrupting business applications. So, how can we utilize new functionality and optimize systems with minimal disruption?

  Database File Updates

  It is not surprising that businesses tend to …

  Read more

• i-Rays Brings Observability To IBM i Performance Problems

  May 5, 2025 Alex Woodie

  One of the new IBM i products that POWERUp 2025 attendees will get to check out later this month is i-Rays. Developed by the Polish software company Omnilogy, i-Rays is an observability tool that helps customers to detect performance issues with their IBM i server, investigate the causes, and then get a machine learning-based recommendation on how to fix it.

  Performance issues are rare on the IBM i, which is generally a tireless transactional workhorse, but they can happen. When legitimate performance problems do crop up, it can be difficult to track down the source of the problem unless you …

  Read more

• 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

Previous Articles