The
SPD Engine can perform an automatic sort in parallel. The sort size that you specify for SPDESORTSIZE=
should be multiplied by the number of processes that are in parallel. This total for
sort size should be less than the physical memory available to your process. The 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 (For z/OS, increase the REGION size.)
-
increase the size of the utility
file space using the SPDEUTILLOC= system option
You increase the memory
that is used when sorting values for creating an index using the SPDEINDEXSORTSIZE=
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.
The maximum SPDESORTSIZE= value is 10 GB, but this value cannot be honored on host
systems that are limited to 2 GB. On host systems that have a 64-bit LONG data type,
SPD Engine honors values greater that 2 GB. On host systems that have a 32-bit LONG
data type,
SPD Engine honors only the memory used up to 2 GB. The SPDESORTSIZE option value can
be set to a larger value, but the larger value is not honored.
Note: You receive a warning in
the SAS log when the larger value is not honored and used.