Output Spool Space - Teradata Database

Output Spool Space

Output spool results are the final information returned for a query or the rows updated within, inserted into, or deleted from a base table. The length of time output spool is retained depends on the subsystem and various system conditions, as described in this table:

Subsystem/Condition	When Output Spool Is Released
BTEQ	Last spool response.
Embedded SQL	The open cursor is closed.
CLIv2	ERQ received Function terminated
Session terminates asynchronously due to any number of conditions, including the following. Job abort Timeout Logoff	At the time the termination occurs.
System restart	At the time the restart occurs.