Use of the system table SYSINFO.ACTIVECONFIGURATION
You can use the DEMODB demo database. Start the Database Studio and log onto the demo database DEMODB an: Logging On to a Database.
You can use Database Studio to enter and execute SQL statements. More information: Working with SQL Statements: Overview
Note the General Instructions for formulating SQL statements.
You can use the system table ACTIVECONFIGURATION to determine the following database information, among other things:
Name and value of the database parameter RunDirectoryPath
SELECT parametername, value
FROM SYSINFO.ACTIVECONFIGURATION
WHERE parametername = 'RunDirectoryPath'
Displaying whether the parameter MaxBackupMediacan be changed in the ONLINEoperational state and whether it is immediately effective following any change
SELECT parametername, changeable
FROM SYSINFO.ACTIVECONFIGURATION
WHERE parametername = 'MaxBackupMedia'