This parameter specifies the default value for the CURRENT DEGREE special register and the DEGREE bind option.
The default value is 1.
A value of 1 means no intrapartition parallelism. A value of -1 (or ANY) means the optimizer determines the degree of intrapartition parallelism based on the number of processors and the type of query.
The degree of intrapartition parallelism for an SQL statement is specified at statement compilation time using the CURRENT DEGREE special register or the DEGREE bind option. The maximum runtime degree of intrapartition parallelism for an active application is specified using the SET RUNTIME DEGREE command. The Maximum Query Degree of Parallelism (max_querydegree) configuration parameter specifies the maximum query degree of intrapartition parallelism for all SQL queries.