sysconfigures

master database only

Description

sysconfigures contains one row for each configuration parameter that can be set by the user.

Columns

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. For details see Table 12-3.

name

varchar(80) 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. It 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.

Table 12-3 provides information about the status column.

Table 12-3: Status column description

Status type

Value

Description

CFG_NO_OPTIONS

0x0

Parameter has no options.

CFG_SYSTEM_OPTION

0x01

Parameter is a system option.

CFG_SYSTEM_GROUP

0x02

Parameter is a system group.

CFG_STATIC

0x04

Parameter is static.

CFG_DYNAMIC

0x08

Parameter is dynamic.

CFG_CALCULATED

0x10

Parameter is calculated.

CFG_READONLY

0x20

Parameter is readonly.

CFG_MEMORY_USED

0x40

Parameter consumes memory.

CFG_CONFIG_FILE

0x80

Parameter is externally visible.

CFG_SYSTEM_TAB

0x100

Parameter is only externally visible in system table.

CFG_EXTRAS_OPTION

0x200

Parameter is for CFG_EXTRAS not DS_CONFIG.

CFG_CFGBLK

0x400

Parameter is stored in the configuration block.

CFG_CACHE_GROUP

0x800

Parameter is a cache group.

CFG_CACHE_OPTION

0x1000

Parameter is a cache option.

CFG_BUFFER_POOL_GROUP

0x2000

Parameter is a buffer pool group.

CFG_BUFFER_POOL_OPTION

0x4000

Parameter is a buffer pool option.

CFG_INTERNAL

0x8000

Parameter is for internal use only.

CFG_FNOF_LPAGESIZE

0x100000

Parameter entry depends on logical pagesize.

Indexes

Unique clustered index On name, parent, config

Nonclustered index On config, config