How much space should be reserved for Spool reserve in Teradata

Environment/Conditions/Configuration: TDBMS 15.10.05.04 

Following Table will help you to estimate your spool requirement. The percent of spool space suggested is relative to CURRENTPERM . 

System Fallback Rate

Compression Rate

Spool Space Reserve Recommended

 (Percent Relative to CURRENTPERM)

100%

0%

20%

100%

40%

30%

50%

20%

32%

0%

0%

40%

0%

40%

60%

 Table: Spool space Recommendation  (Teradata, 2018)

 

References

Teradata. (2018, Feb 12). Retrieved from http://knowledge.teradata.com/KCS/id/KCS010826

 

Comments