17.10 - CheckTable Messages - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)
CheckTable issues the following types of messages:
  • Syntax error
  • Check completion
  • Error

Syntax Error Messages

When a syntax error occurs, CheckTable does the following:
  • Displays the part of the input line where the error occurs
  • Prints a dollar sign ($) in the command input line beneath the character that caused the error
  • Displays an error message

For example, assume the following command:

CHECK db[2-] AT LEVEL ONE;

The following error message appears:

*** Syntax error ***
CHECK db[2-] AT LEVEL ONE;
           $
Invalid range specified in dbname or dbname.tablename.

Error Messages

CheckTable aborts when it encounters problems, depending on the severity and context of the problem. CheckTable can crash the database on rare occasions, such as when unable to clean up resources allocated by the database.

When CheckTable aborts, it does the following:
  • Displays an error message
  • Saves a snapshot dump for further analysis
  • Retains backtrace information

The backtrace information is located in the event log file, /var/log/messages.

For more information on specific CheckTable error messages by number, see Teradata Vantage™ - Database Messages, B035-1096.

Auxiliary Information

Auxiliary information included in messages may include a table row identifier.

A RowID consists of a 16-byte value that includes the following information:
  • The first 8-bytes is the internal partition number of the row.

    (For a nonpartitioned table, the internal partition number is zero, and the internal partition number is not actually stored in the row itself.)

  • The next 8-bytes include a hash bucket value and uniqueness value for the row.
For more information on internal table row formats, see Teradata Vantage™ - Database Design, B035-1094.