You can modify configuration parameters using a variety of methods.
Executing sp_configure with the appropriate parameters and values,
Editing your configuration file and then invoking sp_configure with the configuration file option, or
Specifying the name of a configuration file at start-up.
Configuration parameters are either dynamic or static. Dynamic parameters take effect as soon as you execute sp_configure. Static parameters require memory to be reallocated, so they take effect only after you have restarted SAP ASE. The description of each parameter in this chapter indicates whether it is static or dynamic.
SAP ASE writes the new value to the system table sysconfigures and to the configuration file when you change the value. The current configuration file and sysconfigures reflect configured values, not run values. The system table syscurconfigs reflects current run values of configuration parameters.