Number of bytes to be reserved for permanent storage for database_name. The space is taken from unallocated space in the database or user of the immediate owner.
You must specify a value for this option. There is no default.
You can specify a password for a user, but not for a database.
- n
- Nonnegative integer, decimal, or floating point value. Cannot exceed the number of bytes in the permanent space of the owner. Can use exponential notation (for example, you can write one thousand as 1E3).
- constant_expression
- SQL expression without column references. Must have a nonnegative value that does not exceed the number of bytes in the permanent space of the owner.
- BYTES
- Optional keyword that redundantly specifies the unit for the amount of space allowed.
- SKEW
- Skew limit for PERMANENT 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+permskewlimit/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 DefaultPermSkewLimitPercent.
- PERCENT
- Optional keyword that you can include for readability to indicate that the constant_expression or DEFAULT keyword specifies a percentage of allowable skew.