COMMON POWERUp 2026

Maintaining a clean IBM i environment is essential for performance, compliance, and long-term system reliability. While traditional CL commands can handle many housekeeping tasks, SQL offers a faster, more flexible way to identify and manage unused objects, audit logs, journal receivers, and other system clutter. In this session, attendees will learn practical SQL techniques to streamline system maintenance, uncover inefficiencies, and automate cleanup tasks. Real-world examples will demonstrate how a few well-crafted queries can make a significant impact on system health, freeing up space and reducing administrative effort.

Learning Objectives:

By the end of this session, attendees will be able to: - Identify and remove unused or redundant objects using SQL. - Locate and safely delete detached journal receivers and old audit data. - Clean up job logs, message queues, and spool files efficiently. - Automate routine system maintenance tasks with SQL scripts for ongoing efficiency.