• 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

• Raz-Lee Offloads Virus Scanning from IBM i with ICAP

  May 15, 2019 Alex Woodie

  Raz-Lee Security is providing IBM i shops another option when it comes to anti-virus software by offering an ICAP client that offloads CPU-intensive virus scanning activities to an external server. The new solution is being sold as an extension to Raz-Lee’s existing Anti-Virus solution.

  While the IBM i operating system is essentially immune to PC viruses, they still pose a threat to IBM i shops, which typically have a smattering of Windows desktops and servers on the network. The problem is that Windows viruses (and assorted other malware) can infect the IBM i server’s Windows-like Integrated File System (IFS), where …

  Read more

• Does Db2 Mirror Kill The Market for Third Party HA?

  May 6, 2019 Alex Woodie

  IBM launched Db2 Mirror for i two weeks ago to great acclaim, as the clustering technology puts IBM i on par with how most other major systems provide continuous availability. But will Db2 Mirror destroy the platform’s heritage of high availability solutions? IT Jungle asked IBM and the biggest providers of logical replication solutions, and the answer is no. Here’s why.

  The first thing to understand about Db2 Mirror is that, at heart, it’s a database clustering technology. IBM figured out a way to make a single instance of Db2 for i run on two separate systems, in an active-active …

  Read more

• Guru: IBM i Save File Compression Options

  April 1, 2019 Michael Sansoterra

  As I finished populating some test tables with a large volume of data on a small and transient IBM i partition in the cloud, I thought life was good. But my countenance fell as I realized the tables plus OS hogged over 70 percent of the disk space. I wondered how to get all the data into a single save file for safe keeping.

  The buzzer in my mind was loud and clear: it ain’t gonna work, you don’t have enough room. As I loathed the thought of using multiple save files to save my test data, I remembered that …

  Read more

Previous Articles