COMMON POWERUp 2026

The role of a system administrator spans far and wide on IBM i, and getting an understanding of what's happening on your systems can be difficult without the right tools in place. Many system management tasks can be made easier and faster with today's modern set of SQL services available on IBM i. In this presentation you will learn how to use SQL to manage your system more effectively, including topics related to PTF currency, storage (and temporary storage) consumption, high resource usage and runaway jobs, security, and much more.

Learning Objectives:

`- Learn how to use SQL to automate system management tasks, including the building of automated reports - Learn how SQL makes retrieving, filtering, and grouping data a breeze - Become familiar with existing Db2 for i educational resources to learn how to create and use your own SQL tools, and to stay up to date with existing tools