This
parameter specifies whether or not database connections will use intrapartition
query parallelism by default.
- 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]
- NO (0) [SYSTEM (-1), NO (0), YES (1)]
A value of YES enables intrapartition query
parallelism. A value of NO disables intrapartition
query parallelism.
A value of SYSTEM causes
the parameter value to be set to YES or NO based
on the hardware on which the database manager is running. If
the number of logical CPUs on the system is > 1, when the value is
set to SYSTEM, intrapartition query parallelism is
enabled.
Note: The default value is subject to change by the DB2® Configuration Advisor after
initial database creation.
Note: - Parallel index creation does not use this configuration parameter.
- If you change this parameter value, packages might be rebound
to the database, and some performance degradation might occur.
- The intra_parallel setting
can be overridden in an application by a call to the ADMIN_SET_INTRA_PARALLEL
procedure. Both the intra_parallel setting and
the value set in an application by the ADMIN_SET_INTRA_PARALLEL procedure
can be overridden in a workload by setting the MAXIMUM DEGREE attribute
in a workload definition.