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
|