Remove Database Parameters

This article explains how to remove custom parameter values in an Exasol database.

Exasol databases are configured using parameters that are written as key-value pairs in the format "-parameter":"value". Parameters that are not explicitly defined will fall back on default values hard-coded in the application. The default values should be adequate for most use cases, but can be changed by adding custom parameter values in the configuration if needed.

This article explains how to remove custom parameter values to revert to the default behavior.

Invalid parameters will prevent the database from starting. To avoid unnecessary downtime, create a support case to get guidance from Support before you add or change database parameters.

Prerequisites

The database must be stopped. For more information, see Stop a Database.

Procedure - ConfD

The following examples use ConfD through the command-line tool confd_client, which is available on all database nodes. You can also access ConfD through XML-RPC in your own Python programs. For more information, see ConfD.

  1. Connect to the cluster operating system (COS) using c4 connect -i PLAY_ID -s cos.

    Example:
    Copy 
    ./c4 connect -i c3275f84 -s cos

    For more information about how to use c4 connect, see How to use c4.

  2. To find the database name when you are connected to COS, use the ConfD job db_list.

    Example:
    Copy 
    confd_client db_list
    - MY_DATABASE

  3. To find currently defined custom parameters, use the ConfD job db_info. Any custom parameters will be listed in the params: section.

    Copy 
    confd_client db_info db_name: MY_DATABASE | grep params
     params: -forceProtocolEncryption=0 -oidcProviderClientSecret&parameter=-param_name2 -soft_replicationborder_in_numrows=2000000

  4. If the database is running, stop it now using the ConfD job db_stop. For example:

    Copy 
    confd_client db_stop db_name: MY_DATABASE

  5. To remove parameters, use the ConfD job db_configure and specify the parameters to remove. For example:

    Copy 
    confd_client db_configure db_name: MY_DATABASE params_delete: '[-forceProtocolEncryption, -soft_replicationborder_in_numrows]'

  6. To verify that the configuration has been updated, use the ConfD job db_info. Any custom parameters will be listed in the params: section. If no custom parameters are defined, this section will not be included in the response.

    Copy 
    confd_client db_info db_name: MY_DATABASE | grep params
     params: -oidcProviderClientSecret&parameter=-param_name2

  7. Start the database using the ConfD job db_start. For example:

    Copy 
    confd_client db_start db_name: MY_DATABASE