Data Set Options for Relational Databases |
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
|
- 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.
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.