16.20 - CHECKSUM - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

A table-specific disk I/O integrity checksum.

The checksum setting applies to primary data rows, fallback data rows, and all secondary index rows for the table.

integrity_checking_level

If you do not specify a value, then the system assumes the system-wide default value for this table type. This is equivalent to specifying DEFAULT.

If you are changing the checksum for this table to the system-wide default value, then specify DEFAULT.

ON
Calculate checksums using the entire disk block. Sample 100% of the disk blocks to generate a checksum. ON is equivalent to ALL, which is deprecated.
OFF
Disables checksum disk I/O integrity checks. OFF is equivalent to NONE, which is deprecated.
DEFAULT
The default setting is the current DBS Control checksum setting specified for this table type.