PowerWire Editor

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

News

Raz-Lee Security Announces iSecurity Web GUI

Nanuet, New York – March 19, 2020 – Raz-Lee Security announces the release of iSecurity Web GUI. This agentless interface runs the regular iSecurity GUI in a web browser. It has been tested on various browsers including Chrome, Firefox, and Edge. With Web GUI, IBM i sysadmins can utilize the full depth

News

Remain Software Milestone Enhancements Boost Efficiency and Productivity for Organizations on IBM i and Multi-platform

NIEUWEGEIN, Netherlands — Remain Software delivered today its latest “Milestone” releases for the company’s three signature change-management, workflow and API editing and management tools: TD/OMS, Gravity and OpenAPI Studio. In line with the company’s longstanding commitment to ongoing product and customer support, today’s Milestones mark the second

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

News

Shield Advance becomes Remains Software newest partner

Toronto, Ontario – Announcing Canadian-based Shield Advanced Solutions has become Remain’s newest partner providing their software and services in the marketplace. Shield and Remain technical teams have collaborated on several projects. Says Chris Hird Director, “It makes perfect sense. We see Remain’s change management solutions as a valuable addition

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

News

TD/OMS and Gravity “Milestone 1” Enhancements Streamline Efficiency and Advance Application Development Potential for Remain Software Customers

Remain Software released this Wednesday TD/OMS V12 Milestone 1 and Gravity V5 Milestone 1, in line with the company’s longstanding commitment to ongoing support for its signature application-lifecycle management, workflow and DevOps solutions. These Milestones deliver the first of three scheduled enhancements each to TD/OMS version 12