IBMi 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.
IBMi 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
IBMi A screen a story – IBM i 7.5 – Set Subsystem Routing In 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi 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
IBMi Service Commander on IBM i In this article, I will talk about another great open-source utility for our IBM i. Firstly, what a great name! Service commander was developed by Jesse Gorsinski, the business architect of open source on IBM i. The github repository for Service Commander can be found at https://github.com/ThePrez/
IBMi A screen a story – Storage Spikes? As mentioned in my previous article, this article is all about when disk space spikes all of a sudden and how to trace the culprit. The last few year more and more of my tasks have moved from 5250 emulation to Run SQL scripts. So finding the reason why disk
IBMi Logrotate on IBM i In this article I will talk about an open-source utility that hasn’t got much airspace since it was released on our IBM i. Its called logrotate, a handly utility that can help us manage the many logs we have on our IFS. As we all know, log files can
IBMi Your IBM i server is not a fridge It feels a little crazy to have to point this out but your IBM i isn’t a bloody refrigerator! And yet, there are some users who seem to think that you can treat IBM i as they would a fridge, namely they turn it on when it’s shiny
IBMi PostgreSQL on IBM i In this article I will show you how we can install and use the very popular PostgreSQL database on our IBM i. PostgreSQL is an open source relational database management system, a DBMS developed by a worldwide team of developers. It has been around since 1986 and now available on
IBMi A screen a story – Custom Charts. Is it a hidden gem? If disk space fills up completely on IBM i, the system will eventually come to a stop. Before doing that it will get slower and slower. It is your task as a system administrator to prevent that from happening, In the past I have seen a wide variety of monitoring
IBMi A screen a story – now you see me, now you do not The life of a system administrator can be full of surprises. Things you have taken for granted, turn out to be completely different. Let me get directly to the point. All jobs being started on IBM i are logged in the history log, right? If you want to know the
IBMi Say hello to Power10 and go buy a POWER9 IBM has just announced the all new Power10 based E1080 model and it looks great! I recently wrote an article highlighting 10 things you should know about Power10, if you missed that, click here to check it out. At the moment we only have the enterprise version of the Power10
IBMi Backup Performance A while ago, I was asked to look at the performance during a Save 21 ‘Save the entire system’. Basically it took a little bit longer, as time went by, due to an increase in both the size and number of objects. However there were a couple of days when
IBMi Data-Queues with ODBC In my last couple of PowerWire articles, I have written about using data-queues and about ODBC connectivity. If you need to refresh yourself of either of the articles, the data- queues article can be found here, with the ODBC article in the link here. In this article, we are going
IBMi A screen a story – May the path be with you In the life of system administrator SQL now a necessity. It can no longer be seen as something for developers only. The new Navigator for i is the living proof for that. When working with IBM i Access Client Solutions (ACS) Run SQL Scripts (RSS) you have the option to
