onmode, wm, and AUTO_LRU_TUNING arguments: Change LRU tuning status (SQL administration API)

Use the onmode, wm, and AUTO_LRU_TUNING arguments with the admin() or task() function to change the LRU tuning status without updating the onconfig file. .


Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--"onmode"--,--"wm"--,--------->



Use the AUTO_LRU_TUNING =1 argument to enable automatic LRU tuning.

Use the AUTO_LRU_TUNING=0 argument to disable automatic LRU tuning .

This function is equivalent to the onmode -wm AUTO_LRU_TUNING command.


The following example enables automatic LRU tuning:
EXECUTE FUNCTION task("onmode","wm","AUTO_LRU_TUNING=1");

Copyright© 2018 HCL Technologies Limited