• 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

• How IBM Improved The Database With IBM i 7.6

  April 28, 2025 Alex Woodie

  Developers have a host of new database functions to play with in IBM i 7.6 and 7.5 TR6, not the least of which is the new data change table reference functions. In addition to that big new feature, IBM is bringing updates to SELF, enhancements to parallel execution of SQL statements, and 10 new IBM i services, among others.

  The Db2 for i database is the beating heart of the IBM i platform, storing, processing, and serving data to all of the IBM i applications. While other databases are available on the platform (MySQL, MariaDB, and Postgres) through the AIX …

  Read more

• Rocket Celebrates 35th Anniversary As Private Equity Owner Ponders Sale

  April 28, 2025 Alex Woodie

  Rocket Software has come a long way since Andy Youniss and Johan Magnusson Gedda founded the company in Youniss’ Boston garage in 1990. Today the company counts more than 12,000 customers, including a large number of IBM i shops, and reportedly has a valuation of around $10 billion. Could the company’s 35th anniversary of its founding be a good time for its current majority owner, Bain Capital, to sell?

  Youniss started building what we now think of as Rocket Software in 2000, when he completed the first of what would become dozens of acquisitions. Over the years, there would be …

  Read more

• The New Capabilities IBM Added To Navigator For i

  April 23, 2025 Alex Woodie

  The addition of multi-factor authentication (MFA) to IBM i 7.6 is the big news with the recent operating system update from IBM. But IBM has introduced new capabilities to other parts of the platform as well, and some of the biggest reside in Navigator for i.

  As the strategic Web-based console for administrating the IBM i server, it’s natural that Navigator for i gets lots of attention. Whether you’re looking to monitor or manage the databases, inspect batch jobs, configure security, or monitor performance, Navigator for i is the one central place that lets you do it. You can, of …

  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

• The Top Ten IBM i Requests From The IBM Ideas Portal

  April 2, 2025 Alex Woodie

  Big Blue is gearing up for a major new release of the IBM i operating system. We don’t know yet what will be in the release, but we can forge some guesses by checking out what new features the IBM i community is requesting through the IBM Ideas portal, and how IBM reacts to them.

  IBM prides itself on being a customer-focused organization, and so it looks to the IBM i community for direction on what sort of features, capabilities, and fixes the IBM i community currently is looking for. That community outreach takes various forms, including the COMMON Americas …

  Read more

• Is IBM i Ready for the Agentic AI Revolution?

  March 24, 2025 Alex Woodie

  The AI world moves fast. Just when you get your head around large language models (LLMs) and the chatbots and coding co-pilots they enable, the AI world has moved onto something new. In 2025, that something new is the reasoning model, which is enabling autonomous AI agents and the world of agentic AI.

  Is IBM i ready for the revolution that’s about to unfold?

  By now you have undoubtedly read about LLMs such as OpenAI’s ChatGPT, Google’s Gemini, and Meta’s Llama. These LLMs are popular ways to power text-based generative AI applications, such as chatbots, coding co-pilots, and question-and-answer …

  Read more

• Fresche Makes Moves In The Cloud

  March 24, 2025 Alex Woodie

  Fresche Solutions is well known for IBM i application modernization, a line of business in which it has been successful for many decades. Thanks to its acquisition of OmniData Insights and a new partnership with IBM, the company is launching new ventures in the cloud.

  In early March, Fresche Solutions announced a partnership with IBM that will see Fresche managing IBM Power Virtual Server (PowerVS) customers. PowerVS is IBM’s cloud offering, and gives customers the capability to run IBM i, AIX, or Linux operating systems either in IBM datacenters or its partners’ datacenters. The deal with IBM means that Fresche …

  Read more

• Guru: Creating An RPG Stored Procedure That Returns A Result Set

  March 17, 2025 Mike Larsen

  In the previous article, I showed how to create an RPG stored procedure that uses parameters. In this article, I’m going to show how to create an RPG stored procedure that returns a result set, as we would likely encounter this scenario more frequently. The data used in this example comes from the Department table from IBM’s Sample database.

  I created an RPG program (Figure 1) that selects all rows from the Departments table. I didn’t add any selection criteria as I know there aren’t many rows in the table, but you may want to limit the number of rows …

  Read more

• Rocket CDC Tool Pushes Data Out Of IBM i

  March 10, 2025 Alex Woodie

  IBM i shops that need a change data capture (CDC) tool to push Db2 data off the box onto a target system, such as an Apache Kafka stream, may want to check out the new DataEdge product that Rocket Software recently announced.

  In late January, Rocket Software unveiled DataEdge, a new suite that provides a spectrum of data integration, data discovery, and data virtualization capabilities under the specific product names Rocket Data Replicate & Sync, Rocket Data Intelligence, and Rocket Data Virtualization. Some of the components in DataEdge are preexisting, while others – such as the outbound IBM i CDC …

  Read more

Previous Articles Next Articles