• 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

• Is Authority Collection The Right Thing For IBM i Security?

  August 12, 2019 Alex Woodie

  In the past two releases of IBM i, Big Blue has added new security capabilities in the form of the authority collection that allow administrators to see exactly what authorities users need to use their applications. While some welcome authority collection as helping to tighten the security of IBM i applications, others in the IBM i community wonder if the new information is helping at all.

  Authority collection debuted in 2016 with the launch of IBM i version 7.3. When the feature is activated, it monitors what authorities (such as ALLOBJ, SECADM, and so forth) are being called as users …

  Read more

• Remain Breaks New Ground With ALM Suite

  July 15, 2019 Alex Woodie

  Coding season just ended for Remain Software, the Dutch application lifecycle management (ALM) vendor with a growing US presence. That means customers are sorting through a torrent of new functionality in its flagship TD/OMS product, including improved hooks to DevOps tools like Git and Jenkins, a new cross-platform cross-reference module, and a nifty API generator too.

  New stuff started emerging from Remain Software around the POWERUp conference in May, when IT Jungle sat down with company representatives to talk about development trends, current and upcoming releases of Remain’s software, and what customers are looking to get next.

  Arguably the biggest …

  Read more

• Guru: Finding Large Files With Python

  July 15, 2019 Mike Larsen

  It’s always a good idea to purge files that aren’t needed any longer. Chances are that you already have procedures in place to purge data from Db2 files and tables, but what about files that reside in the IFS? Do you have a good solution for keeping the IFS clean?

  Perhaps you have old order files stored in the IFS. If you work for a large company, these types of files can accumulate quickly. I’ve written processes in the past to remove files from the IFS using RPG, but I’d like to offer an alternative. I’m going to show how …

  Read more

• IBM Bolsters ACS with Database and Administrative Goodies

  May 15, 2019 Alex Woodie

  Amid the many enhancements that IBM has delivered with IBM i 7.4 and IBM i 7.3 TR6 is a new release of Access Client Solutions (ACS), which has become the go-to client interface that many IBM i professionals use to access the system for a variety of tasks. Database engineers and system administrators are the big winners with this release.

  There’s no denying that IBM delivered a whopper of release with IBM i 7.4 and its sidekick, IBM i 7.3 TR6. There’s been so much news – starting with the availability and security enhancements in Db2 Mirror and Authority Collection …

  Read more

Previous Articles