
404 OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4
cause even more resources to be consumed. If the resources are not available, the
computing resources will be overcommitted and the throughput will be reduced.
Work Management and SMP
With SMP-enabled workloads, Work Management processes are the same, and yet different.
Work Management is the same given that the tasks and threads use the parent job’s run
priority and memory pool. Work Management is different given that the tasks and threads are
working on behalf of the parent job.
To prevent the database engine from consuming all the computing resources for parallelism, ...