A good quiz question for this article could have been: “When was the Index Advisor introduced?”. When searching the Internet I could find information going back to V3R6, which was released back in 1995. I think it is fair to say, we have all heard about it, but unfortunately we can not say that of […]

I was discussing an RFE (Request For Enhancement) with some CEAC colleagues the other day. A request has been made for IBM to formally address the ability to Enumerate User Profiles on IBM i. Now, user enumeration is not something you hear a lot about in the IBM i world yet by default it is […]

This month we are going to have a break from node.js – I can hear the cheers from here! This time we are going to look at my favourite DB2 for i services. So, good place to start, what are DB2 services? They are SQL views, procedures and functions that give us access to system […]

I mentioned in the last article an issue with one of my partitions that I’m not allowing onto the network proper. One of the challenges this gives me is making sure I keep my software up to date, when I’m used to running a command to dial out. Specifically I’m talking about the Must Gather […]

Ever wondered about the firmware level of any adapter present in a POWER server? My guess is that you probably never have or never needed to. Allow me to tell you a story which took place at the beginning of April. It all started with messages in QSYSOPR at the weekend. Messages with ID CPPEA33 […]

Inspired by Andy Youens series of articles on Node and Open Source on IBMi,  I decided to try setting up Node-red on one of my servers. I’ve also got to give credit to a post on the IBM developer site: https://developer.ibm.com/tutorials/i-running-node-red/ The main difference is that where the walk-through uses licensed program 5733OPS I decided […]