Attending this event?
Back To Schedule
Tuesday, May 25 • 4:00pm - 4:20pm
A few quick things you can use SQL to check for

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Using SQL allows you to keep tabs on the following: - Do I need to RGZPFM? Number of deleted records in files. What happens if I want to exclude some libraries or files? - Old spool files - Abandoned files in IFS - Check for errors on this partition & others all on one screen - WRKSYSSTS equivalent snapshot to email or log file Also creating SQL Views over data areas & for giving CL information it can only get from APIs.

avatar for Simon Hutchinson

Simon Hutchinson

Simon’s experience with IBM midrange started over 30+ years ago in the United Kingdom, in a pre-AS/400 world. Since immigrating to the USA in 1992, he freelanced in many parts of the South West before settling in Central Texas. Currently, Simon is the IBM i DevOps and Operations... Read More →

Tuesday May 25, 2021 4:00pm - 4:20pm EDT
Breakout 5 / Morrow