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