data_block_size - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

Maximum data block size for blocks that contain multiple rows as the value numeric.

If DATABLOCKSIZE is not specified, then data blocks default to the sizes set in the PermDBSize and JournalDBSize fields of the DBS Control Record.

  • The default value for a PERM data block is specified using the PermDBSize parameter of the DBS Control record.
  • The default value for transient and permanent journal data blocks is specified using the JournalDBSize parameter of the DBS Control Record.
numeric
Value for data block size.
BYTES
BYTES can be abbreviated as BYTE.
KBYTES
KILOBYTES
KILOBYTES can be abbreviated as KBYTE.
MINIMUM
The smallest data block size for this table.
MINIMUM DATABLOCKSIZE sets the maximum data block size for blocks that contain multiple rows to the minimum value of 21,504 bytes (42 sectors) for systems with large cylinders or 9,216 bytes (18 sectors) for systems without large cylinders.
You can abbreviate MINIMUM as MIN.
For details about minimum data block sizes, see DATABLOCKSIZE of CREATE TABLE in Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.
MAXIMUM
The largest data block size for this table.
Systems that do not support block sizes 128KB and larger use a value of 127.5KB.
Systems that allow blocks larger than 127.5KB use a maximum of 1,048,064 bytes (2047 sectors) for large cylinders or 262,144 bytes (512 sectors) for small cylinders.
The value can be expressed either as a decimal number or integer number or using exponential notation. For example, you can write one thousand as either 1000 or 1E3.
You can abbreviate MAXIMUM as MAX.
DEFAULT
The default data block size for this table.
If you specify DEFAULT or do not specify a value, Vantage uses the system-wide default data block size specified by the DBS Control setting PermDBSize. For details, see Teradata Vantage™ - Database Utilities, B035-1102.