Category: IBM i
-
What happened to my emails?
One of the questions I get asked often is “How can you track emails sent from IBM i?” Until 7.2 this was a near impossible task. But since 7.2 WRKSMTPEMM was added to the operating system and I love it! What does it look like? If we start with a WRKSMTPEMM LISTBY(*RCP) QUEUE(*ALL) we get…
-
A NodeJS Website on IBM i – Adding Records
Continuing with my Node.js Express website on IBM i series, in this article I’ll show you how easy it is to add new records to our database. In this article, we will develop some quick scripts to add these records. It really is very simple in node. As we know now, the first step to…
-
IBM i Spooled File Management
We all love IBM i, but for many spooled file management is considered a real headache. So, what tips and tools are there to help you? Expiration Dates on Spooled Files If you find your system cluttered with old spooled files, the “days until file expires” parameter may help you. Creating spooled files with this…
-
CLEANMAIL – the folly of assumption
Bit of a short one this month as preparing for Year End tasks and shutdowns around the customers, but it gave me a little chuckle when I did it so maybe I can warn some people off the same fate! CLEANMAIL, if you aren’t familiar, is a utility from IBM that’s useful for removing old…
-
/Home bitter-sweet /Home
The Home directory is nothing new to IBM i, it’s been around for decades and yet it is not widely used. With the increase in popularity of Open Source on IBM i (including SSH) this is changing and many more users are creating their Home Directories and some are noticing an unexpected side effect. What…
-
A NodeJS Website on IBM i – Restricted Access
In the previous article we displayed, in a browser window, all the employees in our company. Probably not something you would wish to make public to the whole company! Program Flow So, how can we restrict access to the employee web page? Our flow will be: Show the login page. If a valid IBM i…
-
Raz-Lee Security Announces IBM i Security Bundles
Nanuet, New York – December 4, 2019 – Raz-Lee Security is pleased to announce that they are now offering IBM i Security Bundles to address organizations’ fundamental need for cyber, security and auditing solutions for their IBM i. In today’s world, the IBM i is no longer isolated. Technological advances have compelled IBM to open…
-
A Screen a Story “Old habits die very slowly”
IBM i Access Client Solutions (ACS) is an excellent tool to review IBM i SQL performance. My guess is that most system administrators hardly touch the option “SQL Performance Center” which can be found under the Database section when you start ACS. Below an example of what you see when you do so: The screen:…
-
HelpSystems Announces Clearswift Acquisition to Expand Cybersecurity Portfolio
MINNEAPOLIS, December 2, 2019 – HelpSystems announced today that it will acquire Clearswift, a UK-based content threat protection software company. Clearswift’s award-winning deep content inspection capability enables information to be scanned as it enters or leaves the organization, allowing sensitive data to be securely transmitted via email, or other web-based methods. Clearswift technology gives teams…
-
WRKRDBDIRE- I want data from that box..
A bit of background to start with today, I’ve recently been learning how to setup NodeJS on IBM i (again big plug here for Andy Youens series to get you started.) After completing a few tutorials, I started looking at pulling data out of the local tables using the idb-connector package, more on that another…
-
A NodeJS Website on IBM i – Database Access
Continuing my Node.js website on IBM i, in this article I’ll show you how we can access a file/table and display the results on a web page all neatly formatted. We will take our employee table, do some record selection and sort for a certain order. Before we access our database, we need to prepare…
-
How to get the Latest and Greatest
Within a few days the latest Technology Refresh for IBM i 7.4 and 7.3 will be available. The official planned availability day is 15 November 2019. For details please have a look at these two links IBM i 7.3 Technology Refresh 7 and IBM i 7.4 Technology Refresh 1 or you might try to google…