CheckTable Check Levels - Teradata Database

CheckTable Check Levels

CheckTable offers several levels of data integrity checking. Each successive level performs most or all of the checks from the lower levels, and performs additional checks that are more thorough. For example, level-two checking performs checks similar to those from the pendingop and first level, and adds additional checks. Higher check levels are generally more resource intensive, and require more time.

At each level of checking, CheckTable inspects specific internal data structures. If CheckTable detects errors during these checks, it displays error messages that describe the nature of the errors. The message may be followed by additional information to show the location of the problem: AMP, subtable (primary data, fallback data, or index), and row or range of rows, if applicable.

Note: For more information on specific CheckTable error messages by number, see Messages. For more information on the Hilbert R-tree structure used by geospatial indexes, see SQL Request and Transaction Processing.

The following table indicates the specific internal data structures that are checked by each type of level check, and suggests when to use each level.

Check Level	Internal Data Structures Checked	When to use this level
Pendingop	Data dictionary (if database DBC is checked) Table dictionary Table header	Use pendingop checking to check for tables with the following pending operations: FastLoad Restore Reconfig Rebuild Replicate copy MultiLoad
One	Data dictionary (if database DBC is checked) Table dictionary Table header Obsolete subtables Unique secondary indexes Nonunique secondary indexes ParentCount ChildCount Subtable of a given table Base global temporary tables Data subtables Large object subtables Reference indexes System-defined join indexes (SJIs) for temporal tables with temporal unique constraints	Use level‑one checking only to isolate specific tables with errors. Then perform level‑two or level‑three checks on those specific tables. Note: When level-one checks use the DOWN ONLY option, the CheckTable results show only the subtables that have been marked as down.
Two	Data subtables Large object subtables Unique secondary indexes Nonunique secondary indexes Reference indexes System-defined join indexes (SJIs) for temporal tables with temporal unique constraints	Use level-two checking when checks by level one fail, and you require a detailed checking of consistency of row IDs, the checksum of primary and fallback rows, and hash codes. Note: When level-two checks use the DOWN ONLY option, the CheckTable results show only the subtables and regions (ranges of rows in subtables) that have been marked down.
Three	Data subtables Large object subtables (same checking as for Level Two) Unique secondary indexes Nonunique secondary indexes Reference indexes System-defined join indexes (SJIs) for temporal tables with temporal unique constraints	Use level-three checking rarely and only for specific diagnostic purposes, such as when an AMP is down. Note: When level-three checks use the DOWN ONLY option, the CheckTable results show only the subtables and regions (ranges of rows in subtables) that have been marked down.

Note: Databases and tables within databases are checked in alphabetical order.