Show TOC

ACTIVECONFIGURATIONLocate this document in the navigation structure

Use

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 MaxBackupMedia can be changed in the ONLINE operational state and whether it is immediately effective following any change

    SELECT parametername, changeable

    FROM SYSINFO.ACTIVECONFIGURATION

    WHERE parametername = 'MaxBackupMedia'