SpoolBigDBAllocUnit - Teradata Vantage - Database Engine 20

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2026-03-26
dita:mapPath
ron1747160181474.ditamap
dita:ditavalPath
ft:empty
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

Determines the storage allocation unit size in sectors for multirow big data blocks in spool tables.

Field Group

File System

Valid Range

8 to 127 sectors

A sector is 512 bytes.

On cliques with 4 KB aligned devices, the setting is rounded up to the next 8-sector multiple.

Default

1 sector

Changes Take Effect

After the DBS Control Record has been written.

For More Information

Changes to this field may be of less consequence than changes to the analogous PermDBAllocUnit field because spool tables are not updated frequently. Nevertheless, care should be taken when considering a change to this setting. Before making changes to this field, refer to the information for PermDBAllocUnit.