License enforcement for raw and memory data licenses

Detail name	Value
Changelog Number	3661
Type	New Feature
Status	Resolved
Fix Versions	EXASOL 6.0.7
Resolution Date	2018-03-06

Preface

In Exasol versions up to and including 6.0.6, EXAoperation logs an error message once a day if the raw or memory data size limit of the license has been exceeded. These messages are easily overlooked and hence license agreements inadvertedly violated.

For database RAM licenses, the license limit is already enforced when starting databases.

Strict checking and prevention

Limits on raw and/or memory data usage specified by an Exasol license will be enforced starting with Exasol 6.0.7: When the cumulative data size of all running databases in a cluster exceeds 105% of the limit stated in the license, all databases in that cluster will no longer permit inserting statements. Any INSERT, IMPORT, MERGE or CREATE TABLE AS statement will be rejected with an SQL exception in that state.

Required Actions

To get databases back to normal operation mode, you have to reduce the cumulative data size of running databases below 100% of the limit:
You can achieve this by either shutting down databases or deleting or dropping table data.

More information

For more information on managing license limits please consult this article.

To manage multiple databases under the same license, you can limit the local data size of each instance by using database parameters. See SOL-593 for details on this.

Changed behavior