Featured

PowerWire Revamp

🎉 Journey Complete – And What a Ride It’s Been! It’s taken a little longer than the year we originally planned, but we’re thrilled to say it: the final phase of the PowerWire overhaul is complete! 🚀 When we took sole ownership of PowerWire in July 2024, it was clear

Featured

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

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

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

Things You Should Know Before Memory Installation

Memory is a critical component of any computing system. IBM Power System is no exception to this. There exist different forms of memory in Power Systems, from extremely small size CPU registers to buffered and modular DRAM. DRAM itself can be characterised by size and technology. Technologies in memory are

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,

Its Summer Quiz Time!

Lets Ave a Larf! Are you a certified genius? A trivia master? A walking encyclopedia? Great! Now forget all of that, because this quiz is designed to challenge everything you think you know about, well, nothing in particular. It’s a journey into the delightfully absurd and your only mission

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

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

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

A Month of Security Problems

Before we begin my article, let me talk about CVEs. A CVE, or Common Vulnerabilities and Exposures, is a standardised system for identifying and cataloguing security vulnerabilities in software and hardware. Vulnerabilities identified with a CVE are often assigned a severity rating using the Common Vulnerability Scoring System (CVSS). This

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

The Year of Many Changes

2025 began a month ago. It is now February 2025, and we are back to our daily responsibilities: tickets, customer calls, and our regular routines. We’ve already forgotten our New Year’s resolutions. Let me remind you of a few tasks you need to accomplish this year. Buy a

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

Domain Migration

From PowerWire.eu to PowerWire.uk In an exciting development for our IBM Power community, PowerWire has officially migrated from powerwire.eu to powerwire.uk. This change marks a new chapter in our journey, and we are thrilled to share the details with you. Why the Change? The decision to

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?

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

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

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 interesting facts that have the number 600.

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 focuses on vSCSI storage. For most environments, the creation of virtual SCSI disks is a set-and-forget kind of activity. This

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

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

i-UG's 2024 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

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

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

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

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 Dennis Ritchie and Ken Thompson, Unix revolutionized the way computers are used. Thanks to its reliability, stability,

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

Why AIX is the best option to start your fresh new Agile Project

When it comes to a new project, management usually has only one option. It must be Linux in “cloud”. Many people think AIX is an old operating system and as such it doesn’t fit anymore in a modern infrastructure where everything is agile and changing constantly. I don’t

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

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 … Why should I bother with SSH keys when I can quite easily use a password?

PowerWire Author Guidelines

This post is a guide to authors, or potential authors, writing articles for the PowerWire publication. Every month, on the first Thursday of each month, the PowerWire newsletter is published and emailed to subscribers around the world. This newsletter points to the new articles that have been published that month

Installing & Using the AIX Toolbox for Open Source

What is the AIX Toolbox for Open Source? Previously known as the AIX Toolbox for Linux Applications, the AIX Toolbox for Open Source Software (AIX OSS) is a collection of open source and GNU software built specifically for AIX. The toolkit provides open source utilities for managing and development, that

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

Setup a User for Open-Source

In my article this month I will be taking you through the stages to allow a user to access, and use, open source on the IBM i. This has to be the most asked question of our client base. “I’ve installed open source on my Power server, but how

Did you ever take a console over?

During the COVID-19 pandemic we all learned to work remotely when possible. Setting up a VPN connection is something no longer only performed by IT personals. Losing a VPN connection is also something which many of us have experienced. Working remotely when doing system management tasks out of office hours,

Node.js v20 on IBM i

It is time to get back to Node.js on the IBM i! Node.js v20 is the latest version of this great programming language.  Please note that Node.js v14 moved out of support from April 2023, so time for you all to upgrade, and what should you upgrade

Pre-Power Down System Exit Point?

The Exit point functionality available within IBM i, is what I would call a hidden gem. If we just look at the Pre-power down Exit Point my guess is you will agree. In my article of last month the Start-up program was handled. Now it is time to look at

FormaServe & NC Communications Join Forces to Publish PowerWire

FormaServe, a leading provider of IBM i training and consultancy services, and NC Communications, a specialist in IT events and media production, have announced a strategic partnership to publish PowerWire, the IBM Power newsletter. PowerWire is a monthly online publication that covers the latest news, trends & insights on IBM

