Maximum number of bytes allowed for spool files in profile_name. The default is null, which uses the setting defined for the individual user assigned to the profile.
Changes to spool space limits in a profile take effect immediately upon submitting the MODIFY PROFILE request.
- 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.
- BYTES
- Optional keyword that redundantly specifies the unit for the amount of space allowed.