Chapter 1: System Tables

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)	Comments about the configuration parameter. For internal use..
status	int	Value that represents the type of configuration parameter. For details, see Table 1-5.
value2	varchar(255) null	The current run value for the parameter with the character datatype. Its value is NULL for parameters with the integer datatype.
defvalue	varchar(255) null	Default value of the configuration parameter.
minimum_value	int null	Minimum value of the configuration parameter.
maximum_value	int null	Maximum value of the configuration parameter.
memory_used	int null	Integer value for the amount of memory used by each configuration parameter. Negative values indicate memory shared.
display_level	int null	Display level of the configuration parameter. The values are 1, 5, and 10.
datatype	int null	Datatype of the configuration parameter.
message_num	int null	Message number of the sp_helpconfig message for this configuration parameter.
apf_percent	int null	The current run value for the asynchronous prefetch percent for a buffer pool. Valid only for rows that represent buffer pools.
nodeid	tinyint null	Reserved for future use
unit	varchar(20) null	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) null	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.
nodeid	tinyint null	Reserved for future use

Table 1-5 provides information about the status column.

**Table 1-5: Status column description**
Status type	Decimal	Hex	Description
CFG_NO_OPTIONS	0	0x0	Parameter has no options.
CFG_SYSTEM_OPTION	1	0x01	Parameter is a system option.
CFG_SYSTEM_GROUP	2	0x02	Parameter is a system group.
CFG_STATIC	4	0x04	Parameter is static.
CFG_DYNAMIC	8	0x08	Parameter is dynamic.
CFG_CALCULATED	16	0x10	Parameter is calculated.
CFG_READONLY	32	0x20	Parameter is read-only.
CFG_MEMORY_USED	64	0x40	Parameter consumes memory.
CFG_CONFIG_FILE	128	0x80	Parameter is externally visible.
CFG_SYSTEM_TAB	256	0x100	Parameter is only externally visible in system table.
CFG_EXTRAS_OPTION	512	0x200	Parameter is for CFG_EXTRAS not DS_CONFIG.
CFG_CFGBLK	1024	0x400	Parameter is stored in the configuration block.
CFG_CACHE_GROUP	2048	0x800	Parameter is a cache group.
CFG_CACHE_OPTION	4096	0x1000	Parameter is a cache option.
CFG_BUFFER_POOL_GROUP	8192	0x2000	Parameter is a buffer pool group.
CFG_BUFFER_POOL_OPTION	16384	0x4000	Parameter is a buffer pool option.
CFG_INTERNAL	32768	0x8000	Parameter is for internal use only.
CFG_FNOF_LPAGESIZE	65536	0x10000	Parameter entry depends on logical pagesize.

View this book as PDF