16.10 - SpoolBigDBAllocUnit - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

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.