Category: Technical Articles
-
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…
-
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:…
-
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…
-
IBM Must Gather Tool – Your Best Friend In Times Of Trouble
Oh no! and just when everything was running so well. There’s a problem with the system and you have logged a Problem Management Report (PMR) with IBM. You get a response from IBM asking you to manually collect all kinds of disparate information from areas of the system you might never have delved into before.…
-
Download Director – now with less Oracle
For those of you who haven’t already read it, I’d highly recommend starting with Steve Bradshaws article “Do I need to pay for Java?” from January. After following the setup guide on the IBM site so that I was using OpenJ9 I was left with the question “I’d rather like to use Download Director, how…