SET SORTSPACE

Use this command to dynamically reset the size of the sort space on the XDB Server. Active sorts are not affected by this command.

The new sort space size remains in effect until you restart the server or execute another SET SORTSPACE command.

Note:

This command does not write the SORTSPACE value to the server's configuration file, so that when you restart the server, sort space is reset to its original size.

Invocation

This command can be embedded in a host language or executed interactively.

Authorization

Any of the following:

A super user
A user with SYSCTRL or SYSADM privileges

Syntax

SET SORTSPACE=Kbytes

SET SORTSPACE=1000

Parameters:

bytes

Is the size of the sort space in kilo-bytes. See the Server Administration Guide for guidelines on setting an appropriate size.

For example, the following command sets the sort space to roughly one megabyte (1 million bytes):

SET SORTSPACE=1000