IBMi

A collection of 312 posts

IBMi

IBM i Exit Points – The Power To Control and Audit

During this period of enforced lockdown Rowton Staff have been encouraged to spend more time on Training and Education. A recent webinar I watched was one from a series by Robin Tatum from HelpSystems entitled 2020 State of IBM i Security Study. https://www.helpsystems.com/cta/download-state-ibm-i-security-study-guide One of

IBMi

Act Fast IBM have announced a SWMA Amnesty

For five long years I’ve been telling anyone at IBM who would listen that we need a SWMA Amnesty, well that time has come but it’s not going to be here for long so if you want to save thousands of £/€/$ you need to act now! And talking

IBMi

A NodeJS Website on IBM i – Final Version

This article continues with my Node.js Express website on IBM i theme. Here we will ensure our ‘add a new employee’ functionality is in the same format as the update and delete functions by displaying a pop-up modal window to allow the user to input new employee details. We

IBMi

IBM i 7.4 TR2 and 7.3 TR8

We are living through some incredible times right now, I type this article whilst in Covid-19 Lockdown, I only bring this up so as to allow myself to wish you and your loved ones well and to hope that your lives are not too badly affected.  Those of you who

IBMi

IBM staff create protective face visors at home for NHS

News from IBM – As the UK faces a shortage of protective equipment in hospitals due to the ongoing crisis surrounding COVID-19, IBM staff with 3D printers are turning their devices and skills to helping alleviate the shortage by producing them themselves after an internal rallying call for expertise and supplies.

IBMi

Backup the backup of your backup

It may sound like we’re getting into some sort of recursion error, but I like to think of it as the poor mans VTL, Virtual Tape Library, and something you can try at home (I assume most of us are working at home right now.) A little bit of

IBMi

IBM Offers “Watson Assistant for Citizens” to Provide Responses to COVID-19 Questions

With COVID-19 affecting 206 countries, areas and territories, IBM (NYSE:IBM) is helping government agencies, healthcare organizations and academic institutions throughout the world use AI to put critical data and information into the hands of their citizens. With a flood of information requests from citizens, wait times in many areas

IBMi

A NodeJS Website on IBM i – Updating Records

Continuing with my Node.js Express website on IBM i theme, in this article I’ll show you how easy it is to update employee records from our database. Building on the previous article, on how to delete records, we will use the same structure to update, by using a

IBMi

A Screen a Story – Graph History.

Children and system managers have one thing in common, neither of them like to clean up mess. In one aspect children are different from system managers, they know which mess they should have cleaned up! For system managers that is not always crystal clear. We all know that IBM i

IBMi

More Save/Restore Data Area’s Worth Knowing About

Following on from my save21 article last month it transpires that there are some more system data areas worth knowing about in relation to save/restore date/time/media information. If you needed to know when a file was last saved on the system you would run command DSPOBJD OBJ(

IBMi

A NodeJS Website on IBM i – Deleting Records

Continuing with my Node.js Express website on IBM i series, in this article I’ll show you how easy it is to delete employee records from our database. In this article, we will develop some quick scripts to remove these records.  Once again, it really is very simple in

IBMi

Everyone needs a hobby - Maths on IBM i

First of all, credit to Simon Hutchinson @ RPGPGM.com and the article ‘Calculating prime numbers in RPG’ for reminding me of this. 8 years ago, when I was first learning RPG (and had slightly more hair than I do now, not sure if those two factors are related!) I decided

IBMi

A Screen a Story – The system limit is the limit.

IBM i is evolving and so is the work around IBM i. Most shops no longer have someone who is constantIy monitoring IBM i. Monitoring has been automated, be it by using the tools available in Navigator for i, watches or tools like Nagios and any other ISV tool, which

IBMi

How Long Is That Save 21 Going To Take?

I was at a customer site the other day, working on a server I hadn’t worked on before doing routine maintenance. HMC upgrade, firmware & ptf install. So what? I hear you ask. Well, everything was going well until I started the save21 (Entire System Save) prior to the

IBMi

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

IBMi

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

IBMi

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.

IBMi

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

IBMi

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

IBMi

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.

IBMi

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

IBMi

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

IBMi

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

IBMi

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

IBMi

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