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 set SORTSPACE to a smaller value. Memory is then allocated in chunks of the size specified by SORTSPACE, until it has allocated the value set by SORTTEMPSPACE.
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 minimum value is 33,554,432 bytes (32MB).
Note: The minimum value is made up of the settings for SORTSPACE and SORTTEMPSPACE combined.
The maximum value is 4,294,967,295 bytes (4GB - 1 byte).
Example
SORTTEMPSPACE=64M