sp_configure Syntax Elements

sp_configure includes a variety of variables to help you configure SAP ASE.

parameter – is any valid SAP ASE configuration parameter or parameter substring.
value – is any integer within the valid range for that parameter. (See the descriptions of the individual parameters for valid range information.) Parameters that work as toggles have only two valid values: 1 (on) and 0 (off).
group_name – is the name of any group in the parameter hierarchy.

sp_configure parses each parameter (and parameter name fragment) as “%parameter%”. A string that does not uniquely identify a particular parameter returns values for all parameters matching the string.

The following example returns values for all configuration parameters that include “lock,” such as lock shared memory, number of locks, lock promotion HWM, server clock tick length, print deadlock information, and deadlock retries:

sp_configure "lock"

Note: If you attempt to set a parameter value with a nonunique parameter name fragment, sp_configure returns the current values for all parameters matching the fragment and asks you to specify a unique parameter name.