• 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

• The (More) Modern RPG Language

  December 16, 2019 Bob Cozzi

  Back in 1988, I wrote what became the book on RPG III. Then in 1996, I published the RPG IV version and updated it again circa 2000. But in the years that followed, RPG IV became mostly stale; a tweak here and there, but nothing too spectacular.

  In recent years, a wave of RPG IV enhances has been revealed, most notably free-format was completed and helped propel RPG IV, once again into a truly modern language. Although the measure of “modern” for RPG IV seems to lean toward how much free-format syntax is supported; which is ironic considering COBOL and …

  Read more

• Remain Hooks Change Management System Into GitLab

  November 13, 2019 Alex Woodie

  IBM i shops that manage their code using Remain Software’s change management software just gained a slew of new ways to hook their system into GitLab, an independent Git-based provider of DevOps solutions. The new software, TD/OMS V12 Milestone 1, also brings better integration with unit testing and cross referencing, while a new release of Remain’s Gravity bolsters management of cross-platform development projects.

  With a steady cadence of quarterly updates and one big release per year, Remain Software is endearing itself to IBM i developers who like predictability and perseverance. IBM i technology may not be moving incredibly fast at …

  Read more

• IBM i TRs Bring Database Enhancements, Too

  October 30, 2019 Alex Woodie

  The heart of the IBM i server is its database, so it’s natural that we would see some enhancements to Db2 for i with delivery of IBM i 7.4 Technology Refresh 1 and 7.3 TR 7 next month. The new features may not be earth-shaking, but they deliver some useful functionality nonetheless.

  Let’s start with some foundational changes to the database itself, including the way that database engineers architect the tables that store information in the database. With 7.4 TR1, IBM i shops can now add a new child table to the database without having an exclusive lock on the …

  Read more

• Guru: Move Objects with Access Client Solutions

  October 14, 2019 Dawn May

  Sending objects from one IBM i partition to another is a common task. Access Client Solutions’ IFS task makes it simple to copy or send objects. The IFS task was introduced in ACS in July 2016, so this is not a new development, but it may not be widely known.

  Perhaps you need to send a save file to another IBM i partition. There are several ways to do this. FTP and Secure FTP are often used, but using FTP to transfer IBM i objects involves all sorts of complications. The IBM i Knowledge Center dedicates an entire section on …

  Read more

• Maxava Hits Multiple Targets With The Same HA Arrow

  September 16, 2019 Timothy Prickett Morgan

  Downtime is never a good thing for any business, except maybe for those who sell high availability clustering and disaster recovery software for a living. And to be honest, these companies explicitly want to keep the downtime and the recovery time to the smallest period as possible. The fear of downtime should be enough to motivate us all to replicate out systems.

  But sometimes, just having two systems in a high availability cluster is not enough. Some companies need belts with their suspenders, and maybe even a bunch of different belts because they really can’t be down. To that end, …

  Read more

Previous Articles Next Articles