IBM i Administration

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…

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…

End Subsystems Controlled and Power Down System in Batch

Recently, I was working on a hosted IBM i environment and needed a way to bring down all of the…

Working from Home? Using IBM i Java ACS Client to Print to a Home Printer or to File

Due to COVID-19 many people are working from home, crazy times we are living in. I have worked with many…

Upgrade IBM i from 7.1 to 7.3 (my condensed process) – Single LPAR

About 2 months ago I posted a step-by-step guide for performing this on a hosted LPAR. In this post I…

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…

Order PTF Groups, Download them to the IBM i, and Create an Image Catalog

When I first started as an “administrator” on the IBM i (I wasn’t given this title but I basically took…