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.


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");