Welcome to our articles page
If you cannot see what you are after, use the search box below
Change IPL Attributes
ByIn the IBM i world, when dealing with High Availability and Disaster Recovery, the history started with software replication, no matter which product you started or are still using, starting…
Stretch Imagination with SQL Part 2
ByArticle Summary This article is about tackling a fun SQL challenge! The goal was to parse a spool file in a different way than usual, so I could show how…
i-UG i-Power 2025: The Premier IBM i Event in the UK
ByThe i-UG i-Power 2025 Conference is set to be one of the most exciting events for IBM i professionals in the UK. Taking place at the Mercure Northampton Hotel, this…
Webinar: Planning a Successful IBM i 7.6 Upgrade
16 October | 4 P.M. BST
Join IBM i expert Pete Massiello as he walks you through the essential steps to prepare for your next upgrade.
From prerequisites to post-installation requirements, this session will equip you with the knowledge and confidence to complete your upgrade correctly.
Previous Posts
30 Years of Db2 on IBM i
August 2024 marks the 30th anniversary of Db2 on IBM i and its predecessor platforms – iSeries & AS/400. Those of you who follow the platform closely might think that…
By
From SQL to Python: IBM i Database Queries
Introduction In this article I will show how we can use python on the IBM i to retrieve records from a SQLite database and output the results in a nicely…
Why Not Add An Extra Layer of Security?
It’s most likely that you have added an extra lock on your front door, preventing it for being opened from the outside. In most cases we do not think about…
Article 600!
This is a historic post, article number 600 rolls of the print press! Here we celebrate this exciting feat. The number 600 pops up in various contexts, here are some…
Which VIO Servers Are You Using for vSCSI Storage?
How do you know which VIO servers your AIX LPARs are using for storage? There are different options for presenting storage for your AIX VIO clients (the LPARs). This article…
By
How to use SQL to find files needing Reorganisation
While there are quite a few methods for finding candidates for Reorganise Physical Files (RGZPFM), lots of them are old and some of them take a long time and resources…
By
Getting Started with the IBM HMC
The command line interface allows you to automate tasks, which can make monitoring or even creating new LPARs easier. Although the Hardware Management Console GUI is a common way to…
i-UG’s Summer Event Workshops
The iUG’s summer event is just around the corner & this year promises to be more exciting than ever. With a focus on innovation & practical skills, the workshops are…
Access for Client Solutions 1.1.9.5
As the seasons change, so does the tech landscape. And just like clockwork, IBM has graced us with the latest iteration of their Access for Client Solutions (ACS) product. Say…
A screen a story – What is my IP Address, tales of the unexpected?
Recently I ran into a problem on an LPAR where apparently nothing was changed. The problem as always is, how to determine if nothing was changed. After all an IPL…
Nano – A Great Open-Source Editor
In this article I show you how to use a great editor called Nano for any editing we have to do with files on our IFS. Yes, I can hear…
AIX System – Unix in the Modern IT World
Introduction In the world of operating systems, Unix is one of the foundations on which today’s computing is based. Designed in the 60s and 70s at AT&T Bell Labs by…
By