Archives of the TeradataForum

Message Posted: Thu, 21 Oct 2004 @ 19:12:04 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Checksum is new in V2R5.1. Here is some info:

The Teradata Database system includes many methods to prevent, detect, correct, and recover from data corruption. One of these methods, the Teradata Disk I/O Integrity Check Feature available in V2R5.1, may be enabled to achieve enhanced prevention and detection of data corruption.

The Teradata Disk I/O Integrity Check Feature uses a safe write mode to prevent data corruption during disk write activity. To detect corruption errors a checksum is generated for all disk writes and verified on all disk reads. In this way corruption can be detected before it cascades into a larger problem.

Today's high speed processors, memories and advanced caching make it reasonable to perform a checksum in software, trading data integrity protection for a moderate performance impact. This tradeoff can be fine tuned through the advanced controls offered by the Teradata Disk I/O Integrity Check Feature. First, the feature is optional. Second, the feature may be enabled on a table by table basis. Third, the checksum may be applied to some or all of the data corresponding to each disk sector.

Mark Morris
Teradata Architecture

	<Prev	Next>		<<First	<Prev	Next>	Last>>