ACTIVECONFIGURATION

Prerequisites

Log on to the database instance DEMODB.

Examples

You can use the system tableACTIVECONFIGURATION to determine the following database information, among other things:

·        Name and value of the database parameter RUNDIRECTORY

SELECT parametername, value
  FROM SYSINFO.ACTIVECONFIGURATION
    WHERE parametername = 'RUNDIRECTORY'

·        Displaying whether the parameter MAXBACKUPDEVS can be changed in the ONLINE operational state and whether it is immediately effective following any change

SELECT parametername, changeable
  FROM activeconfiguration
    WHERE parametername = 'MAXBACKUPDEVS'