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


1  EXECUTE FUNCTION
1 admin
1 task
2  (
2  "add memory" , "memory_size"
2  ) ;
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");