CHECKSUM - TARA/ABU

The CHECKSUM parameter allows the Teradata Database and/or Teradata ARC to verify data packets during ARCHIVE or RESTORE.

where:

Syntax Element

Definition

n

Checksum value, which can be one of the following: 0 = checksum option is disabled. 1 = the checksum is calculated by the Teradata Database. 2 = the checksum is verified by Teradata ARC during ARCHIVE, and by both Teradata ARC and Teradata Database during RESTORE. Note: CHECKSUM can also be used with the ANALYZE statement. If the VALIDATE option is used with ANALYZE, Teradata ARC validates the checksum for each data block in the archive.

Expect the following effects, depending on the value set for CHECKSUM:

Setting CHECKSUM=1 helps ensure data integrity during RESTORE, but this might cause a slight performance drop due to the fact that the checksum value for the data blocks is calculated only by the Teradata Database.

Setting CHECKSUM=2 provides verification of data integrity during both ARCHIVE and RESTORE, but because both the Teradata Database and Teradata ARC calculate the checksum, this can result in a significant performance drop.