Routing Work to Subsystems

In the blog Route DB2 Requests to a Specific Subsystem, I wrote how you can use the new 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…)