16
Changing the value of '%s' is not allowed since it is a static option.
You can set or change the value of Adaptive Server configuration parameters in one of two ways:
By executing the system procedure sp_configure with the appropriate parameters and values.
By directly editing your configuration file and then invoking sp_configure with the configuration file option.
By starting Adaptive Server with the -c option to specify a configuration file.
Configuration parameters are either dynamic or static. Dynamic parameters go into effect as soon as you execute sp_configure. Static parameters, on the other hand, take effect only after Adaptive Server has been restarted. In version 12.5, several memory-related parameters were converted from static to dynamic.
Not all parameters listed here may be available in your
Adaptive Server version.
Error 5852 occurs when you run sp_configure with the read or verify option and Adaptive Server determines that you have changed the value of the static option mentioned in the error message and have not yet shut down and restarted Adaptive Server.
No action is required unless you want the value of the static parameter to be used now. If you do, shut down and restart Adaptive Server.
Refer to “Setting Configuration Parameters” in the System Administration Guide: Volume 1 for information about configuration parameters and options.
All versions
