Modifying Configuration Parameters

You can modify configuration parameters using a variety of methods.

These methods include:

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.