IBM i Community

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…

How to debug Node-Red on IBM i

I’ve been asked for methods to debug nodes in Node-Red. Here is a brief introduction to this topic. This is…

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…

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…

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…