SPD Engine System Options

SPDEINDEXSORTSIZE= System Option

Specifies the memory space size that the sorting utility can use when sorting values for creating an index.

Valid in:	configuration file, SAS invocation, OPTIONS statement, Systems Options window
Affected by data set option:	MEMSIZE=
Default:	32M

Syntax
Details

Syntax

SPDEINDEXSORTSIZE=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 SPDEINDEXSORTSIZE= option specifies the maximum amount of memory that can be used when sorting values for creating an index. When indexes are created in parallel (because ASYNCINDEX=YES), the value you specify in SPDEINDEXSORTSIZE= is divided among all of the concurrent index creation threads.

Perform one of the following if the index creation fails due to insufficient memory:

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 space 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.

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

Top of Page