Previous Page | Next Page

Data Set Options for Relational Databases

DEGREE= Data Set Option



Determines whether DB2 uses parallelism.
Default value: ANY
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: DB2 under z/OS

Syntax
Syntax Description
Details

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, while perhaps slower, uses less system resources.

Previous Page | Next Page | Top of Page