SQL CPU Utilization was introduced in the IBM i 7.2 release. This metric helps you discover how much of your CPU is being used by SQL operations, and is a starting point to determine if your CPU utilization is due to SQL or other work on the system. This metric is available on a per-thread basis and aggregated for the partition as a whole.
(more…)Back in the 6.1 release, IBM moved the Work with System Activity (WRKSYSACT) command from the Performance Tools licensed program product into the base operating system. WRKSYSACT has been around for a long time, but it has a few features that you may not be aware of.
(more…)This topic is one I know many i users are very familiar with, but I get questions often enough about managing disk space that I thought a review of the parameters controlling disk space consumption and managing disk space growth would be a worthwhile topic.
(more…)