IBM i ACS

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…

Setup Node-Red and Using ACS HTTP Proxy on IBM i

This is part three of my open source posts. In this post I want to cover installing the open source…

Setup Bash on IBM i and Make it Friendly

This is part two of the posts I am putting together to help you get started using Open Source on…

Setting Up the Open Source Environment on IBM i

This is the first post in a series of posts that I am creating on using open source on IBM…

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…

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…

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…

Quick CL Actions using Run SQL Scripts in IBM i ACS

Recently I was working with IBM support troubleshooting an issue with a few system tables/catalogs producing errors. They gave me…