Category: Technical Articles
-
A screen a story – IBM i 7.5 – Set Subsystem Routing
May the third IBM i 7.5 was announced, if you follow the IBM i news, this announcement was hard to miss. Normally it does take a while before every IBM i LPAR is running this version, but this time things are little different. First of all, the date IBM I 7.5 will be available is…
-
LFTP on IBM i
If you know all about the TCP/IP utility FTP, you will feel right at home with this nifty utility. If you are fed up with all the virus’s in the open-source utility FileZilla, give lftp a try. You will not be disappointed. As the man page for lftp states; lftp is a file transfer program…
-
Dot Files on IBM i
For those who have been following my bite size BASH tutorial on You Tube, I thought it about time I wrote an article about a very useful BASH utility that’s available for our IBM i, and of course, plug my BASH videos at https://bit.ly/3IXBkm6 at the same time! This helpful utility was developed by my…
-
A screen a story – SQL Performance – a Table Scan
In today’s world it is impossible to limit yourself to the green screen when we are talking about IBM i performance and SQL performance in particular. For some shops the IBM i database has become the spider in the database “web”. I assume we have all heard about the Plan Cache and the Index Advisor…
-
Tech Tips – Maximum Number of Object owned by a User Profile
By Paul Tinker – Covenco I had a customer send out the “Bat Signal” late on a Sunday night, their application had completely stopping working but when it came to error messages, there was nothing much showing anywhere on the system. They tried to restart their application services, but to no avail. They had even…
-
Rant for better security on IBM i
This rant is intended as a wakeup call to companies and ITSecurity experts.I have 25 years of experience in Security on IBM i and all too often my observation of the poor implementation of IBM i Security of many companies is truly alarming! All players are responsible for this situation, but first and foremost companies. One would have thought…
-
Probably the best Interactive Debugger on the IBM i
Get Started Open up ‘IBM i Client Access’, make sure you have entered the correct system, then choose ‘Database – Run SQL Scripts’. Now select ‘Run – System Debugger’. If on start-up, you get an error ‘Unknown system ‘xxxxx’ was specified – OK’, go to ‘File – Change System’. Enter the system IP address instead.…
-
How to find the right IBM i printer configuration
You might think that we live in a world of standards and that any printer would be able to work out of the box with any server. Well sadly, you would be wrong. Whilst this would be the easiest thing in the world to achieve, the one thing that is consistent about all the worlds…
-
A screen a story – A Better way to Retire the Heritage Navigator for i
Let me cut right to the chase, if you have read or have not the article of last month titled: “A screen a story – Retire the Heritage Navigator for i”, forget about it. If, however you do not have the option to apply PTFs in the short term and you are concerned about this…
-
How Can You Update Your UAK Key without an HMC?
I was working at a customer last week when I noticed the system attention light was illuminated on their Power 9 Server. Looking at WRKPRB (work with problems) log, the SRC code was A7004761 which is the code for an expired Update Access Key (UAK). What is a UAK? If you are wondering what a…
-
NCDU on IBM i
Yes, I am continuing my amazing journey with open source on the IBM i. In this article I’ll be taking a look at another one of the open source utilities that has slipped under the covers… This time it is NCurses Disk Usage, or NCDU from now on. This is a disk storage utility, with…
-
A screen a story – Retire the Heritage Navigator for i
Although the log4j media storm of December 2021 has settled and is part of what we call the past. IBM did publish a document titled Security Bulletin: IBM i components are affected by CVE-2021-4104 (log4j version 1.x) When looking at this document you will find a section called “Workarounds and Mitigations”, in there you can…