What do you mean by Spool space in Teradata? Write its usage.

1.	What do you mean by Spool space in Teradata? Write its usage.
Answer» Spool space refers to the unused space in the system in which intermediate results from a SQL query are stored. Query execution is not POSSIBLE for USERS without spool space. Amount of spool space is divided based on the number of AMPs, but each AMP has only a fraction of the space available. In the event that the per AMP limit is exceeded, the user will RECEIVE a warning that they have run out of spool space. Example: Let's say the user was assigned a spool space of 200000000 bytes. This is the maximum space the user is allowed to use and it is distributed evenly across all AMPs as shown below.

Answer»

Spool space refers to the unused space in the system in which intermediate results from a SQL query are stored. Query execution is not POSSIBLE for USERS without spool space. Amount of spool space is divided based on the number of AMPs, but each AMP has only a fraction of the space available. In the event that the per AMP limit is exceeded, the user will RECEIVE a warning that they have run out of spool space.

Example: Let's say the user was assigned a spool space of 200000000 bytes. This is the maximum space the user is allowed to use and it is distributed evenly across all AMPs as shown below.

Discussion

No Comment Found

Related InterviewSolutions

Explain channel driver.
What do you mean by caching in Teradata?
What are the benefits of using ETL tools over Teradata?
Is Teradata an ETL tool or a database?
Mention a few ETL (Extract, Transform and Load) Tools that come under Teradata.
Explain nodes in Teradata.
What do you mean by Spool space in Teradata? Write its usage.
What is Skewness in Teradata?
What is performance tuning and why is it important?
What is the process of restarting MLOAD Teradata Server after execution?