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

Read syntax diagramSkip visual syntax diagram
>>-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");

Copyright© 2019 HCL Technologies Limited