What is spool space in teradata? explain with examples.

Database
Enthusiast

What is spool space in teradata? explain with examples.

What is spool space in teradata? explain with examples.
3 REPLIES
Junior Contributor

Re: What is spool space in teradata? explain with examples.

Short question, short answer : RTFM

Dieter
Enthusiast

Re: What is spool space in teradata? explain with examples.

unused permspace will be used as the spoolspace in the system. this is used to hold the intermittent results of the queries and volatile tables.
Enthusiast

Re: What is spool space in teradata? explain with examples.

We have a rule i.e if a query takes more than one terabyte of spool we are supposed to abort it.

My question is lets say the total spool is used by a query , what is the expected behavior of the system , will the system restart or what can happen?

Next question is related to the 1st line ; If we have around 10 terabyte of spool , is this logical to abort the query that has just crossed 1tb of spool. i thnk we should allow it more spool that can be up to 9tb or so if there are no other sessions. Please provide your analysis on the above cases ,

Thanks