DEGREE= LIBNAME Statement Option

Determines whether DB2 uses parallelism.

Valid in: SAS/ACCESS LIBNAME statement
Category: Data Set Control
Default: ANY
Data source: DB2 under z/OS
See: DEGREE= data set option

Table of Contents

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.

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 less system resources.

Last updated: February 3, 2026