Category: IBM i
-
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 formatted table. I will be using Python 3, which can be found in Open-Source Package Manager from ACS. Now we have python, we need the…
-
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 having this extra lock, it is just there, and we use it. However, at some stage someone came up with this idea and it spread…
-
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 manage Power Systems, I’ve found it worth getting familiar with the CLI. If you need to create a lot of new LPARs with their profiles…
-
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 to get results. So here is a new one using ACS Run SQL Scripts, that may be faster and is more controllable. Lets start with…
-
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 designed to empower IBM i professionals with the latest knowledge & tools. Whether you’re a seasoned developer or new to the IBM i community, these…
-
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 of an LPAR is change. Let me tell you what happened. For a customer running an independent Auxiliary Storage Pool (iASP) in a Cluster environment…
-
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 hello to version 1.1.9.5! In this article, we’ll delve into the exciting updates, enhancements, and features that ACS brings to the table. Installation If you…
-
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 half the readers screaming ‘I can use Rational Developer for i!’ and the other half of the readers shouting, ‘I can do that with VS…
-
A screen a story – Raise your delay knowledge level by 0.1?
If the screen show below looks familiar, there are two possible reasons: Either you are using the Scheduled Job (WRKJOBSCDE) command for scheduling jobs on IBM i and are not using the Advanced Job Scheduler. Or you are aware of the fact that the CL command DLYJOB exists and you might have used it yourself.…
-
i-UG Springs into Life in 2024
The IBM i User Group (i-UG) in the UK sprung into life in February 2024 with their first event of the year at sunny Rochdale. I say sunny, being from the south of the UK, ‘sun’ and ‘the North of the UK’ are not words that go together! The i-UG chairman, Mike Ryan kicked of…
-
Use SSH Keys to Stop User Password Access
This article shows how easy it is to use SSH keys to stop users, or yourself, from having to use a password to gain access to a SSH session. Why? The first question is always … SSH keys are more secure than passwords, as they are longer, more complex and harder to guess or crack…
-
Make Sense of Journaled Tables with SQL
Test Setup I had a number of tables that had been journaled and I wanted to analyse what had changed during a fixed time. This is quite simple, the essential parts are sections 2, 4 and 5. The table created in section 4 can be kept and reused, one for each table, if required. N.B.…