SpoolBigDBAllocUnit - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
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.