This section explains how to manage licenses in Exasol.
Depending on your contract with Exasol and your business requirements, Exasol provides the following license types:
- Raw data license: This license type specifies the maximum size of the raw data you can store across databases in the cluster. This is the default license type.
- Database RAM License: This license type specifies the total amount of RAM that can be assigned to the database in the cluster.
For more information about the license types, contact your account manager or Exasol support.
Raw data volume (unit TB): The raw data volume corresponds to the data volume that is comparable to the size the data would have if stored as CSV files. If you exceed the licensed capacity, you cannot import any additional data unless you delete the data inside the database.
For licenses based on data size, a periodic check is done by Exasol on the size of the data. If the size limit exceeds the value specified in the license, the database does not permit any further data insertion until the usage drops below the specified value.
For licenses based on RAM, Exasol checks the RAM assignment at the start of the database. If the RAM in use exceeds the maximum RAM specified in your license, the database will not start.
As mentioned above, when storage limits are exceeded, all databases will enter a restricted mode, affecting the following statements:
- CREATE TABLE AS
- SELECT INTO
In this mode, any attempt to execute one of these statement types will result in an SQL exception as shown below:
[R0010] Statement currently not allowed because latest cumulative database
raw sizes of 10.6 GiB exceeded raw size license limit of 10.0 GiB (106.2%).
Please increase your license or delete some data and FLUSH STATISTICS.
When the system is above the license threshold, ALL of the above statements are locked, even if they would not result in an actual insertion of data (for example, the MERGE command).
If an Exasol system exceeds any of the defined technical limits, the database will fail to start. For more information about these limits, see System Technical Limits.
To resolve the limit exceeded on your license, clear some large data (DROP or DELETE database tables) and perform FLUSH STATISTICS to update the current database sizes.
Clear sufficient data so that the license limit is below 100%. The checking of license limits is a periodic process, and it may take a few minutes for a database to recognize the uploaded sizes and leave the restricted mode.