SPD Engine System Options

SPDESORTSIZE= System Option

Specifies the memory space size that is needed for sorting operations used by the SPD Engine.

Valid in:	configuration file, SAS invocation, OPTIONS statement, System Options window
Default:	32M

Syntax
Details

Syntax

SPDESORTSIZE=n | nK | nM | nG

n: is the size of memory space in bytes, kilobytes, megabytes, or gigabytes. If n=0, the sort utility uses its default. The valid value range is from 1,048,576 to 10,736,369,664 bytes.

Details

The SPD Engine can perform an automatic sort in parallel. The sort size you specify for SPDESORTSIZE= should be multiplied by the number of processes that are in parallel. This total should be less than the physical memory available to your process. Proper specification of SPDESORTSIZE= can improve performance by restricting the swapping of memory that is controlled by the operating environment.

Perform one of the following if the sort process needs more memory than you specified:

restart SAS with the SAS system option MEMSIZE=0(footnote 1)
increase the size of the utility file space using the SPDEUTILLOC= system option

You increase the memory that is used for index sorting using the SPDEINDEXSORTSIZE= system option. If you specify to create indexes in parallel, specify a large-enough space using the SPDEUTILLOC= system option.

Note: The SORTSIZE= option documented for the default Base SAS engine affects PROC SORT operations. The SPDESORTSIZE= specification affects sorting operations specific to the SPD Engine. [cautionend]

FOOTNOTE 1: for OpenVMS on HP Integrity Servers, increase the paging file quota (PGFLQUO); for z/OS, increase the REGION size.

Top of Page