15.00 - Output Spool Space - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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.