IBMi - PowerWire

The trusted voice of the IBM Power community

IBMi

A collection of 312 posts

i-UG (UK) Announces 2026 Summer i-Power Event

i-UG (UK) Announces 2026 Summer i-Power Event

Join us for the 2026 Summer i-Power Event! The i-UG (UK) is thrilled to announce that the 2026 Summer i-Power event will be held at Leonardo’s Hotel in the heart of Milton Keynes on the 2nd and 3rd of June 2026. This event promises to bring together industry experts,

Featured Featured

MFA: A Complete Guide to Affected Areas - Part 2

This article continues our deep dive into Multi, Factor Authentication (MFA) on IBM i, focusing on the new features introduced in version 7.6. If you’re new to MFA or need a refresher, you can start with the first part of this series, What is Multi, Factor Authentication? available

Featured Featured

MFA: A Complete Guide to Affected Areas - Part 1

This article continues our deep dive into Multi Factor Authentication (MFA) on IBM i, focusing on the new features introduced in version 7.6 If you’re new to MFA or need a refresher, you can start with the first part of this series, What is Multi, Factor Authentication? available

ACS Enhancements 1.1.9.9

A month ago, IBM i Access Client Solutions 1.1.9.9 was released. Probably you have it already running and are using it in your IBM i environment. I have already come across a lot of articles informing you about the new functionality added to ACS 1.1.9.

What is Multi-Factor Authentication?

Why Your Digital Life Depends on It! IBM’s latest release, IBM i 7.6, brings a major security upgrade to our favourite server: Multi-Factor Authentication (MFA). This built-in feature is a game-changer and it’s something every admin should know about. Implementing MFA can feel like a daunting task,

Node-RED Version 4

The Node-RED project has recently unveiled a major new release, version 4.0, which introduces a host of enhancements focused on improving the development experience, collaboration and long-term flow maintenance. This article provides a detailed look at the key changes that make this new version a significant upgrade for developers

Change IPL Attributes

In 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 the printers has always been one of my concerns. I only wanted the printers to be starting on the production

Stretch Imagination with SQL Part 2

Article 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 to display the data in a table and automate the process. I also wanted to demonstrate how to handle repeating

i-UG i-Power 2025: The Premier IBM i Event in the UK

The 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 flagship event brings together industry experts, developers, and IT professionals to explore the latest advancements in IBM i technology. The

Stretch Imagination with SQL Part1

Scenario Let’s take a simple query like. SQL select * from qsys2.SYSTEM_STATUS_INFO SQL It gives quite useful information, right? In fact, 109 columns of information that I have to scroll through all right through the screen. and so forth. Now, what if I want to track these

Your Guide to Using cURL

At the two recent i-UG (the largest IBM i User Group in the UK), I gave a presentation about three great open-source utilities on the IBM i. Those being: cURL LFTP rSync Having just checked, I have written about the last two on PowerWire, so for completeness, I must write

IBM i 7.6 Release

IBM i 7.6 Release

From Steve Will on the 8th April 2025 Happy new release day IBM i community! Welcome to 2025 and my first blog of the year. We are starting the new year off with a big one, as today we announce IBM i 7.6 and IBM i 7.5 TR6.

Say Hello to IBM i 7.6

Say Hello to IBM i 7.6

Big, Bold & Better Than Ever! Attention, IBMi fans! The wait is over, and the latest and greatest version—IBMi 7.6—is finally here. Who would have guessed that name! Let us have a quick light-hearted look at this release. We cannot be serious all the time. If IBMi

Collection Services Q & R

The “R” in the title is no typo, no Q & A this time. The “R” does refer to the name Collection Services Collection in the screen shot, which is available in two flavours, but what is the difference? Well, that is a question that is easy to answer. There

Choosing the Right Language on IBM i

RPG, ILE, SQL & Open-Source Programming Our grandchildren have just started secondary school and along with the expected French, Spanish and German they have been offered Mandarin. Everyone has welcomed this as ‘moving with the times’ and adding another ‘useful string to their bow’. In this ever-shrinking world it is

Mapepire Introduction

In my last couple of articles, I have shown python accessing data on the IBM i, accessing both DB2 for i and SQLite. The SQLite article used an SQLite package to get the data, and for the DB2 for i example I used ODBC to retrieve data from the IBM

noxDB Intro

In November 2024 I was invited to the Benelux Common conference in the Netherlands to give a couple of workshops, and what a great event it was. I had the opportunity to meet up with a good friend of mine Niells Liisberg from Denmark, where we had time to look

Passwords: Looking Ahead

Be it auditors, the recent NIS2 Directive , or just common sense, stepping away from IBM i user profiles with never expiring passwords has always been the better choice. Since IBM i has been around for quite some time, a lot of the security options have gotten a bit long in

Open Ports on IBM i

Open Ports on IBM i

In this article I will talk about another great open-source utility for our IBM i. A couple of years ago I wrote an article on a great open-source utility called Service Command. It can be found at this link. As part of this package, we have a command called SCOPENPORTS.

Where Are You Listening?

Where Are You Listening?

Security is hard to ignore these days and for good reason. So, adding TLS to all IBM i applications is a logical step to take. For sure there are the well know ports, for which it is not hard to guess by which application they are used. Well-know Ports ServicePortFunctionHTTP80Web

PowerWire Article on DB2

Python DB2 for i Access

Introduction In my previous article, I wrote about how to access a SQLite database and output the SQL resultset in a neat table. If you need a recap, my previous article can be found at this link. In this article I will show you how to access a DB2 for

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 my mathematic skills are lacking since IBM i celebrated its 35th anniversary last year in 2023. Obviously, that’s a

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

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

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