17.10 - CHECK AGAIN Command Restrictions - 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)

Each CHECK command generates an error file containing a list of the significant errors. Use the CHECK AGAIN command to check only the (failed) tables listed in an error file. You can also specify an input error file or let CheckTable default the input error file to the output error file generated by the previous CHECK command.

If Error-filename is not specified, the last error file generated by the previous CHECK command in the current CheckTable instance is used as input.

Error-filename may be a fully qualified filename (such as /var/tmp/CheckTableErrors20130503164640) or a relative path filename (for example, CheckTableErrors20130503164640).

For a relative path name, the root directory is the error file directory, which is managed with the ERRORFILEDIR command.