Category: Technical Articles
-
SQLite – Store Tweets
In my previous article, I revealed how easy it is to use an open source database called SQLite on our IBM i server. If you need a refresher, that article can be found on the link here. In this article, I’ll show you all how easy it is to use this lightweight database. Including it…
-
IBMi password – pick a number
We’ve all been there, the password expiration has come around (QPWDEXPITV) and you’re struggling to think of a new one that matches the password rules on your system. One day I decided “screw that, the system can pick for me”. Thus I started tinkering in NodeJS, as mentioned in previous articles I’m not a GUI…
-
Easily Control that runaway job using IBM i Workload Groups
How to limit high CPU jobs easily If you have any jobs or users that, every now and then, manage to impact the system by using a large amount of CPU, this trick may help. There is a catch! This method only limits jobs that have more than 1 thread. A single thread job will…
-
SQLite – What is that?
In this article, I’m going to show you another database option we now have on our IBM i. All these choices! Little did we think we would have any alternative for a database, we expected only to have the excellent DB2 for i. So, what is it? SQLite is a serverless database, self-contained and is…
-
Convert Spool File To PDF or Text File
On most systems I work on there are simply far too many spool files. Spool files are no doubt a useful source of information but what is also in no doubt is that spool file maintenance is one of the last tasks on anyone’s agenda. However, on every system there are spool files which are…
-
My source is MIA – RTVCLSRC
A bit of a follow on to my article in July last year about checking the date of source against your program. I have a customer who for their sins continues to run a V5R4 partition, part of the reason for this is if you run ANZOBJCVN you’ll kill a small forest with the number…
-
Should we strive to improve our code?
Last week, I was looking for “CPF2234 Invalid Password” messages, for a program I am writing. I assumed that I would find them in QSYSOPR, but there weren’t any. So, I tried DSPLOG and there they were. “Oh no”, I hear you say, “Why are you using 5250 Green Screen?”. I will admit that I…
-
Finding Non-Encrypted Connections to your IBM i
Connecting securely to our systems is more important now than ever before and this is just as true for IBM i as any other platform. As I’m sure you know you can encrypt your connections to IBM i at no extra cost and there have been many articles written on how to set this up.…
-
Man – Where’s that Manual Gone?
IBM has released quite a few big hitters lately, MariaDB etc., and some of the not so well known utilites have slipped under the cover. Let me take you through one of them in this article. This great utility stops you being told to RTFM (Read the manual)! So this is where this open source…
-
A screen a story – IBM i Services (SQL) to the rescue
Friday 29th January 2021 I am in a Teams meeting which is drawing to an end, when the phone is ringing. A quick text message is the response, telling the caller that I will call back within 10 minutes. The moment I prepare myself for calling back, another customer is calling. This call takes some…
-
Lock System Values
Stay Safe! If you’re looking to tighten your IBM i security, it can be quite daunting to know where to start. Do you look at securing the perimeter by looking at an exit point solution, or do embark on lengthy object level security project? Or both?! A quick win for many could be preventing the…
-
A screen a story – time to update the settings of your IBM i SMTP server
Let us face it QDLS is something of the past, back from the days when the Integrated File System (IFS) had not seen the light of day. If you have not yet abandoned using QDLS now is a good time to do so. I will not go into details, but knowing that OfficeVision and QDLS…