add memory argument: Increase shared memory (SQL administration API)

Use the add memory argument with the admin() or task() function to add to the virtual portion of shared memory.

Syntax


>>-EXECUTE FUNCTION--+-admin-+--(------------------------------->
                     '-task--'      

>--"add memory"--,--"memory_size"--)--;------------------------><

Element	Description	Key Considerations
memory_size	The size, in kilobytes, of the new virtual shared-memory segment.	This value must not exceed the operating system limit for the size of shared-memory segments. Also see admin() and task() Argument Size Specifications.

Usage

This size defaults to the SHMADD configuration parameter.

This function is equivalent to the onmode -a command.

Example

The following example adds 500 KB of virtual shared-memory:

EXECUTE FUNCTION task("add memory","500");