reset config all argument: Revert all dynamically updatable configuration parameter values (SQL administration API)

Use the reset config all argument with the admin() or task() function to revert the values of all dynamically updatable configuration parameter to their values 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 all--"------->
                     '-task--'                              

>--)--;--------------------------------------------------------><

Usage

The reset config all argument reverts the values of all dynamically updatable configuration parameters to the last saved values in the onconfig file, even if the values were changed after the database server started.

Example

The following command reverts the value of all dynamically tunable configuration parameters.

EXECUTE FUNCTION task("reset config all");

Copyright© 2019 HCL Technologies Limited