agent_oms

Managing the Vertica database parameters

In Vertica we are able to manage and alter the parameters the database listen to.

How to see the values of a parameter.

Use the query bellow passing the name of the parameter.

 Or by using the SHOW CURRENT statement

 

How to alter the value of a parameter

Base Syntax:

 

Example of altering the AdvanceAHMInterval to 200 secounds

 

Also we have the option to clear the value of a parameter, this will statement will set the parameter value to its default value.

Base Syntax:

Example :

 

   

I hope this was helpful and i appreciate if you would like, subscribe or share our posts. I it is just a click

clickhere

No Comments
Leave a Comment

%d bloggers like this: