Warning :- The main SQL statement may run for many minutes. In my case just over 1:30 elapsed and 35 CPU seconds, but I only have 222,000 objects in my IFS on a Power 9. I have run the QSRSRV (see below) on a Power 7+ with around a million objects in the IFS and […]
How to delete directories from your IFS
This article was inspired by a recent support call I received. It made me realise that many of you may not have noticed that IBM added a handy parameter to the RMVDIR (remove directory) command back in v6.1 called SUBTREE. Let me set the scene and you can work out whether this is something that […]
New product round-up: IFS gets multi-threaded replication and better monitoring
As previewed exclusively by PowerWire back in November last year, Maxava has released a new version of Maxava HA with fully dynamic multi-threaded IFS replication. Replication speeds have long been an Achilles heel for some real-time solutions that have only been able to run IBM i IFS replication in a single-thread mode or with very […]
Multi-threaded replication speeds IFS backups
Maxava is gearing up to introduce multi-threaded IFS replication to help firms back up their ever-increasing mountains of data faster. According to the HA specialist, IBM i replication solutions have generally only been able to run IFS replication in single-threaded mode until now. This, in effect, drip-feeds data replication – which can be a problem […]
Robot/SCHEDULE gets file event monitors
The latest version of HelpSystems’ Power i job scheduling and batch management tool Robot/SCHEDULE features new file event monitors. In Robot/SCHEDULE version 12, event monitors can be set to watch for IFS file creation, removal and growth as well as physical file member changes that are used to trigger jobs further down the job stream. […]