Clearing Configuration Parameters
You can clear configuration parameter settings at three scopes:
- Database
- Node
- Session
Database Scope
ALTER DATABASE..CLEAR
clears one or more parameter values at the database scope, and resets them to their default values as follows:
ALTER DATABASE dbname CLEAR parameter-name[,...];
For example:
ALTER DATABASE mydb CLEAR AnalyzeRowCountInterval, FailoverToStandbyAfter;
Node Scope
ALTER NODE..CLEAR
clears one or more parameter values at the node scope, and resets them to their database settings, if any. If the parameters are not set at the database scope, Vertica resets them to their default value.
ALTER NODE node-name CLEAR parameter-name[,...];
The following example clears MaxClientSessions
on node v_vmart_node0001
:
ALTER NODE v_vmart_node0001 CLEAR MaxClientSessions;
Session Scope
ALTER SESSION..CLEAR
clears one or more parameter values at the session scope, and resets them to their node or database settings, if any. If the parameters are not set at either scope, Vertica resets them to their default value.
ALTER SESSION CLEAR parameter-name[,...];
For example:
=> ALTER SESSION CLEAR ForceUDxFencedMode;