sp_configure Output

The values sp_configure prints vary, depending on your platform and on what values you have already changed.

This output shows the type of information sp_configure prints if your display level is comprehensive, and you execute sp_configure with no parameters:

sp_configure
Group: Configuration Options

Group: Backup/Recovery

Parameter Name        Default Memory Used Config Value Run Value Unit Type
--------------        ------- ----------- ------------ --------- ---- ----
allow remote access         1          0          1         1    switch dyn
print recovery info         0          0          0         0    switch dyn
recovery interval in m      5          0          5         5    minutes dyn
...

Note: All configuration groups and parameters appears in output if your display level is set to “comprehensive.”

where:

The “Default” column displays the default value. If you do not explicitly reconfigure a parameter, it retains its default value.
“Memory Used” shows the amount of memory, in kilobytes, used by the parameter at its current value. Some related parameters draw from the same memory pool. For instance, the memory used for stack size and stack guard size is already accounted for in the memory used for number of user connections. If you added the memory used by each of these parameters separately, the sume is more than the amount actually used. Parameters that “share” memory with other parameters are marked with a hash mark (“#”).
“Config Value” displays the most recent value to which the configuration parameter has been set. When you execute sp_configure to modify a dynamic parameter:
- The configuration and run values are updated.
- The configuration file is updated.
- The change takes effect immediately.
When you modify a static parameter:
- The configuration value is updated.
- The configuration file is updated.
- The change takes effect only when you restart SAP ASE.
“Run Value” displays the value SAP ASE is currently using. It changes when you modify a dynamic parameter’s value and, for static parameters, after you restart SAP ASE.

“Unit” displays the unit value of the configuration parameter. SAP ASE displays information in the following units:

Name of Unit	Unit Description
number	Number of items.
clock ticks	Number of clock ticks.
microseconds	Number of microseconds.
milliseconds	Number of millisecond.s
seconds	Number of seconds.
minutes	Number of minutes.
hours	Number of hours.
bytes	Number of bytes.
days	Number of days.
kilobytes	Number of kilobytes.
megabytes	Number of megabytes.
memory pages (2K)	Number of 2K memory pages.
virtual pages (2K)	Number of 2K virtual pages.
logical pages	Number of logical pages. This value depends on the logical page size your server is using: 2, 4, 8, or 16K.
percent	Value of the configured parameter as a percentage.
ratio	Value of the configured parameter as a ratio.
switch	Value of the parameter is either TRUE (the parameter is turned on), or FALSE.
id	ID of the configured parameter you are investigating.
name	Character string name assigned to the run or configure value of the parameter. For example, “binary” appears under the “Run Value or “Config Value” column for the output of sp_configure "lock scheme".
row	Number of rows

“Type” displays whether the configuration option is static or dynamic. Changes to static parameters require that you restart SAP ASE for the changes to take effect. Changes to dynamic parameters take effect immediately without having to restart SAP ASE.