If queries do not run because of exhausted spool space, increase the spool assignment for the user or database using the MODIFY USER or MODIFY DATABASE. If out-of-spool-space errors occur due to uneven data distribution across AMPs, use global space accounting to avoid these errors. Global space accounting dynamically allocates and deallocates space to and from AMPs as needed while the underlying tables of the database or user are modified. See Global Space Accounting.
The maximum size for a spool row is approximately 1MB. This larger row size enhances DML operations that are limited by small spool rows.
The amount of spool space allocated to each user and database is assigned at CREATE USER or CREATE DATABASE time.