Category: IBM i
-
ODBC & Node.js on IBM i
In this article I will be looking at database access using Node.js on our favourite platform the IBM i. A bit of background info first. One of the first applications we wrote in Node.js had to access an audit log that was stored as a traditional table, physical file. It had to both read and…
-
A screen a story – collateral benefits
In today’s world when reading about IBM i it is hard to avoid articles dealing with application modernization. Being a system administrator, I use applications too. What about them, do they need modernization too? Well, let us have a look at the two screens shown below: The first screenshot is taken from the Job scheduler…
-
A Java on IBM i Intro
A bit different this one. I was recently asked by a fellow IBM Champion to give him a quick run through on Java on the IBM i, so I thought I would write a quick article on this topic for others out there. Installation of Java Java has to be installed on our IBM i…
-
A Screen a Story – to desire or to require
You may think that a Hardware Management Console (HMC) is a luxury that is only needed by larger POWER user environments but in this article I am going to try and explain why you should think again. A LAN console may be technically sufficient for your needs and does not put much weight on your…
-
IBM i on IBM Power Systems the next ten years of innovation
Join Northdoor and IBM to celebrate the innovations in both IBM i and Power Systems. As we approach the launch of POWER10, we will discuss the next generation and how clients can take advantage of new hybrid cloud offerings and we will talk about the future roadmap of IBM i. We will also share a recent TCO study…
-
Removing drives from guest partitions
“You’ve not done a lot during lockdown, so it’s time to trim the fat.” Technically words from my GP, but I figured perhaps I could apply it to my partitions as well! To set the scene, I want to do a system save of a Power7 with the slight issue that the tape drive isn’t…
-
A screen a story – to include or to filter
Once in while an ad hoc job ends up on your desk. A while ago I had such a day, although the disk space usage was around 70 %, the backup of the Integrated file System (IFS) part of the system was consuming more and more time every night. The decision was made not to…
-
Who is using that IFS object?
Sometimes the simplest of questions that come into our support desk can fill us with dread and before the advent of IBM i Services, finding out which job had a lock on a particular IFS object was definitely one such question. Back in the olden days we would have to write a custom program or…
-
Interview with Mike Ryan, Chairman of i-UG. What have they been doing over the last 12-months? and what to expect at their event next month!
PowerWire (PW): – Hello Mike, its nice to chat to you again, the last time we spoke was in Spring last year when the pandemic first broke out and i-UG where rearranging their annual conference, International i-Power, to a virtual format. A lot has happened since then, and I think most people have been working…
-
IBM Champion Tweets
As you will hopefully know, in my last few arcticles for PowerWire, I have been writing about retreiving tweets and storing them in a SQLite database on the IBM i. I have a scheduled job on my IBM i that finds the tweets that have the hash tag #IBMChampion. Now we have a few weeks…
-
A screen a story – PM400 and the day after (30th September 2020)
The term “IBM Performance Management for Power Systems” does most likely not immediately ring a bell, my guess is “PM400” does. It was offered for free and as a Dutchman, after I hear the word “free”, you have my attention. PM400 was a service offered by IBM for free, performance reports accessible from a Website…
-
More – What is eating my IFS?
Warning :- The main SQL statement may run for many minutes. In my case just over 1:30 elapsed and 35 CPU seconds, but I only have 222,000 objects in my IFS on a Power 9. I have run the QSRSRV (see below) on a Power 7+ with around a million objects in the IFS and…