Category: IBM i
-
Node-RED & Bank Holidays
In a recent training course I gave to a UK bank, we were covering web-services and I showed how we can get information from a reliable source and then store it in our database. They informed me that they still manually input UK Bank Holidays into a table. This was a task that they had…
-
A screen a story – What does this button do? Part II
In my last article A screen a story – What does this button do? The SQL button was used to retrieve SQL statements which I then tweaked to get the job done. The purpose of it all was to build an SQL script to automate changing the object owner of a printer, object type *DEVD.…
-
Node-RED & IBM i
In my last article I wrote about the hoops we had to jump through to get the DB2 for i Node-RED adapter installed. In this article, we will be taking a look at how we use that adapter and also how we can run IBM i commands from within our Node-RED flows. All very useful.…
-
Node-RED & DB2 for i Connector
I know I said in my last article that was the end of my little project on the Raspberry Pi with Machine Learning talking to the IBM i. Well since my last piece I have found how to correct a couple of the moans I had with Node-RED on the IBM i. My last article…
-
A screen a story – What does this SQL button do?
When working in the IT business we all appreciate it if we are being helped by the operating system. For that purpose in the New Navigator for I IBM created the SQL button. Should we all start to use the name Navigator for i or keep it short, like I do, and use the term…
-
A screen a story – Not our problem anymore
Last week I ran into an issue, which did teach me something new about the command WRKPRB. After checking a test LPAR after having applied the latest group PTFs for IBM i 7.4, I noticed the following when checking the apply: When looking at the joblog of QSYSCOMM1 spoolfiles were being created: When looking at…
-
Raspberry Pi and Machine Learning
In my last article, I demonstrated how I used Machine Learning on the Raspberry Pi to determine if a photograph contained a bird. This article can be found at https://powerwire.uk/raspberry-pi-and-machine-learning if you missed it. In this follow-up article, we will be using the Raspberry Pi to send details to our IBM I server to inform…
-
Shield Advanced Solutions – new Messaging and Monitoring solutions
September 2022 – Toronto As Shield Advanced Solutions celebrates the significant milestone, 25 years of providing Availability for the IBM i (and predecessors), our customers are raving about the new Messaging and Monitoring solutions. Many of Shield’s long-standing HA4i – high availability for IBM i customers have taken up EM4i – message monitoring for IBM…
-
A screen a story – Explore the power of Authority Collection in Navigator for i
In order to step up to a higher level of security, I suggested a customer to start using encryption on File Shares on IBM i. Currently for IBM i SMBv3 with encryption, is the highest level you can go to. For more details I suggest you have a look at this article: smbv3-support-in-ibm-i-7-4. Since we…
-
Raspberry Pi and Machine Learning
In this follow on from my last PowerWire article on ActiveMQ, we will be using a Raspberry Pi, with Machine Learning, to take photos of birds feeding in our garden. This part of the series will focus on the ML segment to take a photograph and let machine learning decide what is in it. After…
-
Cleaning Up Spoolfiles – Record Count
Because sometimes I get the most interesting challenges to play with! On a dark and stormy night, or if we want to be precise a grey and miserable afternoon… I have a partition with about 4000 QPDZDTALOG spool files dating back over a number of years. For those not familiar, this print file is generated…
-
To Cloud or Not to Cloud for IBM i
At a recent IBM i event, a discussion on cloud for IBM i was a divisive topic. Whilst we have a great platform with IBM i, to ensure it’s longevity and avoid the ‘legacy’ tag, it’s important to understand how IBM i can offer cloud and cloud-like capability and economics. In our latest blog, we…