A screen a story – IBM i Startup Program QSTRUPPGM?

Although it is possible not to use a Start-up program, finding a customer who does not use one, is like finding a needle in a haystack. Please allow me to use another expression which, when finishing reading this article makes sense for you: “if it ain’t broke don’t

Language Comparisons Continued …

In my previous article, I explored a range of functions and delved into how syntax varies across different programming languages. If you haven’t had a chance to check it out yet, I highly recommend giving it a read. You can find the article right here. As a quick reminder,

Language Comparison's

As the landscape of programming continues to evolve, many of us IBM i developers find ourselves exploring a diverse array of languages beyond those with which we began our coding journey. As more and more of us get involved with different languages I thought it would be a good idea

A screen a story – WRKACTJOB?

One of the commands used by every system administrator is WRKACTJOB. I think it if fair to say that this command is in their top 10 most often used commands. It might for some be the rock solid number one of all time. In order see what is happening on

A screen a story – the system value QSECURITY

You may wonder what the screen below has to do with the system value QSECURITY. A change in this system value was part of the announcement of IBM i 7.5, which had a strong focus on security. Level 20 is no longer supported and a new system is shipped

Generating PDFs

Those of you that took a look at my updating of open source packages on IBM i, will know that I have always been one for recommending the conversions of Spool files to PDFs when ever possible. My open source updating article can be found here https://powerwire.uk/open-source-updates/

A screen a story – Sometimes a question mark is not enough

By now you must be getting used to seeing a new version of IBM i Access Client Solutions (ACS) every time a new Technology Refresh (TR) is released – you are keeping your ptf’s up to date aren’t you?!  In the official announcement letter we can read what is

RPG Data-Gen Operational Code

Looking back at when I first started writing articles for PowerWire.eu nine years ago, I was bought onboard to cover RPG articles.  Looking back over the last few years I have failed miserably in this task and maybe got too carried away in the ‘open-source’ frenzy. In this anniversary

Why Celebrate the 35th Anniversary of the IBM i Platform at the University of Wolverhampton? ...Because the Future Won’t Wait!

The 21st of June this year marks the 35th anniversary of the launch of the IBM i Platform. This event is quite unusual in a tech industry that typically venerates all things new. Relevance and the realisation of shiny digital futures is typically the highest currency across tech’s chattiest

Eclipse AI Chat Integration

My good friends at Remain Software have just released an AI chat integration feature for Eclipse and Rational Developer for i . According to their website, ‘This tool leverages the power of AI to provide contextual suggestions, code snippets, bug checking and documentation proposals.  Empowering you to write code faster and

A screen a story – A User Reporting Slow ODBC Performance

In my last article I wrote: “IBM i Services allows a modern system administrator to move away from having to use 5250 emulation, not because you should, but because using IBM i services is quicker in getting the job done. In my next episode of a screen a story I

A screen a story – The Contact Information National language version

Recently Scott Forstie created an SQL script allowing you to create a procedure with which it is a piece of cake to review the special instruction PTFs. What the link is between the contact information and the PTF cover letters is something I will explain later on. Please allow me

Environment Variables

The IBM i operating system is highly dependent on environmental variables, which can have a significant impact on its performance. In this article, we will dive into the various environmental variables and their effects on the IBM i. What are environment variables? Let me start at the beginning, what are

A Note from the Chairman

Well, if we thought that 2022 was a whirlwind – that saw much of business come back together and saw i-UG really step up to the mark in trying to keep the information flowing – then 2023 is going to need a whole new weather warning! 2022 was a great year. We

A screen a story – The Run SQL Scripts bottom bar

If IBM is following the same schedule as it has in previous years it is fair to say that a new version of IBM i Access Client Solution (ACS) is waiting just around the corner. In the past April was the month in which a new ACS version was released

DB2 for i Multisystem

In this article I will be taking a look at a feature we should all be installing, and using, on our IBM i servers. As I mentioned in a recent article I wrote on the advance job scheduler (which can be found here), IBM announced in May 2022 that half

A screen a story – What does “move active records” mean?

The latest Technology Refresh (TR) for IBM i 7.4 and 7.5 has something new within them for reorganizing a file. If you have lost count of the TR levels IBM i 7.4 is at TR7 and IBM i 7.5 is at TR1. Every time a new

Node-RED & Security

