Category: Featured
-
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 i table, and like my…
-
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 gap of 5 years. Does that…
-
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…
-
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 makes it low maintenance, but…
-
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…
-
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…
-
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, and security, Unix and its derivatives have gained…