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. See "Enable Intra-Partition Parallelism (intra_parallel)" for more information.

DFT_DEGREE

Database configuration parameter. Provides the default for the DEGREE bind option and the CURRENT DEGREE special register. See "Default Degree (dft_degree)" for more information.

DEGREE

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

CURRENT DEGREE

Special register for dynamic SQL. See the SQL Reference for more information.

For more information on the configuration parameter settings, and how to enable applications to process in parallel, see "Parallel Processing of Applications".

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 ]