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
EXECUTE FUNCTION
{
admin
| task
}
( "onmode"
,"r" )
;
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");