Determines the amount of temporary memory allocated for SORT operations.
If you cannot set SORTSPACE to allocate enough contiguous memory for a SORT operation, set SORTTEMPSPACE to the required amount, and then reduce the amount allocated by SORTSPACE. The memory required for the SORT operation can then be allocated in smaller chunks.
We recommend that you use SORTTEMPSPACE only if you are receiving
COBRT105 Memory allocation error (Fatal) errors.
Parameters
- workspace size
-
Specify the amount of memory in one of the following formats:
Format
|
Workspace size
|
64M
|
64 megabytes
|
2G
|
2 gigabytes
|
1000000
|
1,000,000 bytes
|
The default value is 1,048,576 bytes (1MB).
The minimum value is 65,536 bytes (64KB).
The maximum value is 4,294,967,295 bytes (4GB - 1 byte).
Example
SORTTEMPSPACE=64M