Problem:

To set the Environment variable SORTSPACE.

SORTSPACE environment variable can be used with Net Express and with Server Express.

Resolution:

====================

SORTSPACE environment variable  in Net Express Documentation:

The amount of memory to be allocated to internal workspace for SORT operations. This can be specified in different formats: for example, you could specify 64M, 2G, and 1000000 to give sort memory areas of 64 Megabytes, 2 Gigabytes and 1000000 bytes respectively.

====================

SORTSPACE environment variable  in Server Express Documentation:

SORTSPACE

Specifies the amount of memory to be allocated to internal workspace for SORT operations.

Syntax:

SORTSPACE=n[K|k|M|m|G|g]

export SORTSPACE

Parameters:

n[K|k|M|m|G|g]  The amount of memory to be allocated to internal workspace for SORT operations. K or k indicates kilobytes, M or m indicates megabytes and G or g indicates gigabytes. No letter indicates bytes. Defaults to 1 megabyte.

Comments:

A larger value for SORTSPACE will generally result in a faster sort. However, if you specify a value that exceeds the capacity of main memory in your computer, such that the operating system has to page memory in and out, performance will be degraded.

Example:

SORTSPACE=1024K

export SORTSPACE

Probably, some tests are needed to get the best value for the  environment variable SORTSPACE... its best value depends of course on the power of the machine ( memory ... ).