• Feeling Insecure About The Weak Security At Most IBM i Shops

  February 8, 2021 Timothy Prickett Morgan

  It is always a wonder to us that, in this day and age, every IBM i shop, which is by definition running mission critical workloads, is not using high availability clustering of systems in their datacenter, disaster recovery and failover of some type or another to a remote site, and supplemental security to lock down those parts of the system that are not, by default within the IBM i platform, locked down.

  It’s a bit of a mystery. Of the 120,000 to 150,000 unique customers running IBM i platforms in the world, maybe 20,000 have some sort of HA/DR and …

  Read more

• New Release Of ACS Now Available

  December 9, 2020 Alex Woodie

  IBM delivered a new release of Access Client Solutions (ACS) last week, right on schedule. With ACS version 1.1.8.6, users will find a host of new features designed to accelerate their productivity across a range of uses.

  ACS is the Java-based utility that has become one of the most used (and useful) ways that administrators, programmers, and engineers can interact with the IBM i server. The software, which is free to IBM i customers on maintenance, features a 5250 emulator, 5250 printer emulation, data transfer capabilities, IFS file viewing, spool file management, and a virtual console for LAN and HMC …

  Read more

• Big Blue Bolsters IBM i High Availability And Data Resiliency

  October 19, 2020 Alex Woodie

  High availability and data resiliency are critical topics in the minds of business owners these days, especially in light of the summer’s disasters, both natural and manmade. To that end, in the latest batch of Technology Refreshes, IBM has bolstered the services that provide high availability and data resilience in IBM i, PowerHA, and BRMS.

  Backup, Recovery, and Media Services (BRMS) is the licensed product that thousands of IBM i shops use to automate their backups and recoveries. Those backups usually involving tape, which was cited by 48 percent of IBM i shops in the 2020 IBM i Marketplace Survey …

  Read more

• Db2 And SQL Services Get Upgrades With TRs

  October 12, 2020 Alex Woodie

  Among the biggest enhancements that IBM is bringing to IBM i with the latest batch of Technology Refreshes are new capabilities added to the integrated Db2 database and, specifically, the slew of SQL-based services that retrieve all types of data from the platform for IBM i professionals.

  As we previously told you, IBM has decided to rename SQL Services, which were the collection of pre-defined SQL queries that recreate traditional IBM i commands and sometimes bring something entirely new. The growing gaggle of services (or perhaps it’s a herd?) are now being officially referred to as IBM i services, …

  Read more

• How The Latest TRs Bolster The Core IBM i OS

  October 7, 2020 Alex Woodie

  Yesterday was Technology Refresh (TR) day for IBM and its IBM i operating system, and Big Blue didn’t disappoint. The company unveiled new releases of IBM i 7.4 and 7.3 that bring a slew of new capabilities to the core operating system as well as surrounding offerings like Db2 Mirror, ACS, and RDi. In this article, we’ll look at enhancements to the core OS and related key features.

  During a COMMON webcast Tuesday, IBM i Chief Architect Steve Will touched broadly on a number of enhancements that soon will be available in the TRs. Most of the new capabilities will …

  Read more

• Is Information Overload Hurting IBM i Security?

  September 28, 2020 Alex Woodie

  What is wrong with IBM i security? If you look at surveys and reports, you would be hard pressed to find something that is not broken. From excessive authority and ransomware, to exit programs and default passwords, it can feel as if IBM i servers are rife with security failures.

  IBM i shops are certainly aware of the security shortcomings. Security has been rated the number one concern in each of the past two IBM i Marketplace studies conducted by HelpSystems. In the most recent report, 77 percent of respondents rated security a top concern, the highest percentage …

  Read more

• Raz-Lee Simulates Ransomware Attack on IBM i

  August 12, 2020 Alex Woodie

  How would your IBM i server react to a ransomware attack? Would it successfully repel the invaders, or would it give the bad guys what they’re after: chaos and bitcoin? Simulating a ransomware attack is the gist of a new feature in Anti-Ransomware from Raz-Lee Security, which recently shipped a new release of the software.

  Raz-Lee Security debuted Anti-Ransomware back in 2018, a year after a pair of widespread ransomware attacks (WannaCry and Petya) made the computing world sit up and take notice of the new security threat blossoming on the Internet.

  Anti-Ransomware uses a rules-based approach to detect …

  Read more

• IBM Rolls Out ACS 1.1.8.5

  August 12, 2020 Alex Woodie

  IBM last week introduced a new release of Access Client Solutions (ACS), the popular IBM i client that’s used by administrators, programmers, and engineers alike. There are enhancements to Run SQL Scripts, new 5250 viewing options, and a performance boost for viewing selected files on the IFS with version 1.1.8.5, among other mostly minor updates.

  According to the release notes associated with the new iteration of ACS, IBM made a handful of changes with version 1.1.8.5.

  Let’s start with the improvements to Run SQL Scripts, which is an increasingly popular utility in ACS that leverages the power of SQL and …

  Read more

• Guru: Creating PDF Documents With Python

  July 27, 2020 Mike Larsen

  I’m often asked to create reports for my business partners. The format of the report depends on who made the request. If the financial team made the request, I may produce an Excel file. The CEO may want to report quarterly sales to their shareholders. In that case, I may produce a PDF using the company letterhead.

  In a prior article, I showed how to create Excel files using Db2 tables. Now I’m going to show how to create PDF documents using Db2 tables.

  This story contains code, which you can download here.

  I always start by making …

  Read more

• Guru: Copy OUTQ To PDF

  February 3, 2020 Bob Cozzi

  A long time ago I created a CL command named Copy from OUTQ (CPYOUTQ). This command allowed you to selectively copy spooled files from one OUTQ to either another OUTQ or to the IFS as a PDF or text file. My customers use it all the time for monthly archiving of spooled files and redistribution of output. You may have it on your own system.

  Being one of the handful of original advocates for the so called “Openness APIs” for IBM OS/400 (now IBM i), I quickly embraced the system APIs and have used them extensively throughout the decades. One …

  Read more

Previous Articles