onmode and n arguments: Unlock resident memory (SQL administration API)

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


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


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-residency parameter in the ONCONFIG file.

This function is equivalent to the onmode -n command.


The following example unlocks resident memory:
EXECUTE FUNCTION task("onmode","n");

Copyright© 2018 HCL Technologies Limited