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 that 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
-
increase the size of the utility
file space using the SPDEUTILLOC= system option
You increase the memory space 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.
The maximum SPDEINDEXSORTSIZE=
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 hosts systems
that have a 32-bit LONG data type, SPD Engine honors only the memory
used up to 2 GB. The SPDEINDEXSORTSIZE 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.