I gave a quick demonstration of Node-RED to a client recently and I didn’t get the response I was expecting. On bringing up the Node-RED browser interface, the first question I got asked was why doesn’t Node-RED use a TLS (Transport Layer Security), or SSL (Secure Socket Layer)

Node-RED & Bank Holidays

In a recent training course I gave to a UK bank, we were covering web-services and I showed how we can get information from a reliable source and then store it in our database.  They informed me that they still manually input UK Bank Holidays into a table.  This was

A screen a story – What does this button do? Part II

In my last article A screen a story – What does this button do? The SQL button was used to retrieve SQL statements which I then tweaked to get the job done. The purpose of it all was to build an SQL script to automate changing the object owner of a

Node-RED & IBM i

In my last article I wrote about the hoops we had to jump through to get the DB2 for i Node-RED adapter installed. In this article, we will be taking a look at how we use that adapter and also how we can run IBM i commands from within our

Node-RED & DB2 for i Connector

I know I said in my last article that was the end of my little project on the Raspberry Pi with Machine Learning talking to the IBM i.  Well since my last piece I have found how to correct a couple of the moans I had with Node-RED on the

A screen a story – What does this SQL button do?

When working in the IT business we all appreciate it if we are being helped by the operating system. For that purpose in the New Navigator for I IBM created the SQL button. Should we all start to use the name Navigator for i or keep it short, like I

A screen a story – Not our problem anymore

Last week I ran into an issue, which did teach me something new about the command WRKPRB. After checking a test LPAR after having applied the latest group PTFs for IBM i 7.4, I noticed the following when checking the apply: When looking at the joblog of QSYSCOMM1 spoolfiles

Raspberry Pi and Machine Learning

In my last article, I demonstrated how I used Machine Learning on the Raspberry Pi to determine if a photograph contained a bird.  This article can be found at https://powerwire.uk/raspberry-pi-and-machine-learning if you missed it. In this follow-up article, we will be using the Raspberry Pi to send

Shield Advanced Solutions - new Messaging and Monitoring solutions

September 2022 – Toronto As Shield Advanced Solutions celebrates the significant milestone, 25 years of providing Availability for the IBM i (and predecessors), our customers are raving about the new Messaging and Monitoring solutions. Many of Shield’s long-standing HA4i – high availability for IBM i customers have taken up EM4i – message

Explore the Power of Authority Collection in Navigator for i

In order to step up to a higher level of security, I suggested a customer to start using encryption on File Shares on IBM i. Currently for IBM i SMBv3 with encryption, is the highest level you can go to. For more details I suggest you have a look at

Raspberry Pi and Machine Learning

In this follow on from my last PowerWire article on ActiveMQ, we will be using a Raspberry Pi, with Machine Learning, to take photos of birds feeding in our garden. This part of the series will focus on the ML segment to take a photograph and let machine learning decide

Cleaning Up Spoolfiles - Record Count

Because sometimes I get the most interesting challenges to play with! On a dark and stormy night, or if we want to be precise a grey and miserable afternoon… I have a partition with about 4000 QPDZDTALOG spool files dating back over a number of years. For those not familiar,

To Cloud or Not to Cloud for IBM i

At a recent IBM i event, a discussion on cloud for IBM i was a divisive topic.  Whilst we have a great platform with IBM i, to ensure it’s longevity and avoid the ‘legacy’ tag, it’s important to understand how IBM i can offer cloud and cloud-like capability

A screen a story –  Db2 Symmetric Multiprocessing part II

The sayings are “practice what you preach” or the more down to earth expression “eat you own dogfood”. Eating your own dog food is a phrase that refers to the internal use of a company’s own products or services in its day-to-day operations. So over the years I have

ActiveMQ

I’ve got a little home project that I’ve been looking at for a while.  In this article, I’ll prepare our IBM i for that project. It will involve some IoT devices sending data to the IBM i. To receive that information the IBM i, will be using

Why IBM i continues to deliver excellent ROI for manufacturing and distribution

IBM technology has been a key part of enterprise IT since the 1980s with platforms such as AS/400, iSeries, System i and IBM Power Systems and operating systems such as OS/400, i5/OS and IBM i. This technology is prized for its superior performance, stability and dependability. In

Power10 for the masses is finally here! 

