Databases no longer permit data insertion. License exceeded: Databases raw sizes of 10.6 GiB exceed license limit of 10.0 GiB (106.2%). Inserts are permitted again only when the usage drops below 100%. No further inserts are permitted in all databases. When the license limit is exceeded, an error is displayed. When the data size reaches 105% of the license value. At 105% databases will no longer permit data insertion. License Warning: Databases raw sizes of 8.7 GiB is close to the license limit of 10.0 GiB (86.5%). 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. When the cumulative data size reaches a certain percentage of the license value (default is 85%).Ī warning is displayed when the license limit has reached 85% of the value. The following table lists the different warning and error messages you will see in the EXAoperation Monitoring section when the license limit is exceeded: Alert Type 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). Please increase your license or delete some data and FLUSH STATISTICS. Raw sizes of 10.6 GiB exceeded raw size license limit of 10.0 GiB ( 106.2 %). Statement currently not allowed because latest cumulative database In this mode, any attempt to execute one of these statement types will result in an SQL exception as shown below: Enforced LimitsĪs mentioned above, when storage limits are exceeded, all databases will enter a restricted mode, affecting the following statements:
If one database has a license problem, all database instances will be affected. License limits on data storage size apply to all database instances in your system. If the RAM in use exceeds the maximum RAM specified in your license, the database will not start. 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.įor licenses based on RAM, Exasol checks the RAM assignment at the start of the database. License Limitsĭepending on the license type being used, there are certain limitations enforced on it.įor 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 you exceed the licensed capacity, you cannot import any additional data unless you delete the data inside the database.įor more information about how raw data size is determined, see Sizing for Data Types.įor more information on the license types mentioned above, please contact your account manager or Exasol support. The raw data volume corresponds to the data volume that is comparable to the size the data would have if stored as CSV files.
0 kommentar(er)
