DEGREE= Data Set Option

Determines whether DB2 uses parallelism.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: ANY
Data source: DB2 under z/OS
See: DEGREE= LIBNAME option

Syntax

DEGREE=ANY | 1

Syntax Description

ANY
enables DB2 to use parallelism, and issues the SET CURRENT DEGREE ='xxx' for all DB2 threads that use that libref.
1
explicitly disables the use of parallelism.

Details

When DEGREE=ANY, DB2 has the option of using parallelism, when it is appropriate.
Setting DEGREE=1 prevents DB2 from performing parallel operations. Instead, DB2 is restricted to performing one task that, although this is perhaps slower, it uses fewer system resources.