onmode and r arguments: Force residency of shared memory (SQL administration API)

Use the onmode and r arguments with the admin() or task() function to start forced residency of the resident portion of shared memory.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--"onmode"--,--"r"--)--;------><
                     '-task--'                              

Usage

The RESIDENT configuration parameter must be set to 1 in the ONCONFIG file before you can run this function.

This function does not affect the value of the RESIDENT configuration parameter, the forced-memory parameter in the ONCONFIG file.

This function is equivalent to the onmode -r command.

Example

The following example starts forced residency of shared memory:
EXECUTE FUNCTION task("onmode","r");

Copyright© 2019 HCL Technologies Limited