The maximum number of bytes allowed for spool files in database_name.
- n
- You can enter the number of bytes as an integer, decimal, or floating point value or as a constant expression whose evaluation determines the number of bytes. You can also enter the value using exponential notation. For example, you can write one thousand as either 1000 or 1E3.
- constant_expression
- A constant expression is any SQL expression that does not make any column references. Specifying an appropriate constant expression for the SPOOL size of a database enables Vantage to assign an optimal quantity of SPOOL that scales to the size of your system by allocating SPOOL space on a per AMP basis.
- BYTES
- Optional keyword that redundantly specifies the unit for the amount of space allowed.
- SKEW
- Keyword that you use to specify a skew limit for SPOOL space. You can specify a skew limit percentage that allows the maximum AMP space usage to be more than the per-AMP quota, that is, the system maximum space limit divided by the number of AMPs.
- constant_expression
- Constant expression or constant from 0 through 10000. Specify a value from 1 to 9999 to indicate an AMP-level limit, which is the per-AMP quota * (1+spoolskewlimit/100). Specify 0 to set space accounting to the per-AMP level, that is, no skew. A value of 10000 indicates unlimited skew, up to the system maximum space limit.
- DEFAULT
- Use the value of DBS Control DefaultSpoolSkewLimitPercent.
- PERCENT
- Optional keyword that you can include for readability to indicate that the constant_expression or DEFAULT keyword specifies a percentage of allowable skew.