The system table ACTIVECONFIGURATION contains the names and values of the database parameters that are currently active.
ACTIVECONFIGURATION
PARAMETERNAME |
CHAR(32) |
Name of database parameter |
PERMANENT |
CHAR(3) |
Indicates whether the value of the database parameter is reset when the system switches to operational state OFFLINE (YES | NO) |
CHANGEABLE |
CHAR(10) |
Indicates whether the value of the database parameter can be changed in operational state ONLINE and whether the change takes effect immediately (YES | NO) |
VALUE |
CHAR(256) |
Value of database parameter |
See also:
Evaluating System Tables, ACTIVECONFIGURATION
Concepts of the Database System, Database Parameters