SPDEMAXTHREADS= System Option

Specifies the maximum number of threads that the SPD Engine can spawn for I/O processing.
Valid in: configuration file, SAS invocation
Default: 0
Engine: SPD Engine only

Syntax

SPDEMAXTHREADS=n

Required Argument

n
is the maximum number of threads the SPD Engine can spawn. The range of valid values is 0 to 65,536. The default is zero, which means that the SPD Engine uses the value of THREADNUM= if set. Otherwise, the SPD Engine sets the number of threads to spawn to be equivalent to two times the number of CPUs on your computer.

Details

Specifying SPDEMAXTHREADS= sets an upper limit on the number of threads to spawn for the SPD Engine processing, which includes the following:
  • WHERE expression processing
  • parallel index creation
  • any I/O processing requested by thread-enabled applications such as SAS thread-enabled procedures
SPDEMAXTHREADS= constrains the THREADNUM= data set option.