The LIBNAME Statement for Relational Databases |
Determines whether DB2 uses
parallelism.
Default value: |
ANY
|
Valid in: |
SAS/ACCESS LIBNAME
statement
|
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.