A keyword allowing you to specify the number of bytes allowed for spool files for profile_name. The default is null, which causes the system to use the setting defined for the individual user.
If no spool space is defined in the profile assigned to a user, Vantage uses the setting defined for the individual user. If spool space is not defined for either the user profile or the user, the system uses the spool space assigned to the owner of the space in which the user was created.
Profiles can be assigned to a proxy user in a trusted session so that the profile attributes of the permanent proxy user, such as perm space and spool, are used. If a permanent proxy user logs on directly and runs queries while also logged on through a middle tier application trusted session with queries being run as a proxy, the SPOOL and TEMP usage accumulation for that user includes both. The individual user’s query fails when the collective usage exceeds the individual user’s limits.
- n
- n cannot exceed the spool space parameter in the profile of the creator. If no spool space is defined for that profile, then the spool space limit defined for the user setting of the creator is used.
- BYTES
- BYTES is an optional keyword that redundantly specifies the unit for the amount of SPOOL space allowed.
- 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 profile enables Vantage to assign an optimal quantity of SPOOL that scales to the size of your system.