What is Spool Space? Why do you get spool space errors? How do trouble-shoot them?

Database
Highlighted
Enthusiast

What is Spool Space? Why do you get spool space errors? How do trouble-shoot them?

hi all i want to know something about spool space and it's error.

1 REPLY
Teradata Employee

Re: What is Spool Space? Why do you get spool space errors? How do trouble-shoot them?

Hi,

Spool space is an intermediate dataset storage space. Usually spool space errors occur due to stale stats resulting in product joins. To troubleshoot them, fix the query which is causing them and increase the system/user spool space if you can.

For further details, please research on "Spool space of databases" on search engine you prefer the most.

Regards, MAC