Governing of parallel processing of utilities

In Db2 11, you can manage the amount of parallelism by using the new PARAMDEG_UTIL subsystem parameter and the PARALLEL(num-subtasks) utility option.

When utilities use parallel processing, they consume more processor resources. This use of processor resources can be an issue for some utilities, such as CHECK INDEX, LOAD, REBUILD INDEX, REORG TABLESPACE, and UNLOAD. The new PARAMDEG_UTIL subsystem parameter and the PARALLEL(num-subtasks) utility option enable you to control the amount of parallelism by specifying the maximum number of subtasks that a utility can generate.