Object documentationACTIVECONFIGURATION Locate this document in the navigation structure

 

The system table SYSINFO.ACTIVECONFIGURATION contains the names and values of the database parameters that are currently active.

Structure

ACTIVECONFIGURATION

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

More Information

Evaluating System Tables, ACTIVECONFIGURATION

Database Administration, Database Parameters