Category: Technical Articles
-
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 within the cost of the OS. Great…
-
An Ansible Environment Setup
Firstly, thank-you to all those who attended my Ansible workshop and presentation of Visual Studio Code at the i-UG conference at Northampton in June. It was great to be back presenting and meeting up with friends. This article is related to this event. The Power servers for the event, were kindly provided by Rowton IT…
-
A screen a story – Enabling SSL/TLS for IBM Navigator for i
In today’s world there is a lot of emphasis on IT security. Not strange when the word “Hack” is a word you often hear or read when following the daily news. We all know that there is no better security level possible than security implemented at the source level. I like bringing examples to life…
-
An Ansible IBM i Disk Checker
This article slightly deviates from my usual open source articles on IBM i. I say slightly, as this article will be about Ansible and yes Ansible is open-source. Thank-you Red Hat. This article will not be an introduction to Ansible. My good friend Glenn Robinson, has written a great couple of PowerWire articles on that…
-
WRKRDBDIRE part 2 – MYSELF and DDMDRDA
Some of you may remember an article I wrote in December 2019 about using WRKRDBDIRE and DDM to get data from a V5R4 system. Recently I came across a couple of extra scenarios when pulling data from systems, so it seems a perfect opportunity for a part 2 article. First off, what if I want…
-
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.…