Get Started Open up ‘IBM i Client Access’, make sure you have entered the correct system, then choose ‘Database – Run SQL Scripts’. Now select ‘Run – System Debugger’. If on start-up, you get an error ‘Unknown system ‘xxxxx’ was specified – OK’, go to ‘File – Change System’. Enter the system IP address instead. […]
Backup Performance
A while ago, I was asked to look at the performance during a Save 21 ‘Save the entire system’. Basically it took a little bit longer, as time went by, due to an increase in both the size and number of objects. However there were a couple of days when the backup took much longer. […]
Overview of New Navigator for i
The NEW Navigator for i is a great improvement on the present Navigator. It is modern (just look at the screen shots), responsive (3 seconds vs 10 seconds), and fairly comprehensive (Active Job columns 126 vs 31). Click the icon top left (looks like a stack of books) and you get a list view. Notice […]
More – What is eating my IFS?
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 […]