maxava

Welcoming the IBM Community

Articles

Welcome to our articles page

If you cannot see what you are after, use the search box below

stretch sql

Stretch Imagination with SQL Part 2

ByByMarius le Roux Jun 30, 2025 20 min read

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…

user groups

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

ByByAndy Youens Jun 3, 2025

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…

sql

Stretch Imagination with SQL Part1

ByByMarius le Roux May 7, 2025

Scenario Let’s take a simple query like. It gives quite useful information, right?  In fact, 109 columns of information that I have to scroll through all right through the screen.…

Your One Stop for IBM i Training!

FormaServe Training


Look no further than FormaServe, who have been providing IBM i training since 1990.

Our trainers & consultants are one team, ensuring that both stay up to date & our courses revolve around real-world experience.

We are dedicated to providing innovative & useful training for the IBM i.

Our mission is to aid you & your staff to take advantage of new & existing technologies & become more productive in your everyday work.

Previous Posts

Nano – A Great Open-Source Editor

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…

ByByAndy Youens Apr 2, 2024 2 min read
A person in a robot suit Description automatically generated

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…

ByByMichał Wiktorek Mar 22, 2024 19 min read
A screen a story – Raise your delay knowledge level by 0.1?

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…

ByByRudi van Helvoirt Mar 6, 2024 3 min read
agile logo

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…

ByByAndrey Klyachkin Mar 6, 2024 6 min read
i-UG Springs into Life in 2024

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…

ByByAndy Youens Feb 27, 2024 4 min read
Use SSH Keys to Stop User Password Access

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?…

ByByAndy Youens Feb 13, 2024 7 min read
PowerWire Author Guidelines

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…

ByByAndy Youens Feb 13, 2024 3 min read
Installing & Using the AIX Toolbox for Open Source Software

Installing & Using the AIX Toolbox for Open Source Software

What is the AIX Toolbox for Open Source Software? Previously known as the AIX Toolbox for Linux Applications, the AIX Toolbox for Open Source Software (AIX OSS) is a collection…

ByByGlenn Robinson Feb 7, 2024 6 min read
Make Sense of Journaled Tables with SQL

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…

ByByTerry Bartlett Jan 17, 2024 7 min read
Setup a User for Open-Source

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…

ByByAndy Youens Jan 4, 2024 4 min read
A screen a story – Did you ever take a console over?

A screen a story – 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…

ByByRudi van Helvoirt Jan 4, 2024 5 min read
Node.js v20 on IBM i

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…

ByByAndy Youens Nov 6, 2023 7 min read