onmode -wf, -wm: Dynamically change certain configuration parameters

Use the onmode -wf or onmode -wm command to dynamically change specific configuration parameters.

Read syntax diagramSkip visual syntax diagram

>>-onmode--+- -wf--config_param=value-+------------------------><
           '- -wm--config_param=value-'   

Element Purpose Key considerations
-wf Updates the value of the specified configuration parameter in the onconfig file. The DBA user must have write permission for the directory that contains the onconfig file.
-wm Dynamically sets the value of the specified configuration parameter in memory. The specified value is not preserved when the server is restarted.
config_param=value Specifies the configuration parameter and its new value. See Database configuration parameters.

To see a list of configuration parameters that you can tune dynamically with an onmode -wm or -wf command, run the onstat -g cfg tunable command.

The onmode -wf and onmode -wm commands have equivalent SQL administration API functions.

Copyright© 2018 HCL Technologies Limited