IBM i Services have become quite popular, and it has become typical for new and enhanced services to be included with IBM i announcements. STACK_INFO is one of the new services that is part of the recent IBM i 7.3 TR3 / IBM i 7.2 TR7 announcement.
(more…)Trigger programs are a data-centric technology to deploy business logic by establishing code that will run (fire) when the associated triggering event occurs.
(more…)Last week I wrote about collecting performance data for database. This week I will review how you can visualize that database performance data with the Performance Data Investigator (PDI).
(more…)In the past, IBM i database performance management and analysis was done using tools specifically created for database, while system performance management and analysis was done using the system performance tools. There was little integration between the two toolsets.
(more…)It’s free. It’s simple to enable. It can improve the performance of your IBM i system. Sound interesting?
(more…)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…)