• 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

• Guru: Generate SQL for Dependents

  May 24, 2021 Paul Tuohy

  Way back in October 2014, in the article Find A View Of A View Of A View. . ., I detailed a stored procedure that, given the name of a table or a view, provides the full list of dependent views and all of their dependents and all of their dependents, etc. This is a stored procedure that has served me well in the world of DDL, where it is common to have views of views of views.

  In this article I will describe a follow-on stored procedure that will generate the DDL for a given table/view and all …

  Read more

• Thoroughly Modern: DevOps Refactoring Of RPG Applications with RDi

  January 11, 2021 Ray Everhart

  Regardless of your current situation – namely, the size and age of your codebase – there is great value to be gained from refactoring. In this article, I will explain what refactoring is, provide the business justification, and describe some refactoring best practices.

  So what is refactoring? In the strictest sense of the word, refactoring is when you improve the quality of code without changing what it does. Refactoring is not about enhancements or bug fixes, but code quality and making the code more efficient and maintainable. Code refactoring also improves readability, which makes QA and debugging go much more …

  Read more

• Db2 And SQL Services Get Upgrades With TRs

  October 12, 2020 Alex Woodie

  Among the biggest enhancements that IBM is bringing to IBM i with the latest batch of Technology Refreshes are new capabilities added to the integrated Db2 database and, specifically, the slew of SQL-based services that retrieve all types of data from the platform for IBM i professionals.

  As we previously told you, IBM has decided to rename SQL Services, which were the collection of pre-defined SQL queries that recreate traditional IBM i commands and sometimes bring something entirely new. The growing gaggle of services (or perhaps it’s a herd?) are now being officially referred to as IBM i services, …

  Read more

• Guru Classic: Find a View of a View of a View. . .

  February 5, 2020 Paul Tuohy

  Author’s Note: This article was originally published in October 2014. This stored procedure is something I use a lot and has saved me from accidentally deleting dependent views more than once. Basically, I call it before I ever drop a view.

  SQLs Data Definition Language (DDL) offers many great features, one of which is the ability to define a view of a view. This can lead to simple or complex structures making use of views of views of views of . . . you get the idea.

  But one of the difficulties with this technique is that, once created, it …

  Read more

• Thoroughly Modern: Taking The Pulse Of IBM i Developers

  January 22, 2020 Timothy Prickett Morgan

  It takes someone who has experience in application development to create and sell tools that help make a developer’s job easier. We think about the tool creators, but when it comes to getting people to adopt a new technology, the technical sales team at any software company is the bridge that connects developers of tools to the developer of applications who can be helped by those tools. In this edition of Thoroughly Modern, we are talking with Stephen Flaherty, a technical engineer at Fresche Solutions, about what IBM i developers are thinking about and doing today.

  Timothy Prickett Morgan: …

  Read more

• Industry Speaks: IBM i Predictions For 2020, Part 2

  January 22, 2020 Alex Woodie

  What will happen in the IBM i community in 2020? It’s a question that’s worth some speculation, particularly from members of the IBM i community who have given it some thought. Here is our second (and final) batch of community predictions for 2020.

  The IBM i platform has been chugging along for 32 years (or 40 if you count the S/38). Do you really think this will be the year that it goes kaput? Trevor Perry certainly doesn’t think so, and you probably shouldn’t, either.

  “There will be continued predictions of the demise of IBM i throughout 2020,” the IBM …

  Read more

• Need Help Approving A Modernization Project? Try A Business-Led Approach

  October 14, 2019 Ajay Gomez

  Getting momentum and buy-in for a modernization project can be tough. I’ve lived through this and fought the battle many times. What makes it difficult is that the problem is not obvious and needs to be explained to people outside of IT. For example, it’s not obvious to a business leader that RPG II code should be modernized to RPG ILE. In fact, if we were to modernize the underlying code without telling them, they wouldn’t notice a difference. The business doesn’t see the effects of modernization unless it’s UI modernization, which is why it’s tough to get buy-in.

  Interestingly …

  Read more

• TEMBO Bolsters Database Modernization Kit

  March 26, 2018 Alex Woodie

  TEMBO Technology Lab is shipping a new release of its software designed to help IBM i shops modernize their databases for the SQL age. The South African company made mostly minor tweaks to its flagship product, dubbed AO Foundation, which should position the product to do more down the road.

  Since it entered the IBM i discussion in 2012, TEMBO has been building database modernization tools and evangelizing the benefits of the SQL Query Engine (SQE) as the modern, up-to-date database engine that IBM i shops should strive to use, as opposed to the older CQE engine that used DDS …

  Read more

• IBM i Database Capabilities Highlight Midrange Dynamics’ Development Activity

  February 28, 2018 Dan Burger

  Despite the gravitational pull of a legacy reputation, development on IBM i systems continue to move into new arenas. Shops are modernizing their applications not just to eliminate green-screen displays but to also add features and functionality. Databases are being modernized for the same reasons. And tools that benefit the modernization process are being enhanced.

  Change management software (CMS) is in the thick of this. Michael Morgan, managing director of the CMS development company Midrange Dynamics, sees IBM i shops investing in new technologies. He’s doing the same to keep pace with the early adopters and to prepare for …

  Read more

Previous Articles