Applies to master database only. sysconfigures contains one row for each configuration parameter that can be set by the user.
The columns for sysconfigures are:
Name |
Datatype |
Description |
|---|---|---|
config |
smallint |
Configuration parameter number. |
value |
int |
The user-modifiable value for the parameter with integer datatype. Its value is 0 for the parameters with character datatype. |
comment |
varchar(255) |
Name of the configuration parameter. |
status |
int |
Value that represents the type of configuration parameter. |
name |
varchar(255) null |
Name of the configuration parameter (the same value as comment). |
parent |
smallint null |
Configuration parameter number of the parent; if more than one parent, the additional parent numbers are stored in sysattributes. |
value2 |
varchar(255) null |
The user-modified value for the parameter with the character datatype. Its value is NULL for parameters with integer datatype. value2 is also used to store the pool size of a buffer pool. |
value3 |
int null |
Stores the wash size of a buffer pool. |
value4 |
int null |
Stores the asynchronous prefetch percents of a buffer pool, or -1 where an unspecified or default value. |
instanceid |
tinyint |
ID of the instance. Available only for cluster environments. |
This table provides information about the status column:
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 externally visible only 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. |
Unique clustered index on name, parent, config
Nonclustered index on config
Nonclustered index on parent, config