There's more...

Teradata offers many other tools for checking consistency in data over the disk and cylinders. The checking of data and sectors is recommended as maintenance task on system. These utilities not only help in maintaining data integrity, but some of the tools such as packdisk, help restore system space when cylinders are low in space:

  • Checktable utility: Checktable is a diagnostic and validation tool; it checks for inconsistencies, corruption in internal data structures such as table headers, row identifiers, and secondary indexes. It can be executed in three levels.
  • Table rebuild utility: It repairs data corruption identified from scandisk and checktable.
  • Packdisk utility: Packdisk helps to pack/free up/combine cylinders in ...

Get Teradata Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.