IBM i SQL

Query the System Log on IBM i 7.1 using CL and SQL

UPDATE: Christian Jorgensen sent me an easier method to accomplish this after I posted this article: https://bitbucket.org/christianjorgensen/sql-udtf-history_log_info/src/master/ I have not…

Load and Apply PTFs without Image Catalog or FTP using ACS. Run CL with a GUI.

I manage several Mimix and iTera environments and it’s that time again where I want to take an upgrade to…

Making the Move from using STRSQL to Run SQL Scripts in ACS

I run into people often that are still using STRSQL to query their system. It works but it is clunky…

IBM i Node-Red Admin Dashboard (example)

I contributed my first ever piece of open source code to GitHub for the community to enjoy. I built upon…

Compare System Values Between Systems or LPARs

I am always looking for easier ways of accomplishing things and with less manual effort. Less manual effort, in my…

IBM i Run SQL Scripts – Find a File Consuming Storage

I recently encountered a situation where storage on a system climbed by 12% within a 24 hour period. I wanted…

IBM i Run SQL Scripts – Query Data, Format an Email, and Send It

Today we will look at a process to check a file, located within the IFS, and identify if it was…