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
|
