Running CheckTable After a Migration or Upgrade - Teradata Database

Teradata Database Node Software Migration Guide

Product
Teradata Database
Release Number
16.10
Published
November 30, 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
bkn1504122461303.ditamap
dita:ditavalPath
5942_Migrating_1610.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software
Running CheckTable is an optional step, however, if you haven't run CheckTable in the past couple of months, it is recommended that you do so now.
  1. Coordinate with the System Administrator to determine the priority setting to use for CheckTable, as follows:
    • l = Low
    • m = Medium (default)
    • h = High
    • r = Rush
  2. In the Teradata Database Window, open the Supervisor window.
  3. In the Supervisor window, start CheckTable:

    start checktable

    The CheckTable window opens. Do not change the log file.
  4. In the CheckTable window, start a log file of CheckTable output:
    1. Select File > Logging. The Select Log File for window dialog box appears.
    2. Enter the path and file name for the logging file at Filter and Selection. The logging file should be /home/support/ccnumber/preupg_checktable_out.txt.
    3. Click OK.
  5. At the CheckTable command prompt, start a thorough check of all system tables with the command below. check all tables at level one with no error limit in parallel error only;

    CheckTable commands require a semicolon at the end.

    Use the IN PARALLEL option if no users are logged on.
  6. Inspect the CheckTable log file for any problems. If CheckTable finds problems with any tables, correct each problem. If necessary, contact the Teradata Global Support Center for assistance. Then repeat the test to check each table skipped due to lock contention. Continue fixing problems until there are no further issues.
  7. Review the results and address any errors or issues.
    If necessary, open a support incident.
  8. Quit CheckTable: quit;
  9. Exit logging by selecting File > Logging in the CheckTable window to uncheck Logging.
  10. Close the Database Window if desired.