In June, IBM announced the replacement for the popular 1, 2 and 4 socket Power servers which make up the mainstay of the Power installed base.   If you missed it, Northdoor have covered the highlights in performance, security and scalability in our latest blog.  With significant CPW improvement per core

A screen a story –  Db2 Symmetric Multiprocessing

Part of the announcement of IBM i 7.5 was a change in what is entitled as part of the base operating system with IBM i. If you want a complete list of the Price Change(s): Price Decrease on Selected IBM i Sofware Products please have a look at

An Advanced Job Scheduler

In this article, I’ll be going back to good old green screen, well for some parts of this article! Nested in the IBM i 7.5 OS announcements made by IBM in May 2022, was the statement that half a dozen or so licensed programs will now be included

It’s official – IBM have now launched their Power10 Scale out range!

Whilst IBM’s Enterprise range did come out back in September 2021, that provided for the high-end Power clients only.  With this release of low and mid-range servers, the capability of Power10 is made available to everyone. In a nutshell, the key benefits of Power10 are; * Enhanced Security – Power10 includes

Bring Power to the cloud with Northdoor and Skytap

For organisations that run their x86 workloads on Azure, Skytap offers the ability to bring IBM Power workloads into the same cloud, co-located for low latency and high performance. With your AIX, IBM i and Linux on Power workloads in Azure, you benefit from flexible capacity and pricing with no

An Ansible Environment Setup

Firstly, thank-you to all those who attended my Ansible workshop and presentation of Visual Studio Code at the i-UG conference at Northampton in June.  It was great to be back presenting and meeting up with friends. This article is related to this event. The Power servers for the event, were

A screen a story - Enabling SSL/TLS for IBM Navigator for i

In today’s world there is a lot of emphasis on IT security. Not strange when the word “Hack” is a word you often hear or read when following the daily news. We all know that there is no better security level possible than security implemented at the source level.

An Ansible IBM i Disk Checker

This article slightly deviates from my usual open source articles on IBM i. I say slightly, as this article will be about Ansible and yes Ansible is open-source.  Thank-you Red Hat. This article will not be an introduction to Ansible.  My good friend Glenn Robinson, has written a great couple

Remain Software Milestone 3

NIEUWEGEIN, Netherlands — Today Remain Software is pleased to announce the third Milestone of TD/OMS V14 and MiWorkplace V1.29.0, in line with the company’s commitment to innovation and support. This Milestone is the third scheduled enhancement to each solution, culminating in the annual release each summer. Today’

WRKRDBDIRE part 2 – MYSELF and DDMDRDA

Some of you may remember an article I wrote in December 2019 about using WRKRDBDIRE and DDM to get data from a V5R4 system. Recently I came across a couple of extra scenarios when pulling data from systems, so it seems a perfect opportunity for a part 2 article. First

A screen a story – IBM i 7.5 – Set Subsystem Routing

May the third IBM i 7.5 was announced, if you follow the IBM i news, this announcement was hard to miss. Normally it does take a while before every IBM i LPAR is running this version, but this time things are little different. First of all, the date IBM

LFTP on IBM i

If you know all about the TCP/IP utility FTP, you will feel right at home with this nifty utility. If you are fed up with all the virus’s in the open-source utility FileZilla, give lftp a try.  You will not be disappointed. As the man page for lftp

PowerWire.eu talk to i-UG's chairman Mike Ryan about their upcoming annual conference

Hello Mike. As the official representative of COMMON Europe in the U.K, i- UG has always listened to the current needs of its members to ensure they get great content that’s relevant to their day to day needs and have done this for many years by organising 4

Dot Files on IBM i

For those who have been following my bite size BASH tutorial on You Tube, I thought it about time I wrote an article about a very useful BASH utility that’s available for our IBM i, and of course, plug my BASH videos at https://bit.ly/3IXBkm6 at the

A screen a story – SQL Performance – a Table Scan

In today’s world it is impossible to limit yourself to the green screen when we are talking about IBM i performance and SQL performance in particular. For some shops the IBM i database has become the spider in the database “web”. I assume we have all heard about the

Being Cyber-safe is easier than you think

I’m sure you have all heard about the situation in Ukraine, one consequence that we need you to be aware of is the increased risk of cyber-attacks on UK businesses.  There are those in Russia and those sympathetic with Russia’s aims, that would like to see businesses in