IBMi Environment Variables The IBM i operating system is highly dependent on environmental variables, which can have a significant impact on its performance. In this article, we will dive into the various environmental variables and their effects on the IBM i. What are environment variables? Let me start at the beginning, what are
IBMi A screen a story – The Run SQL Scripts bottom bar If IBM is following the same schedule as it has in previous years it is fair to say that a new version of IBM i Access Client Solution (ACS) is waiting just around the corner. In the past April was the month in which a new ACS version was released
IBMi DB2 for i Multisystem In this article I will be taking a look at a feature we should all be installing, and using, on our IBM i servers. As I mentioned in a recent article I wrote on the advance job scheduler (which can be found here), IBM announced in May 2022 that half
IBMi A screen a story – What does “move active records” mean? The latest Technology Refresh (TR) for IBM i 7.4 and 7.5 has something new within them for reorganizing a file. If you have lost count of the TR levels IBM i 7.4 is at TR7 and IBM i 7.5 is at TR1. Every time a new
IBMi Node-RED & Security I gave a quick demonstration of Node-RED to a client recently and I didn’t get the response I was expecting. On bringing up the Node-RED browser interface, the first question I got asked was why doesn’t Node-RED use a TLS (Transport Layer Security), or SSL (Secure Socket Layer)
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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,
IBMi 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
IBMi A screen a story – Db2 Symmetric Multiprocessing part II The sayings are “practice what you preach” or the more down to earth expression “eat you own dogfood”. Eating your own dog food is a phrase that refers to the internal use of a company’s own products or services in its day-to-day operations. So over the years I have
IBMi ActiveMQ I’ve got a little home project that I’ve been looking at for a while. In this article, I’ll prepare our IBM i for that project. It will involve some IoT devices sending data to the IBM i. To receive that information the IBM i, will be using
IBMi Why IBM i continues to deliver excellent ROI for manufacturing and distribution IBM technology has been a key part of enterprise IT since the 1980s with platforms such as AS/400, iSeries, System i and IBM Power Systems and operating systems such as OS/400, i5/OS and IBM i. This technology is prized for its superior performance, stability and dependability. In
IBMi Power10 for the masses is finally here! In June, IBM announced the replacement for the popular 1, 2 and 4 socket Power servers which make up the mainstay of the Power installed base. If you missed it, Northdoor have covered the highlights in performance, security and scalability in our latest blog. With significant CPW improvement per core
IBMi A screen a story – Db2 Symmetric Multiprocessing Part of the announcement of IBM i 7.5 was a change in what is entitled as part of the base operating system with IBM i. If you want a complete list of the Price Change(s): Price Decrease on Selected IBM i Sofware Products please have a look at
IBMi An Advanced Job Scheduler In this article, I’ll be going back to good old green screen, well for some parts of this article! Nested in the IBM i 7.5 OS announcements made by IBM in May 2022, was the statement that half a dozen or so licensed programs will now be included
Featured It’s official – IBM have now launched their Power10 Scale out range! Whilst IBM’s Enterprise range did come out back in September 2021, that provided for the high-end Power clients only. With this release of low and mid-range servers, the capability of Power10 is made available to everyone. In a nutshell, the key benefits of Power10 are; * Enhanced Security – Power10 includes
IBMi Bring Power to the cloud with Northdoor and Skytap For organisations that run their x86 workloads on Azure, Skytap offers the ability to bring IBM Power workloads into the same cloud, co-located for low latency and high performance. With your AIX, IBM i and Linux on Power workloads in Azure, you benefit from flexible capacity and pricing with no
