17.10 - Checksum Fields - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
July 2021
English (United States)
Last Update

Checksums can be used to check the integrity of database disk I/O operations. A checksum is a calculated numeric value computed from a given set of data, or specific portions of the data. For a given set of data, the checksum value will always be the same, provided the data is unchanged.

Checksums can be used to detect when there are errors in disk I/O operations. When checksums are enabled, and data is initially read, a checksum is calculated for the data and stored in the system. When the same data is subsequently read, the checksum is recalculated and compared to the original checksum value. Differing checksum values for a given set of data indicate an inconsistency in the data, most often due to errors in disk I/O operations.

The Checksum group of fields shows the current checksum settings for these classes of tables:
  • System
  • System Journal
  • System Logging
  • User
  • Permanent Journal
  • Temporary

These table classes are described in the sections that follow.

Because calculating checksums requires system resources, and may affect system performance, the checksum feature is disabled by default on most platforms, but can be enabled by the Teradata Support Center if disk corruption is suspected.