The size of raw data currently stored in this database has exceeded the maximum size allowed by lice

Forum|Forum|12 years ago
January 14, 2014
3 replies
18 views

+1

saumya_tamma
Participating Frequently

Hi,

I have a database which is of 668GB of size, We have an enterprise license.

However when bringing down the database I came across this message

"The size of raw data currently stored in this database (1.34 TB) has exceeded the maximum size allowed by license agreement (1.00 TB)

Is there a limit in the enterprise addition of the amount of data that can be stored?

Also when running the query as below it shows size of database is 668GB, how is it that the message is seen where its talking about 1.34TB ?

dbadmin=> select sum(used_bytes)/1024/1024/1024 as total_size from v_monitor.storage_containers;

total_size

------------------------------------------------------------

668.867301438935101032257080078125000000000000000000000000

(1 row)

Please let me know

Thanks
Saumya

R_McKeon
Participating Frequently
Forum|Forum|12 years ago
January 14, 2014

As of Vertica Release 6.1, there is no interactive warning message when you reach 80% or even 100% of allowed usage. This change was made to improve client performance and avoid burdening all queries with this check. From Release 6.1 onward, VSQL and admintools display license warnings only when your data exceeds 125% of the license allowance.

License warnings are displayed as follows when you run SELECT GET_COMPLIANCE_STATUS();

less than 80% usage message: Compliance Status : The database is in compliance with respect to raw data size.
between 80% and 100% usage message: Compliance Status : INFORMATION: license utlization is 80%DB Size.
more than 100% usage message: Compliance Status : ***** IMPORTANT WARNING ***** The size of raw data currently stored in this database (xx GB)has exceeded the maximum size allowed by the license agreement (xx GB).

The Vertica license is always calculated on projected Raw data. 1.34 TB is the raw data size whereas the 668GB is actual compressed data processed or in used in the Vertica catalog and data directory.