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

Route Db2 Requests to a Specific Subsystem

We all know that a key advantage to IBM i is the work management capabilities, in particular the ability to segregate work into different subsystems.  One of the more challenging areas for this, however, has been prestart server jobs.  By default, these prestart jobs run in the QUSRWRK subsystem.  You can configure the subsystem in which these prestart server jobs run by routing the requests based upon the client IP address, but that’s often not sufficient.  Many requests may come from one IP address, or perhaps you would like to segregate work based upon some other criteria – for example, the requesting user profile.

(more…)