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.
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 more information on the license types mentioned above, please contact your account manager or Exasol support.
Depending on the license type being used, there are certain limitations enforced on it.
For licenses based on data size (raw data license and memory data license), 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.
License limits on data storage size apply to all database instances in your system. If one database has a license problem, all database instances will be affected.
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).
The following table lists the different warning and error messages you will see in the EXAoperation Monitoring section when the license limit is exceeded:
|Warning||When the cumulative data size reaches a certain percentage of the license value (default is 85%).||
A warning is displayed when the license limit has reached 85% of the value.
Once the warning limit is reached, the databases still permit data inserts, but a warning is displayed that the databases are close to the license limit.
|Error||When the data size reaches 105% of the license value.||
When the license limit is exceeded, an error is displayed. No further inserts are permitted in all databases. Inserts are permitted again only when the usage drops below 100%.
|Notice||When the data size drops below 100% of the license value.||
A notice is displayed when the license limit drops below the license value.
The following screenshot displays the sample warnings and errors logged in EXAoperation when your system reaches (or is close to) the limits imposed by your license:
The warning threshold value for your license limit is configurable. You can configure this in EXAoperation.
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.
It is important to clear sufficient data such that the license limit is below 100%. Please note that 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.