Show TOC

Example documentationACTIVECONFIGURATION

 

Use of the system table SYSINFO.ACTIVECONFIGURATION

Prerequisites

You can use the DEMODB demo database. Start the Database Studio and log onto the demo database DEMODB: Logging On to a Database.

Activities

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'