Sort Buffers

sort buffers nn

where nn is the maximum amount of memory (KB) that can be used when sorting data. If the requested amount of memory is not available, all available memory up to the limit specified by nn is used.

During a sorting process, fields of data to be sorted are extracted and put into sort records that are placed into sort buffers. Then, either the entire sort is performed in available memory or, if not enough memory is available, sort records spill into temporary disk files (the zimstxxx files).

A sort that occurs entirely in memory is quickest. If a sort process must use disk space, the records placed in temporary disk files must be merged back into the sorted order, resulting in reduced performance.

A high value for sort buffers has two effects:

Sort buffers space is acquired only during a sorting process and is returned once the sort is completed.

Set operations (UNION, INTERSECT, and MINUS) and the KEEP subcommand generate sort operations internally. Their speed is therefore also affected by the amount of sort buffer space.

Valid Settings

nn = numeric entry 100 to 10000

Windows

1000

UNIX

1000