The entire environment shuts down and then restarts

While DB2 employs static parallelism across its partitions, it also uses intra-partition, or dynamic, parallelism. Dynamic parallelism allows the optimizer to assign a specific number of parallel tasks within each parti-tion, based on individual query requirements.

This approach has a number of implications. Fewer partitions are needed because parallel query performance is not constrained by the num-ber of partitions. Consider the impact on a simple query:

Figure 5.9 Dynamic parallelism after redistribution.