The system table SYSINFO.ACTIVECONFIGURATION contains the names and values of the database parameters that are currently active.
PARAMETERNAME |
CHAR(32) |
Name of the 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) |
DEPRECATED |
CHAR(3) |
Indicates whether the database parameter remains YES: No further database parameter under this name from the next minor version onwards. NO: Database parameter remains. |
VALUE |
CHAR(256) |
Value of the database parameter |
Evaluating System Tables, ACTIVECONFIGURATION
Database Administration, Database Parameters