when license message goes off

avoronin

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?

Bryan_H

It 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

avoronin

Thank you. Yes, today the message has disssapered.