Normally, what is the cpu usage of the DB2 started tasks, highest to lowest? would the order go DBM1, DIST, MSTR then IRLM? Depending of course if you have distributed processing...........
I think it depends greatly on your shop. Some sites do low DISTSERV processing, but in most, it should dominate.
IRLM is most important region for priority, because we want Locks to be real fast if granted. However it has far less total work to do. Thank god for Lock Avoidance. Lock CPU is sync processing capable of being charged back to the application. Not sure if that is true for an IRLM delegated to resolve a Data Sharing inter member contention.
DBRM1 does by far the most work encompassing Data Manager, Index Manager, Buffer Pool Manager, and even Relational Data System Manager, and Native Stored Procs, but charges most of its processing back to the application or to DISTSERV. What remains is largely Dataset Open and Closes (TCB time), and Async Prefetch (SRB time) these days offloadable to zIIP processors. So DBM1 can appear quite low. If its GP CPU gets high, that is a worry, for possiblly Dataset Opens and Closes.
MSTR looks after System Admin tasks, like Log Switch and Archive, as just one example, and CPU will be for things that cannot be attributed back to application.
So most DB2 regions appear to use far less CPU than the total work being done by DB2 or even by that region. That is why mostly we don't look closely at CPU in the IRLM, MSTR, and DBM1 regions, unless they have got quite significant.
Before offload to zIIP, one colleague used to say that he expected DBM1 SRB (Prefetch) to be about 10 times higher than TCB (Open and Closes) in normal systems. I would say, wogwash! The 2 measures have nothing to do with each other and the ratio is meaningless. Very high TCB, I would be concerned, but without any concern of its ratio to Prefetch work. Prefetch CPU could fluctuate widely depending on tuning of access paths to scan or to use better indexes.
So relativity of CPU between the regions could be somewhat limited in meaning too.
DB2 Application Performance Specialist