reset config argument: Revert configuration parameter value (SQL administration API)

Use the reset config argument with the admin() or task() function to revert the value of a dynamically updatable configuration parameter to its value in the onconfig file. Dynamically updatable configuration parameters are those parameters that you can change for a session with an onmode or SQL administration API command.

Read syntax diagramSkip visual syntax diagram
Syntax

>>-EXECUTE FUNCTION--+-admin-+--(--"--reset config--"----------->
                     '-task--'                          

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

Table 1. reset config command elements
Element Description Key Considerations
configuration_parameter_name The name of the configuration parameter with the value that you want to revert.  

Usage

The reset config argument reverts the value of the configuration parameter to the last saved value in the onconfig file, even if the value was changed after the database server started.

Example

The following command reverts the value of the DYNAMIC_LOGS configuration parameter to the value in the onconfig file.

EXECUTE FUNCTION task("reset config","DYNAMIC_LOGS");

Copyright© 2019 HCL Technologies Limited