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. 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.
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. |
