modify config arguments: Modify configuration parameters (SQL administration API)

Use the modify config argument with the admin() or task() function to change the value of a configuration parameter in memory until you restart the database server. Use the modify config persistent argument to change the value of a configuration parameter in memory and preserve the value in the onconfig file after you restart the server.

Read syntax diagramSkip visual syntax diagram
Syntax

>>-EXECUTE FUNCTION--+-admin-+--(------------------------------->
                     '-task--'      

>--+-"--modify config--"------------+--------------------------->
   '-"--modify config persistent--"-'   

>--,--"configuration_parameter_name"--,--"new_value"--)--;-----><

Table 1. modify config command elements
Element Description Key Considerations
configuration_parameter_name The name of the configuration parameter that you want to modify.  
new_value The new value of the configuration parameter. For information about the valid values for a configuration parameter, see Database configuration parameters.

Usage

This SQL administration API command is equivalent to using an onmode -wm or -wf command to change the value of a configuration parameter.

Examples

The following command changes the value of the DYNAMIC_LOGS configuration parameter to 2 in memory for current use:

EXECUTE FUNCTION task("modify config","DYNAMIC_LOGS",
"2");

The following command changes the value of the DYNAMIC_LOGS configuration parameter for current use. The changed value remains in the onconfig file after you restart the server.

EXECUTE FUNCTION task("modify config persistent","DYNAMIC_LOGS",
"2");

Copyright© 2019 HCL Technologies Limited