In this example I am using the Teradata Express. Logon on to the Teradata system, using Putty is just a preference.
- Start the cnsterm supervisor screen (or window): cnsterm 6
- Start the Teradata CheckTable utility by entering: start checktable
- The system will acknowledge that CheckTable has started, make note of the window that the utility starts in.
- Exit the cnsterm supervisor screen by pressing ctrl -c: < ctrl -c >
- Enter the window that the CheckTable utility was started in, the example below was window 1: cnsterm 1
- Enter the command for checking the table: CHECK < database >.< tablename> AT LEVEL ONE;
- In the example below, the PRODUCT table in the RETAIL database is being checked.
Displayed below is what the results from the CheckTable utility for a table. With this table, there are no issues.
6. To check all the tables in the entire database: CHECK < database > AT LEVEL ONE;
In the example below the CheckTable utility is check all three tables in the Manufacturing database.
*** WARNING: best to check when the database is not being actively used ***
7. To properly quit the CheckTable utility, type “quit;” making sure that the semi-colon is on the end: quit;
8. Exit the cnsterm screen by pressing ctrl -c: < ctrl -c >