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.
-
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
- In the Teradata Database Window, open the Supervisor window.
-
In the Supervisor window, start CheckTable:
start checktable
The CheckTable window opens. Do not change the log file. -
In the CheckTable window, start a log file of CheckTable output:
- Select The .Select Log File for window dialog box appears.
- 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.
- Click OK.
-
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. - 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.
-
Review the results and address any errors or issues.
If necessary, open a support incident.
- Quit CheckTable: quit;
- Exit logging by selecting Logging. in the CheckTable window to uncheck
- Close the Database Window if desired.