Administration Guide

Enabling Parallelism for Queries

There are two types of query parallelism: intra-partition parallelism and inter-partition parallelism. Either type, or both types, can be used depending on whether the environment is a single-partition or multi-partition environment.

Enabling Intra-Partition Query Parallelism

In order for intra-partition query parallelism to occur, you must modify database configuration parameters and database manager configuration parameters.

INTRA_PARALLEL

Database manager configuration parameter. Refer to Administration Guide, Performance for more information on this parameter.

DFT_DEGREE

Database configuration parameter. Provides the default for the DEGREE bind option and the CURRENT DEGREE special register. Refer to Administration Guide, Performance for more information on this parameter.

DEGREE

Precompile or bind option for static SQL. Refer to the Command Reference for more information.

CURRENT DEGREE

Special register for dynamic SQL. Refer to the SQL Reference for more information.

For more information on the configuration parameter settings, and how to enable applications to process in parallel, refer to "Configuring DB2" in the Administration Guide, Performance.

Enabling Inter-Partition Query Parallelism

Inter-partition parallelism occurs automatically based on the number of database partitions and the distribution of data across these partitions.

[ DB2 List of Books | Search the DB2 Books ]