Hello,
we have 1Tb free vertica.
two days ago by mistake we inserted many duplicate rows in a large table. As a result we got 127% license usage. Yesterday we fixed the probplen amd deleted rows. Now Get_license_compliece gives 73%. We Run SELECT AUDIT(''). However, I still see the warning that we at 127%. What can be done about it? Simply wait next day?
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Licensing/ManagingLicenseWarningsAndLimits.htm
Additional question. Is it possible to change license eveluation hour during day?
Question
when license message goes off
+1
+2It will update next time audit job runs.
Hi, you can set the license audit time with SET_AUDIT_TIME: https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/LicenseManagement/SET_AUDIT_TIME.htm
You can run audit immediately with AUDIT_LICENSE_SIZE: https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/LicenseManagement/AUDIT_LICENSE_SIZE.htm
+1Thank you. Yes, today the message has disssapered.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
