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.

Figure 1: Syntax

1  EXECUTE FUNCTION
2.1 admin
2.1 task  (
1  " modify config "
1  " modify config persistent "
2  , "configuration_parameter_name"
2  , "new_value"
2  ) ;
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");