|
|
|
The MAX_STORE keyword limits the per-connection amount of temporary disk space available for SQL query execution. Default is 512 GB. Max is 128 TB. Minimum is 2 GB.
SUBSYSTEM SQL LATTE {
MAX_STORE <limit>
}
<limit> equals the size in the units specified (e.g., 512 GB = 512 Gigabytes; 128TB = 128 Terrabytes).
For example, the following sets the limit to 1 TB:
SUBSYSTEM SQL LATTE {
MAX_STORE 1000 GB
}
Note: Setting this value too small could cause some SQL queries to fail with LT_ERR_STOREFULL (-16306)
This setting can be changed at runtime using ctadmn.
