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 […]
Easily Control that runaway job using IBM i Workload Groups
How to limit high CPU jobs easily If you have any jobs or users that, every now and then, manage to impact the system by using a large amount of CPU, this trick may help. There is a catch! This method only limits jobs that have more than 1 thread. A single thread job will […]
Should we strive to improve our code?
Last week, I was looking for “CPF2234 Invalid Password” messages, for a program I am writing. I assumed that I would find them in QSYSOPR, but there weren’t any. So, I tried DSPLOG and there they were. “Oh no”, I hear you say, “Why are you using 5250 Green Screen?”. I will admit that I […]