syscurconfigs

master database only

Description

syscurconfigs is built dynamically when queried. It contains an entry for each of the configuration parameters, as does sysconfigures, but with the current values rather than the default values. In addition, it contains four rows that describe the configuration structure.

Columns

The columns for syscurconfigs are:

Name	Datatype	Description
config	smallint	Configuration parameter number.
value	int	The current run value for the parameter with integer datatype. Its value is 0 for the parameters with character datatype.
comment	varchar(255)	Amount of memory used by each configuration parameter, represented in a string format. Values marked with a hash mark (#) share memory with other parameters.
status	int	Either of the following: 1 – dynamic 0 – parameter takes effect when Adaptive Server is restarted
value2	varchar(255)	The current run value for the parameter with the character datatype. Its value is NULL for parameters with the integer datatype.
defvalue	varchar(255)	Default value of the configuration parameter.
minimum_value	int	Minimum value of the configuration parameter.
maximum_value	int	Maximum value of the configuration parameter.
memory_used	int	Integer value for the amount of memory used by each configuration parameter.
display_level	int	Display level of the configuration parameter. The values are 1, 5, and 10.
datatype	int	Datatype of the configuration parameter.
message_num	varchar(20)	Message number of the sp_helpconfig message for this configuration parameter.
apf_percent	varchar(10)	The current run value for the asynchronous prefetch percent for a buffer pool. Valid only for rows that represent buffer pools.
unit	varchar(20)	Unit of the parameter. Values are: not applicable – parameter has no units number – number of items clock ticks – number of clock ticks microseconds milliseconds seconds minutes hours days bytes kilobytes megabytes memory pages (2k) virtual pages (2k) logical pages percent ratio switch – a Boolean value id – ID number name rows
type	varchar(10)	Specifies whether a configuration parameter is declared dynamic or static in its structure definition. Values are: dynamic – takes effect immediately static – takes effect after restarting Adaptive Server