Category: IBM i
-
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…
-
PDF Direct Printing from IBM i
What happens when you want to print a PDF from IBM i via a regular IBM i writer and output queue, where do you start with that? Let’s face it, there is no native PRTPDF (Print PDF) command in IBM i. Well, this was the question I received the other day and I was delighted…
-
SQLite and a Node API
my previous article, we went through how easy it was to call a Twitter API, searching for a string and storing that tweet in a SQLite database stored on the IBM i using Node.js. Before we get around to analysing the records we have stored over the last month or so, we need a method…
-
IBM i Security – Duct Tape & String
Having recently watched the Helpsystems annual State of IBM i Security study, along with listening to Robin talk about it on the Incredible i Show, it seemed a good time to reflect on how I originally got introduced to the need for security. As the title suggests my solution at the time was a bit…
-
Configuring ACS Printer Emulation
Before I say another word on this, I have to declare that I personally feel that using ACS to run a Printer Emulation should be considered as a last resort. It is great for Home Working, enabling you to print on your own printer when connected to the office via a VPN. It is relatively…
-
A screen a story – time to unlock yourself
We humans are creatures of habit, and of course some of these are bad habits. I am no judge here as I have my own set of habits too, good and bad, just ask my wife! As you may know, I am from the Netherlands and in my country, we have a TV commercial which…
-
SQLite – Store Tweets
In my previous article, I revealed how easy it is to use an open source database called SQLite on our IBM i server. If you need a refresher, that article can be found on the link here. In this article, I’ll show you all how easy it is to use this lightweight database. Including it…