SQL CPU Utilization

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…)

Routing Work to Subsystems

In the blog Route Db2 Requests to a Specific Subsystem, I wrote how you can use the QSYS2.SET_SERVER_SBS_ROUTING procedure to route work for database queries using the QZDASOINIT or QRWTSRVR server jobs to customized subsystems. This is a new way to route work based upon the requesting user profile that augments the other ways you can route work to subsystems. 

(more…)