COMMON POWERUp 2026

You hear modern RPG but, what does that actually mean? we will look at converting from monolithic programs to modular programming including the use of service program and converting RLA(Record level access) to sql.

Learning Objectives:

Understanding what modern RPG means Understanding of what needs to be done to implement modern RPG.

Learn to think like a spy! Many shops use journaling for a variety of reasons, but may not be familiar with how to use these journals for forensic purposes. Mining your journals for the who, what, when, where, how - and sometimes even why - can be very useful, not to mention fun! Come join us for a lighthearted and entertaining "Mission: Impossible" themed look at one of the most useful things you can do with your journals. This session will introduce journaling concepts and share tuning tips to optimize your journal environment for forensics. After reviewing the "old fashioned" way to dig into your journals, we will demonstrate how much easier this is with the right tools. The DMPJRN and CVTJRNDTA commands used in this presentation will be made available as a free download to all attendees, including source code!

Learning Objectives:

Learning Objectives - After participating in this session, attendees should have the skills and tools to: - Optimize your journal environment to maximize the forensic information available to you - Understand what your journals are trying to tell you, and how to interrogate them to get the answers you need - Dump your journals quickly and easily using the free software made available - Be able to interpret the content of your journals to determine what really happened to your data - Use the techniques demonstrated in the provided source code to develop your own tools - Save the world from evil-doers

What are the strengths of the modern Large Language Model approach to Artificial Intelligence? What are the weaknesses? Where and how is it safe to apply this enticing yet dangerous technology? Where are the usage models headed right now? Inquiring minds want to know!

Learning Objectives:

1. Understanding the strengths of Large Language Model and Transformer architecture 2. Understanding the weaknesses of Large Language Model and Transformer architecture 3. Reviewing the technical, epistemological, and existential critiques of Large Language Model and Transformer architecture 4. Making actionable suggestions on this technology in the enterprise

You can’t do that on IBM i! Or so they may say. We’ll explore some common misconceptions, urban legends, and outright lies about our favorite platform, and of course we’ll also try to take down a running system for fun. The floor’s open for suggestions, stories, and a bit of fun while we try everything that you’re too afraid to try on your own system.

Learning Objectives:

n/a

Keeping your system up to date and secure requires knowledge of IBM Fixes. Here will will discuss what the Fixess are, how to get them, and how to apply them. We will also discuss the different types of Fixes and how to develop a Fix strategy for your organization.

Learning Objectives:

1. What is a Fix and the different types of Fixes 2. Build a Fix strategy that works for your company 3. How to acquire and apply the Fixes and Fix groups. 4. Using virtual image catalogs to save time on Fix application

An SQL SELECT can be much more than a simple SELECT * FROM query. Among others it includes with the GROUP BY clause a powerful data aggregation capability. A bunch of aggregate functions allows to count or summarize rows, to calculate the average over multiple rows, to determine the minimum and maximum row value. The GROUP BY clause may be widely known and used, but the HAVING clause which goes hand in hand with the GROUP BY is often a mystery. There may be other secrets waiting for being revealed … or did you know you can create all kinds of sub-totals and grand-total with an SQL GROUP BY?

Learning Objectives:

In this session you’ll learn the basic use of the GROUP BY and HAVING clauses as well as the use of multiple aggregate functions. You’ll also discover how NULL values can affect the result returned by aggregate functions. It will be demonstrated how easily all kinds of sub-totals and grand-totals can be built. You’ll also learn how to use the CASE clause for building pivot tables