Determines whether DB2 uses parallelism.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | ANY |
| Data source: | DB2 under z/OS |
| See: | DEGREE= LIBNAME option |
Table of Contents
enables DB2 to use parallelism, and issues the SET CURRENT DEGREE ='xxx' for all DB2 threads that use that libref.
explicitly disables the use of parallelism.
When DEGREE=ANY, DB2 has the option of using parallelism when it is appropriate.
Specifying 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.