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.
-
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. -
To find the database name when you are connected to COS, use the ConfD job db_list.
Example:
Copyconfd_client db_list
- MY_DATABASE -
To find currently defined custom parameters, use the ConfD job db_info. Any custom parameters will be listed in the
params:
section.Copyconfd_client db_info db_name: MY_DATABASE | grep params
params: -forceProtocolEncryption=0 -oidcProviderClientSecret¶meter=-param_name2 -soft_replicationborder_in_numrows=2000000 -
To remove parameters, use the ConfD job db_configure and specify the parameters to remove. For example:
Copyconfd_client db_configure db_name: MY_DATABASE params_delete: '[-forceProtocolEncryption, -soft_replicationborder_in_numrows]'
-
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.Copyconfd_client db_info db_name: MY_DATABASE | grep params
params: -oidcProviderClientSecret¶meter=-param_name2