Enable Intra-Partition Parallelism (intra_parallel)

Configuration Type

Database manager

Applies To

• Database Server with local and remote clients

• Database Server with local clients

• Partitioned Database Server with local and remote clients

Parameter Type

Configurable

Default [Range]

SYSTEM (-1) [SYSTEM (-1), NO (0), YES (1)]

A value of -1 causes the parameter value to be set to "YES" or "NO" based on the hardware on which the database manager is running.

Related Parameters

Maximum Query Degree of Parallelism (max_querydegree)

This parameter specifies whether the database manager can use intra-partition parallelism.

In a symmetric multiprocessor (SMP) environment, the default for this parameter is "YES". In a non-SMP environment, the default for this parameter is "NO". This parameter can be used on both partitioned and non-partitioned database systems.

Some of the operations that can take advantage of parallel performance improvements when this parameter is "YES" include database queries and index creation.

Note:

If you change this parameter value, packages may be rebound to the database. If this occurs, a performance degradation may occur.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]