Managing License Warnings and Limits

Term License Warnings and Expiration

The term portion of an Vertica license is easy to manage—you are licensed to use Vertica until a specific date. If the term of your license expires, Vertica alerts you with messages appearing in the Administration Tools and vsql. For example:

=> CREATE TABLE T (A INT);
NOTICE:  Vertica license is in its grace period
HINT:  Renew at http://www.vertica.com/
CREATE TABLE

Contact Vertica at http://www.vertica.com/about/contact-us/ as soon as possible to renew your license, and then install the new license. After the grace period expires, Vertica stops processing queries.

Data Size License Warnings and Remedies

If your Vertica columnar license includes a raw data size allowance, Vertica periodically audits the size of your database to ensure it remains compliant with the license agreement. For details of this audit, see Calculating the Database Size. You should also monitor your database size to know when it will approach licensed usage. Monitoring the database size helps you plan to either upgrade your license to allow for continued database growth or delete data from the database so you remain compliant with your license. See Monitoring Database Size for License Compliance for details.

If your database's size approaches your licensed usage allowance (above 75% of license limits), you will see warnings in the Administration Tools , vsql, and Management Console. You have two options to eliminate these warnings:

If your database continues to grow after you receive warnings that its size is approaching your licensed size allowance, Vertica displays additional warnings in more parts of the system after a grace period passes.

If Your Vertica Premium Edition Database Size Exceeds Your Licensed Limits

If your Premium Edition database size exceeds your licensed data allowance, all successful queries from ODBC and JDBC clients return with a status of SUCCESS_WITH_INFO instead of the usual SUCCESS. The message sent with the results contains a warning about the database size. Your ODBC and JDBC clients should be prepared to handle these messages instead of assuming that successful requests always return SUCCESS.

Note: These warnings for Premium Edition are in addition to any warnings you see in Administration Tools, vsql, and Management Console.

If Your VerticaCommunity Edition Database Size Exceeds 1 Terabyte

If your Community Edition database size exceeds the limit of 1 terabyte, you will no longer be able to load or modify data in your database. In addition, you will not be able to delete data from your database.

To bring your database under compliance, you can choose to: