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