Data Set Options for Relational Databases |
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 |
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.
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.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.