maxava

Welcoming the IBM Community

Articles

Welcome to our articles page

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

DB2-30

30 Years of Db2 on IBM i

ByByKent MilliganSep 3, 20243 min read

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…

From SQL to Python: IBM i Database Queries

From SQL to Python: IBM i Database Queries

ByByAndy YouensAug 13, 2024

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…

added layer?

Why Not Add An Extra Layer of Security?

ByByRudi van HelvoirtAug 12, 2024

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…

Webinar: Planning a Successful IBM i 7.6 Upgrade
16 October | 4 P.M. BST

se


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

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

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…

ByByNigel ClaphamApr 29, 20226 min read
Dot Files on IBM i

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…

ByByAndy YouensApr 4, 20225 min read
A screen a story – SQL Performance – a Table Scan

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…

ByByRudi van HelvoirtApr 4, 20223 min read
dummy-img

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…

ByBySteve BradshawMar 20, 20222 min read
Tech Tips – Maximum Number of Object owned by a User Profile

Tech Tips – Maximum Number of Object owned by a User Profile

By Paul Tinker – Covenco I had a customer send out the “Bat Signal” late on a Sunday night, their application had completely stopping working but when it came to…

ByByStaff ReporterMar 14, 20223 min read
Rant for better security on IBM i

Rant for better security on IBM i

This rant is intended as a wakeup call to companies and ITSecurity experts.I have 25 years of experience in Security on IBM i and all too often my observation of the poor implementation of…

ByByStaff ReporterMar 8, 20223 min read
Probably the best Interactive Debugger on the IBM i

Probably the best Interactive Debugger on the IBM i

Get Started Open up ‘IBM i Client Access’, make sure you have entered the correct system, then choose ‘Database – Run SQL Scripts’. Now select ‘Run – System Debugger’.  If…

ByByTerry BartlettMar 7, 20227 min read
How to find the right IBM i printer configuration

How to find the right IBM i printer configuration

You might think that we live in a world of standards and that any printer would be able to work out of the box with any server. Well sadly, you…

ByBySteve BradshawMar 7, 20224 min read
A screen a story – A Better way to Retire the Heritage Navigator for i

A screen a story – A Better way to Retire the Heritage Navigator for i

Let me cut right to the chase, if you have read or have not the article of last month titled: “A screen a story – Retire the Heritage Navigator for…

ByByRudi van HelvoirtMar 7, 20225 min read
How Can You Update Your UAK Key without an HMC?

How Can You Update Your UAK Key without an HMC?

I was working at a customer last week when I noticed the system attention light was illuminated on their Power 9 Server. Looking at WRKPRB (work with problems) log, the…

ByByGraham StreetMar 3, 20224 min read
dummy-img

NCDU on IBM i

Yes, I am continuing my amazing journey with open source on the IBM i. In this article I’ll be taking a look at another one of the open source utilities…

ByByAndy YouensMar 1, 20223 min read
2022 All400’s IBM i Survey

2022 All400’s IBM i Survey

Four years agon All400’s did a ‘user’ survey about IBM i, and they had 650 resonses, this year they are doing another survey and hope to achieve 1000 responses. They…

ByByStaff ReporterFeb 19, 20221 min read