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. .

Syntax

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

>--+-"AUTO_LRU_TUNING=0-+--"--)--;-----------------------------><
   '-"AUTO_LRU_TUNING=1-'            

Usage

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.

Example

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

Copyright© 2020 HCL Technologies Limited